Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
 
Posts: 189
Default Formula

HI,

in the menubar
Edit|Go to|Special|check the formulas check box|Ok

This will display the cells having formulas in them
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Neil Pearce" wrote:

Good morning all,

I'm checking a spreadsheet prodcued by another person in the office.

Some of the values in the cells are created using a formula, others are hard
numbers inputted directly into those cells.

Is there a way of easily distinguishing between the two? Prefereably
through the use of an IF formula?


Thanks in advance,

Neil