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!
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!