Quickly highlight matching values in Excel with keyboard shortcut

By Susan Harkins
January 27, 2012, 6:42 AM PST
Takeaway: When you just need to see matching values and you don’t want to filter or sort, try this Excel keyboard trick.

There are numerous ways to find matching data in an Excel sheet. Filters are probably the most versatile. Sorting is probably the easiest way, but even that’s unnecessary if all you want to do is review matching values. In other words, if you don’t need the values rearranged or filtered, there’s a quicker way. Excel offers a keyboard shortcut trick that’s quick to implement and easy to remember.

Let’s work through an example using the sheet shown below. Specifically, let’s highlight all the beverage records as follows:

1.Highlight any cell in column G that contains the text value, Beverage.
2.Press [Ctrl]+[Space] to select column G.
3.Press [Ctrl]+[Shift]+\.

The combo in step 3 selects all the cells (in the column) that do not match the value in the active cell. It’s a bit counter intuitive, but it works great!

Error | Chazz's Computer Services

Error

The website encountered an unexpected error. Please try again later.

Error message

  • Warning: Cannot modify header information - headers already sent by (output started at /www/includes/common.inc:2608) in drupal_send_headers() (line 1239 of /www/includes/bootstrap.inc).
  • PDOException: SQLSTATE[HY000]: General error: 145 Table './mainsite/watchdog' is marked as crashed and should be repaired: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => cron [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:206:"SQLSTATE[HY000]: General error: 145 Table './mainsite/watchdog' is marked as crashed and should be repaired: SELECT w.wid AS wid FROM {watchdog} w ORDER BY wid DESC LIMIT 1 OFFSET 999; Array ( ) ";s:9:"%function";s:12:"dblog_cron()";s:5:"%file";s:31:"/www/modules/dblog/dblog.module";s:5:"%line";i:113;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://chazzservices.com/?q=node/7 [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => 34.238.189.171 [:db_insert_placeholder_9] => 1566318440 ) in dblog_watchdog() (line 154 of /www/modules/dblog/dblog.module).