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

%3CLINGO-SUB%20id%3D%22lingo-sub-1178323%22%20slang%3D%22en-US%22%3EHow%20to%20get%20to%20the%20last%20line%20with%20data%20in%20an%20Excel%20workbook%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178323%22%20slang%3D%22en-US%22%3E%3CP%3EI%20track%20staff%20attendance%20on%20an%20Excel%20workbook.%20I%20access%20it%20using%20O365.%20I%20am%20looking%20for%20an%20easier%20way%20to%20get%20to%20the%20next%20blank%20row%20in%20the%20file%20instead%20of%20scrolling%20down%201000%2B%20rows%20each%20day.%20I've%20tried%20the%20Ctrl%20%2B%20%22down%20arrow%22%20key%20and%20it%20does%20not%20work.%20Am%20I%20missing%20something%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ESean%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1178323%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178351%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20to%20the%20last%20line%20with%20data%20in%20an%20Excel%20workbook%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178351%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F560969%22%20target%3D%22_blank%22%3E%40seanp413%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello%2C%20you%20can%20use%20CTRL%20%2B%20Down%20Arrow%20on%20your%20keyboard%20(without%20the%20plus%20sign)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20it%20doesn't%20work%2C%20kindly%20be%20sure%20that%20it%20is%20not%20the%20problem%20with%20your%20keyboard%20because%20the%20shortcut%20always%20works%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178362%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20to%20the%20last%20line%20with%20data%20in%20an%20Excel%20workbook%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178362%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F560969%22%20target%3D%22_blank%22%3E%40seanp413%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECtrl%2BDown%20shall%20work%20if%20you%20have%20no%20empty%20cells%20in%20the%20middle.%20If%20they%20are%20you%20may%20try%20Ctrl%2BEnd%20to%20jump%20on%20most%20down%20right%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

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