Exceljet

Quick, clean, and to the point

Move to right edge of data region

Windows shortcut

Ctrl→

Mac shortcut

⌃→

If the active cell is empty, Excel will stop on the first non-empty cell to the right. If the active cell is non-empty, Excel will stop on the last non-empty cell to the right.

On a Mac, the command key (⌘) can be used instead of the control key.

222 Excel Shortcuts for Windows and Mac

Related videos

How to move around big lists fast

A handy shortcut for hopping around large lists or tables. Much faster than scrolling.

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 right edge of data region

Related videos

Download 200+ Excel Shortcuts

Excel video training