Query on Filling up Excel sheet with zero

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.

 

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

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details