Zeros in Cells

[Lyn]

I have a spreadsheet someone else started and I need Zeros to show up in a
range of blank cells. The blank cells are in no particular order and the
other cells are filled so there is no easy way to cut and paste.

 

[JLatham]

You mean that there is no formula or value in these "blank" cells now? If
that's the case, then you're going to have to put a 0 or something that
evaluates to zero in them.

Also, be sure that in Tools | Options and on the [View] tab that the "Zero
Values" has a checked box next to it.

Without knowing quite a bit more about the sheet, it's difficult to give you
better advice than that at the moment.

 

[Gary''s Student]

Select one of your blanks with the mouse. Then select other blanks with the
mouse, but with the CNTRL key held down.

This allows you to select multiple cells at the same time

Then click in the fornula bar; touch 0; then touch CNTRL-ENTER rather than
just ENTER.

This will put a 0 in all the cells you have selected.

Try it on a blank worksheet first

 

[Lyn]

Yes, there is currently no value in these cells.....and yes, Zero Values is
already checked. I was hoping there might be a quick macro that is written
out there.

You mean that there is no formula or value in these "blank" cells now? If
that's the case, then you're going to have to put a 0 or something that
evaluates to zero in them.

Also, be sure that in Tools | Options and on the [View] tab that the "Zero
Values" has a checked box next to it.

Without knowing quite a bit more about the sheet, it's difficult to give you
better advice than that at the moment.

I have a spreadsheet someone else started and I need Zeros to show up in a
range of blank cells. The blank cells are in no particular order and the
other cells are filled so there is no easy way to cut and paste.

 

[Lyn]

Rockin' That worked awesome!

Select one of your blanks with the mouse. Then select other blanks with the
mouse, but with the CNTRL key held down.

This allows you to select multiple cells at the same time

Then click in the fornula bar; touch 0; then touch CNTRL-ENTER rather than
just ENTER.

This will put a 0 in all the cells you have selected.

Try it on a blank worksheet first

 

[KIM W]

Excel has a bulit in capability to select all blank cells in one step:

Ctl+G is one way to get you to "Go To" dialog box... then use "Special" and
select radio button for blanks. This will highlight all blank cells in the
entire selected range.
Then you use the ctl+enter method to place the zero in all the selected
cells at one time. Very fast and you won't miss any cells.

 

[JLatham]

Good to see that Gary''s Student came up with the solution for you. Sharp
tool, that Student!!

Yes, there is currently no value in these cells.....and yes, Zero Values is
already checked. I was hoping there might be a quick macro that is written
out there.

You mean that there is no formula or value in these "blank" cells now? If
that's the case, then you're going to have to put a 0 or something that
evaluates to zero in them.

Also, be sure that in Tools | Options and on the [View] tab that the "Zero
Values" has a checked box next to it.

Without knowing quite a bit more about the sheet, it's difficult to give you
better advice than that at the moment.

I have a spreadsheet someone else started and I need Zeros to show up in a
range of blank cells. The blank cells are in no particular order and the
other cells are filled so there is no easy way to cut and paste.