Excel direct cell reference

Bloo_Fish · 28 Jan 2010 at 20:22

Hey,

In excel you can do '=Sheet1.$A$52' and by using the '$' this cell number is not changed when dragging it out into other columns - my question the is how can i get this dollar to be set when i just type in = and select a cell with the mouse? I am hoping i can just hold down another key or something...

This is going to save me a lot of time and hair if any one can help!

Big thanks!

s-p · 28 Jan 2010 at 21:28

I believe you can press F4 after you've selected the cell in question. However, I'm not sure if there's any key available that you can press at the same time as selecting the cell to ensure an absolute reference.

Lee · 28 Jan 2010 at 21:49

You can press F4 as above, it toggles the $ symbol.

Pho · 28 Jan 2010 at 21:53

I spent a good while today trying to get around this problem with vlookups, didn't know about the dollar sign or F4, cheers

.

Bloo_Fish · 1 Feb 2010 at 11:00

Thanks for your help, I am actually using OpenOffice - which uses shift+f4 - but this answer helped me figure that out!