excel shortcut
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
02 August 2010
Dear Sir
is there any way of segregating numeric figures in excel worksheet into those of which coming out of reference to other cells and those of which coming from direct keying in?
Rgds
Ganesh
is there any way of segregating numeric figures in excel worksheet into those of which coming out of reference to other cells and those of which coming from direct keying in?
Rgds
Ganesh
16 May 2012
Select the whole sheet. Then press Ctrl+G. Then click on Special. Select Formulas. All the formulas in the sheet will be selected. Colour the highlighted cells. Now you can identify from that colour the cells which contain formula.
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
- CG Tax On residential property
- Post Office RD Interest
- Applicable TDS for Purchase of Flat from NRI
- Eway bill for machinery reparing
- Building and other construction workers welfare cess act 1996
- ITR 3 FILING OF AN INDIVIDUAL (PARTNER IN A PARTNERSHIP fIRM)
- Gift of mutual fund units to daughter
- Bank Accounts in Balance Sheet for ITR 3
- NRI ITR2 account in 2025-26 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.
- Annual return of gst limit
- Reporting of STCG on Property in ITR
- Error while filling exam form November 2026
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
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
