Excel Formula Auditing

This query is : Resolved

Anirban Mitra (Querist)
Follow

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.

Pooja Chopda

Pooja Chopda (Expert)
Follow

09 May 2009 Hi Anirban,

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)

Anirban Mitra

Anirban Mitra (Querist)
Follow

10 May 2009

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Summarize this with AI

ChatGPT Perplexity Claude Google AI Grok