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