Query on Filling up Excel sheet with zero

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

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