09 May 2009
How can I check at a glance that all the formulas in a worksheet (whether simetric formula/not)are correctly given or not while I am auditing some calculation in a worksheet? Formula auditing mode (so far as I know) displays the path of the formula given in a particular cell and not that of all the formulas at a time.
If u want to check formulas in excel sheet, there are two ways. 1 Check 1 cell's formula & then copy it to all cells in row/column that should have same formula.
2 Display all the formulas at one time ( I think this is what u want)- press ctrl+ (the key to the left of 1)
CAclubindia
