Microsoft Excel – selecting cell ranges

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.

Leave a Reply

Your email address will not be published. Required fields are marked *