View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stranded Stranded is offline
external usenet poster
 
Posts: 3
Default Displaying Cell Formulas

I would like to be able to view a column of data alongside the formulas used
to calculate the data. I'm aware that all of the formulas can be displayed
via Tools/Options/Formulas and that Ctrl~ will toggle between the formulas
and values. The best I've come up with so far is to copy the formulas and
convert them to text cell by cell. At worst, is there a function to convert
the formulas to text as a group?

--
Richard