View Single Post
  #1  
Old May 10th, 2010, 07:32 PM posted to microsoft.public.excel.setup
MDV
external usenet poster
 
Posts: 4
Default 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