Name
×

Navigate and Select Multiple Cells with Control and Shift

These shortcuts boost your speed navigating around an Excel workbook and selecting multiple cells. There's a reason these shortcuts were listed as essential in 100 quick excel tips. While a bit awkward to master at first, these shortcuts may be one of the most important factors in boosting your speed in Excel.


Jump to First or Last Populated Cell

To quickly "jump" to the next populated cell in Excel, you can hold Control and press the arrow key in the direction of the desired cell. This also works to jump to the last populated cell from within a range of populated cells.

Hold Control and press an arrow key

+ ➡



Select the Next Cell Over

In order to select both the current cell, and the next cell(s) immediately adjacent, you can hold Shift and press an arrow key. This will expand the selected range by one cell each time you press the arrow key. You can expand the selection range mutiple times vertically and horizontally.

Hold Shift and press an arrow key

+ ➡



Select All Consecutive Populated Cells

To select an entire range of populated cells, hold Control and Shift and press the arrow key. This will select the entire range of populated cells.

Hold Control and Shift and press an arrow key

+ + ➡


Excel Exercises With Control/Shift Shortcuts

As with all Excel shortcuts, the best way to learn is by practicing hands-on exercises.

Try some Excel exercises with Control Shift shortcuts now!