up vote 2 down vote favorite
2
share [g+] share [fb]

If you build a formula by clicking on a cell to insert its address into the formula, is there a way of making this reference absolute rather than relative?

I've been using Excel for many years but never come across a way of doing this. I've tried the obvious SHIFT+ click, CTRL+click and ALT+click.

link|improve this question
72% accept rate
feedback

1 Answer

up vote 11 down vote accepted

Click the cell and then hit F4. As you keep hitting F4, it will cycle through various level of absolute.

Example:

  • Click the cell A1, type '=', then click the cell B1.
  • Hit F4. The reference to B1 becomes $B$1.
  • Hit F4 again. The reference becomes B$1.
  • Hit F4 again. The reference becomes $B1.
  • Hit F4 again. The reference returns to B1.
link|improve this answer
+1 - beat me to it :) – warren Sep 1 '09 at 6:52
Spot on, cheers. – Lunatik Sep 1 '09 at 7:34
@pelms - the link you provided does not exist anymore. Any idea where was the question moved to? – ysap Apr 15 at 23:08
@ysap It probably wasn't kept, IIRC the link was a bit of a laundry list which I think the network now tries to discourage. – Margaret Apr 16 at 0:31
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.