Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blanks at end of worksheet
I am using the auto-filter. In the dropdown list, one of the choices is
"Blank". When I select "Blank" I get the rows past the end of the list. I tried selecting these rows and deleting but the auto-filter still shows the blank rows. Other worksheets don't do this. How can I keep these blank rows out of the auto-filter selection? Thanks, Joe M. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blanks at end of worksheet
Deselect the Autofilter, then select the range of rows you want to include
in the list before re-selecting the Autofilter. -- David Biddulph "Joe M." wrote in message ... I am using the auto-filter. In the dropdown list, one of the choices is "Blank". When I select "Blank" I get the rows past the end of the list. I tried selecting these rows and deleting but the auto-filter still shows the blank rows. Other worksheets don't do this. How can I keep these blank rows out of the auto-filter selection? Thanks, Joe M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct copying blanks or how to insert zero into blanks | Excel Worksheet Functions | |||
copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
no blanks | Links and Linking in Excel | |||
If and blanks | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |