Fillig up excel sheet with zeros
This query is : Resolved
01 May 2009
I have a big excel worksheet where I have filled up numbers in some cells. In the cells which dont have numberes or forumulas I want to have "0"(zero). What is the short cut for this? Can this be done in one go?
Thanks.
Thanks.
01 May 2009
hi Anil,
write 0 in one cell. copy it (ctrl+C). Now select the area where you want 0 in blank cells (be sure the selection only has numbers & no text). Now paste special (Alt+E+S) select 'Add' & press enter.
Pls feel free to ask again if you have any problem doing this.
write 0 in one cell. copy it (ctrl+C). Now select the area where you want 0 in blank cells (be sure the selection only has numbers & no text). Now paste special (Alt+E+S) select 'Add' & press enter.
Pls feel free to ask again if you have any problem doing this.
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
- Off Market debit and credit transaction
- Showing Gift from relative in ITR for this year
- Share accounting-->fifo - capital gain - period as per fifo?
- ITR selection for salaries and capital gain less than L
- Short Term Capital gain on shares bought and sold after 2018 onwards
- Treatment of Pension ?annuity returns on PMVY
- ITR filing- non tax audit cases- Asstt.Year 2026-2027
- Soyabean hsn code and gst rate
- Regarding IMS Mandatory from 1st July 2026
- Free lancer income
- TDS on payment to CHA as per new section
- Sale of Forign Shares
- INCOME TAX ON REDEVELOPEMENT OF FLAT
- Form 10E u/s 89(1). Need clarification because experts opinions differ !!!!
- Gst invoice numbering and delivery challan numbering
- Standard Deduction claim for EPFO Pension and ICICI Prudential Life Annuity
- Small dealers gst returns filing
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
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
