Use Shortcut Keys to Evaluate Data in MS Excel

Dennis Faas's picture

You can use shortcut keys when evaluating row data in MS Excel.

Let's say you had 35 sales during the past year. You list each sale in Row 1, starting in Column B and you list each sales region in Column A. For each sale, you enter the response rate for each area.

To see which sales had a 75% response rate for the Eastern area, follow the steps below:

  1. In the Eastern area row, click on the first cell that contains 75.
     
  2. Press Shift | Space to select the entire row.
     
  3. Press CTRL | \ in a selected row.

Excel will select all the cells that did not match the active cell so you can see which sales had a 75% response rate.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

Rate this article: 
No votes yet