Hints and tips home » Excel hints and tips » Get to the end of the used range

Get to the end of the used range

What’s the quickest way to get to the bottom right of the used range in your spreadsheet? The two-handed method is Ctrl+End (hold down Ctrl and press End). The one-handed method is End Home (press and release End, and then press and release Home).

The last cell so selected may appear to be empty. However, there is a cell in that row that has an entry or a format and there is a cell in that column that has an entry or format.

Added by Alan on 16th September 2006

More Excel hints and tips, like:

• Checking formulas with multiple operators
• Printing spreadsheets without opening them first
• Use the SUBTOTAL function in Excel