I have a big excel worksheet where I have filled up numbers in some cells. In the cells which dont have numberes I want to have "0"(zero). What is the short cut for this? Can this be done in one go?
Thanks.
9 Replies
Prashanth hegde
(Chartered Accountant)
(41 Points)
Replied 01 May 2009
Go to Data-> Filter-> Click on Auto filter. Then click on the filter button of the couloumn in which yo want to insert '0', there you select "blank"s as the selection criteria, and then fill 0 in one coloumn and copy paste to all other coloumns.
Sumit Jain
(CA)
(4760 Points)
Replied 01 May 2009
didnot understand ur query
plz explain it proper yaar
Jitendra
(Student)
(30 Points)
Replied 01 May 2009
| Originally posted by :Anil | ||
| " | I have a big excel worksheet where I have filled up numbers in some cells. In the cells which dont have numberes I want to have "0"(zero). What is the short cut for this? Can this be done in one go? Thanks. |
" |
1. Type 1 in any of the corner cell of the any of the sheet. Then select it and copy it.
2. Select the range of cell, where you entered the data and blank cell as well.
3. Alt+E+S and then m and finally press enter.
Thanks
Jitendra
Thakkar Hiren C
(Sr Accountant )
(118 Points)
Replied 01 May 2009
First Select that particular portion and after that press ctrl + F and select replace on top of the pop windows after that put blanck find with and put 0 in the replace with and press replace all and ok
Manmohan ACA, CS
(Chartered Accountant )
(14243 Points)
Replied 02 May 2009
Recent Topics
- CLAIMING OF U CLAIMED RCM
- Building construction works
- REGARDING GSTR-9 F.Y 2023-24
- Rectification to decrease income in SCHEDULE OS
- Can Statutory Auditor of a subsidiary become concu
- Client Asking for the Revised Invoice
- Share office desk in bkc, near family court
- 80D claim for payment paid by parent
- TDS on purchase of Flat under subvention scheme be
- GST registration for medical shop in Karnataka
Related Threads
CAclubindia
