Shifty Tricks in Excel

You probably know a few ways to use the Shift key in Excel, to extend the cells that you have selected. For example:

  • Click on a cell, then hold the Shift key, and click on another cell. All the cells in between are selected.
  • Hold the Shift key while you use the arrow keys, and cells will be selected as you move.

Here are a couple more Shift tricks:

  • Select a cell, then click in the Name box, at the left side of the Formula Bar. Type the address of another cell, then hold the Shift key, and press Enter. The entire range will be selected.

  • Select a starting cell, then hold the Shift key, and select a named range from the Name box drop down list.