View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
BriSwy BriSwy is offline
external usenet poster
 
Posts: 21
Default Converting Cell References

You can go to the Edit Menu and select Replace. In the "Find What:" box,
enter $. In the "Replace With:" box, leave it blank. With the cells
highlighted in your sheet where you would like to remove the absolute
references, click replace all. It will remove all of the $.

"billbrandi" wrote:

Is there a quick way to convert fixed cell references ($row$column) to
eliminate the $ without editing the formula and deleting the $ one keystroke
at a time? Sure would save me a lot of time.

Thanks
Bill Falzone