Excel Formula Auditing
This query is : Resolved
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.
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)
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
- Tax on Deemed Capital Gain
- Exiting partner in partnership firm in gst portal
- Type of Capital Gain
- TDS _Long term Capital Gain ref.sec 214 Table 2
- Banking Related Issue
- Traces submitting correction statement error
- ITR-Capital Gain
- ITR-3 File/Error Found
- Rent claimed on building given on permissive possession basis
- IT returns for fresh job holders
- Account freezed for Ineligible ITC Scrutiny for GST Annual Return
- TDS on property - Form 141 query
- Seeking Advice: High Tax Shortfall on Job Switch + Let-Out House Property Loss in FY 2025-26
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
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
