| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to auto fill zero in a area
I have this small and quick question but I don't know how to do it without
knowing anything about Excel Functions. Any help would be really appreciated! :D In an area, say from column A to Z, Row 2 to 20, some of the cells have a number in it, but some of the cells are left blank, is there any way to just highlight this whole area, and use least steps to fill in all blank cells with number "0"? Thank you all in advance! : D |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to auto fill zero in a area
Select A2 to Z20.
Hit <F5 Click "Special" Click "Blanks" Then <OK Key in 0, Then <Ctrl <Enter And you should have what you're looking for! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "diablo9" wrote in message ... I have this small and quick question but I don't know how to do it without knowing anything about Excel Functions. Any help would be really appreciated! :D In an area, say from column A to Z, Row 2 to 20, some of the cells have a number in it, but some of the cells are left blank, is there any way to just highlight this whole area, and use least steps to fill in all blank cells with number "0"? Thank you all in advance! : D |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to auto fill zero in a area
thanks a lot man!
:D :D :D "Ragdyer" wrote: Select A2 to Z20. Hit <F5 Click "Special" Click "Blanks" Then <OK Key in 0, Then <Ctrl <Enter And you should have what you're looking for! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "diablo9" wrote in message ... I have this small and quick question but I don't know how to do it without knowing anything about Excel Functions. Any help would be really appreciated! :D In an area, say from column A to Z, Row 2 to 20, some of the cells have a number in it, but some of the cells are left blank, is there any way to just highlight this whole area, and use least steps to fill in all blank cells with number "0"? Thank you all in advance! : D |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to auto fill zero in a area
Thanks for the feed-back.
You're the second today with exactly the same solution.<g -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "diablo9" wrote in message ... thanks a lot man! :D :D :D "Ragdyer" wrote: Select A2 to Z20. Hit <F5 Click "Special" Click "Blanks" Then <OK Key in 0, Then <Ctrl <Enter And you should have what you're looking for! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "diablo9" wrote in message ... I have this small and quick question but I don't know how to do it without knowing anything about Excel Functions. Any help would be really appreciated! :D In an area, say from column A to Z, Row 2 to 20, some of the cells have a number in it, but some of the cells are left blank, is there any way to just highlight this whole area, and use least steps to fill in all blank cells with number "0"? Thank you all in advance! : D |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to auto fill zero in a area
Select your range ctrl H Find what: leave it blank Replace with: 0
Replace All "diablo9" wrote: I have this small and quick question but I don't know how to do it without knowing anything about Excel Functions. Any help would be really appreciated! :D In an area, say from column A to Z, Row 2 to 20, some of the cells have a number in it, but some of the cells are left blank, is there any way to just highlight this whole area, and use least steps to fill in all blank cells with number "0"? Thank you all in advance! : D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill in | Excel Discussion (Misc queries) | |||
| Auto fill, I Think | Excel Discussion (Misc queries) | |||
| using auto fill edit or fill handel | Excel Worksheet Functions | |||
| Fill an area between 2 curves in an Excell chart? | Charts and Charting in Excel | |||
| Fill area beneath a scatter plot | Charts and Charting in Excel | |||
Hybrid Mode
