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

Copper Contributor

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

2 Replies

@seanp413 

 

Hello, you can use CTRL + Down Arrow on your keyboard (without the plus sign)

 

If it doesn't work, kindly be sure that it is not the problem with your keyboard because the shortcut always works

@seanp413 

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.