What is the key shortcut for absolute cell reference?

R

RM in Augusta

When selecting a cell to enter into a formula, there is a key or key
combination that will automatically make the cell an absolute cell reference
when you point-and-click. You can also highlight the cell reference in the
formula and use the shortcut to make it an absolute cell reference. This
saves typing the "$" sign. Help! I can't remember it.
 
C

chris.cudmore

F4 will cycle you through the options.

eg:
Type A2 --> A2
F4 --> $A$2
F4 --> $A2
F4 --> A$2
F4 --> A2

(The order might be different for the two half-absolutes)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change a cell reference from relative to absolute 2
VBA for Dependents shortcut menu 0
Excel Shortcut Key 1
Change relative to absolute references in a block of cells 3
Is there an absolute reference shortcut? 2
Cell referencing 1
absolute reference in linked files 3
FIXED CELLS 0

Top