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
- Inventory of finished goods
- Clarification on Documentation of Paid-Up Capital Contribution by Directors
- Tds on building rent monthly
- Applicability of Ind As to associate of associate
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Disallowance of Section 43B(h) to sez units
- Sale of property furniture sale
- RCM INVOICING FROM NOV-2024
- Confusion around Form 26QB fields
- GST Regis.
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding einvoice taken on nil rated sales
- Strategical investment in Public listed company
Trending Online Classes
CAclubindia
