Excel Supreme

Moving around the workbook

Arrow keys, Ctrl and the End key move the active cell anywhere in the used range. Five combinations cover almost every trip you make across a sheet.

Shortcuts

Action Windows macOS Google Sheets
Move the active cell one cell in any direction Arrow keys Arrow keys Arrow keys
Jump to the edge of the block of data CtrlArrow key CommandArrow key CtrlArrow key
Go to the last cell that holds data CtrlEnd CommandEndFn + Command + Right Arrow on a laptop CtrlEnd
Return to the top left corner CtrlHome CommandHomeFn + Command + Left Arrow on a laptop CtrlHome
Move one screen down Page Down Page Down Page Down
Move one screen right AltPage Down OptionPage Down No default drag the scrollbar instead
Move one screen left AltPage Up OptionPage Up No default drag the scrollbar instead
Jump to the next worksheet CtrlPage Down OptionRight Arrow No default click the tab instead
Jump to the previous worksheet CtrlPage Up OptionLeft Arrow No default click the tab instead
Go to a cell you name CtrlG CtrlG No default type the address in the Name box
Move to column A of the current row Home Home Home
Move to the last cell of the current row End End No default Ctrl + Right Arrow stops at the end of the block

When to use it

Reach for these before you touch the scrollbar. A sheet with four thousand rows is mostly empty below the data, so scrolling lands you in blank space. Ctrl + Arrow stops at the last cell that holds something.

The trip that surprises people is a sheet imported from another tool. A column arrives with trailing spaces in some rows, and Ctrl + Down stops early at the row where those spaces begin. If you land somewhere unexpected, look for a cell that looks empty and is not.

Checked against

Microsoft 365 Apps for Windows, version 2501, checked on 24 February 2026. Excel for Mac 16.91 on the same day, where Fn stands in for the End and Home keys a laptop does not have. Google Sheets in Chrome 131, where the sheet tabs have no default chord and the menu is the honest answer.

Practice

Practise it: Select to the edge of a block

Select to the edge of a block asks for the extended version of these keys and grades the press itself.