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

Highlighted

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