Exceljet

Quick, clean, and to the point

Move to last cell in worksheet

Windows shortcut

CtrlEnd

Mac shortcut

Fn⌃→

The last cell is at the intersection of the last row that contains data and the last column that contains data. The last cell may or may not contain data.

222 Excel Shortcuts for Windows and Mac

Comments welcome! Read this before posting a question.

I now work for a homeless charity and wanted to be able to see how many rooms we have free in the hostel at any given time without manually counting them each time. I knew there would be a way to do it but didn't know how! I spent only a couple of minutes on your site and found the answer: I needed "countif" instead of "count" which I'd been trying and it worked straight away once I got my brackets in the right place!! -Annette

Move to last cell in worksheet

Download 200+ Excel Shortcuts

Excel video training