| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want Excel to regard emply cells as zero and display it
on a selected area in the worksheet.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
