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
- STCG....................................................
- TAN for Partnership
- Sales return eway bill
- AMOUNT RECEIVED UNDER COMPULOSRY ACQUISITION OF AGRICULTURAL LAND
- E way bill for tractors
- GST ON DAMAGED GOODS
- Taxation on LTCG for property sold after 24JUL2024
- Is it compulsory to File 10E if Income including Pension Arrears is below 12 Lakh for the F Y 25 26
- REGARDING GST LIABILITY/....
- STCG FOR GOLD ETFs
- Section 54F - Exemption on LTCG in 2026 for HP purchased in 2023
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- Nomination of Bank for refund in itr 2
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
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
