02 August 2010
Dear Sir is there any way of segregating numeric figures in excel worksheet into those of which coming out of reference to other cells and those of which coming from direct keying in?
16 May 2012
Select the whole sheet. Then press Ctrl+G. Then click on Special. Select Formulas. All the formulas in the sheet will be selected. Colour the highlighted cells. Now you can identify from that colour the cells which contain formula.
CAclubindia
