ExcelBanter - I want Excel to regard emply cells as zero and display it

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I want Excel to regard emply cells as zero and display it (https://www.excelbanter.com/excel-discussion-misc-queries/123702-i-want-excel-regard-emply-cells-zero-display.html)

gencerm

I want Excel to regard emply cells as zero and display it

on a selected area in the worksheet.

Teethless mama

I want Excel to regard emply cells as zero and display it

Select your range then go to menu Data Filter AutoFilter Blanks enter
all 0

"gencerm" wrote:

on a selected area in the worksheet.

Gord Dibben

I want Excel to regard emply cells as zero and display it

Another method..........

Select the range.

F5SpecialBlanksOK

Type 0 in active cell then hit CTRL + ENTER

Gord Dibben MS Excel MVP

On Mon, 25 Dec 2006 11:43:01 -0800, Teethless mama
wrote:

Select your range then go to menu Data Filter AutoFilter Blanks enter
all 0

"gencerm" wrote:

on a selected area in the worksheet.

All times are GMT +1. The time now is 05:30 AM.