What is the key shortcut for absolute cell reference?

G

Guest

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
absolute reference in linked files 3
Absolute and Relative Cell References 1
absolute cell reference macro 4
advanced relative cell reference 1
Absolute Reference 4
Absolute cell reference and REF error 1
copy-paste started misbehaving (cell reference wrong) 1

Top