Excel – Quickly Find the Last Entry in a Column

If you need to find the last entry in a column of data in Excel, you can spend a lot of time scrolling – especially if there are hundreds or thousands of rows.

Good news – there is a shortcut.

Ctrl+Down Arrow

Click any cell in the column you wish to get to the bottom of, press Ctrl+Down arrow, and Excel will scroll down the column until it finds a blank cell, then stops just above it, displaying that cell as the Active cell.


For great time-saving tips, look up our Archive of Tech Tips or look through the Technology Information for Staff website.

Was this tip helpful to you? Anything else you want to know? Please leave a comment below.

You’ll find more learning at Learning and Development.