Selecting Cells In A Range
Select a cell in a range and hold down the Shift + Ctrl + down arrow to select the rest of the cells beneath the selected cell within the cell range that contain data.
Similarly, Shift + Ctrl + right arrow to select cells to the right in a row that contain data.
Moving To The End Of A Cell Range
Double click on the bottom edge of a cell (NOT the Fill Handle) to move quickly to the last cell in the range.
Or the right edge to move to the last cell to the right.
Or the top border … etc!
Find out more about our Microsoft Excel training.