By using shortcut.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

73 Shortcuts for Excel

Shortcut 29 - F4 - Toggle Addressing A1 -> $A$1 -> A$1 -> $A1 -> A1

While editing a cell you can continually press the F4 key to change the addressing mode.

The purpose of "Addressing Mode" is what action is taken when you copy/paste a cell.

Addressing Mode	Purpose
A1	Relative
$A$1	Actual
A$1	Row Relative
$A1	Column Relative