How to get to the last line with data in an Excel workbook?

Question

I track staff attendance on an Excel workbook. I access it using O365. I am looking for an easier way to get to the next blank row in the file instead of scrolling down 1000+ rows each day. I've tried the Ctrl + "down arrow" key and it does not work. Am I missing something?

Thanks,

Sean

abiola1 · Answer

seanp413&nbsp;
&nbsp;
Hello, you can use CTRL + Down Arrow on your keyboard (without the plus sign)
&nbsp;
If it doesn't work, kindly be sure that it is not the problem with your keyboard because the shortcut always works

sergeibaklan · Answer

seanp413&nbsp;
Ctrl+Down shall work if you have no empty cells in the middle. If they are you may try Ctrl+End to jump on most down right cell.

Forum Discussion

How to get to the last line with data in an Excel workbook?

2 Replies

Resources