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.
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.
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.
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.
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!