LIVE GST Certification Course by CA Arun Chhajer begins 27th April. Register Now!!

Query on Filling up Excel sheet with zero

Anil (1638 Points)

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 I want to have "0"(zero). What is the short cut for this? Can this be done in one go?

Thanks.

Reply
Follow
Share

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

(Guest)

its working, thanks

Anil (1638 Points)
Replied 01 May 2009

Thank you Mr.Jitendra. It is working.

Anil.

Rashmi (CA) (83 Points)
Replied 01 May 2009

Hi....nice formula... thank u!!

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