Shortcut for Makeing a Cell CONSTANT

[timprust]

I have a large spreadsheet with no 'real' order and I'm tring to make it quicker when entering a bunch of formulas. I was wondering if there was a way to click on a cell while holding down a key (perhaps), so that when you click the cell it automatically makes the selected cell constant (by putting the '$' in front of the column and row). Can anyone help?

Thanks

 

[taigovinda]

Welcome to the board!

Check out post #6 in this thread: http://www.mrexcel.com/forum/showthread.php?t=408202&highlight=absolute+cells

You can put that into a module (press control+F11, then insert -> module and paste in the code) and you can assign a shortcut key to it (press alt+F8, choose the macro, click options and pick your shortcut key, which can include shift or just control).

 

[meldoc]

hello

See the link.

http://www.youtube.com/watch?v=_PBPU_5jTUA

Be warned it is a long video, but you will not have to watch it all unless you want too.

 

[timprust]

Thanks for the quick responses. This is very helpful and works.

Thanks Again.

Tim

 

[timprust]

Ok, I now have another question. I have rows and rows of a column that has a formula in it that I need to just be a number and not a formula. I know how to do this in one cell by: copy the cell and then paste special and use value only, but my question is..Is there a way that I could copy this down to all the rows? I need each cell to be the value of its formula, but each cell has a different value, so how do I copy this procedure quickly to all the others?

Thanks in advance for all the help.

Tim

 

[Sandeep Warrier]

Ok, I now have another question. I have rows and rows of a column that has a formula in it that I need to just be a number and not a formula. I know how to do this in one cell by: copy the cell and then paste special and use value only, but my question is..Is there a way that I could copy this down to all the rows? I need each cell to be the value of its formula, but each cell has a different value, so how do I copy this procedure quickly to all the others?

Thanks in advance for all the help.

Tim

Copy the entire range and do a paste-special > Values. If your formula calculates to different numbers, paste-special wont change it.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[meldoc]

Hello again Tim

Another video see link.

http://www.youtube.com/user/bjele123#p/search/9/PB48p3d6vmw