Excel Formula Auditing
This query is : Resolved
Anirban Mitra
(Querist)
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
(Expert)
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)
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
(Querist)
10 May 2009
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Depreciation Chart Companies Act
- GST Audit whether Govt Companies are exempt?
- PTRC Show Cause Notice on Email
- Accounting treatment of AMC alongwith the purchase of Laptop
- Unable to File TDS Q2 Return – New TRACES Portal Error
- Issuing of delivery challan by seller of goods
- Taxation of crypto futures in India Fy 2026- 2027
- Transfer of Physical Stock Between Two Proprietorship Concerns
- MSME disclosure and disallowance
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
