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.
Menu
Query on Filling up Excel sheet with zero
Replies (9)
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.
didnot understand ur query
plz explain it proper yaar
| 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
its working, thanks
Thank you Mr.Jitendra. It is working.
Anil.
Hi....nice formula... thank u!!
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
Thakkar Hiren C is right
theanks
Recent Topics :
- Consultation
- E-way notices2222
- Gst file not created
- Regarding 3CEB query
- Omitted E-Commerce Sales Reported in Table 14 but
- Omitted sales shown in GSTR-1 Table 14 but not in
- EWAY BILL TAKE OUT OF OTHER COMPAMY
- Penalty & late fee for late ITR filing
- Business discontinued as Government took possessio
- Which Aviation Services Can Air Ticketing Professi
Related Topics :
CAclubindia
