If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to globally insert $ signs in front of all cell refereces?
Is there a way to insert $ signs in front of certain cell characters on a
global basis? I am facing having to click on each cell reference in a large spreadsheet and hit F4 each time to insert the $ signs to anchor the cell reference. If anyone knows of a way to change the entire spreadsheet to insert the $ signs into each cell reference, I would very much appreciate hearing from you. Thank you, Mary |
Thread Tools | |
Display Modes | |
|
|