| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Exel Auto Filter
I want to use auto filter on columns, but I have cells that are blank and
when I use the drop down on the auto filter, its doesnt pick up anything after the blank cells. Is there a way around this, as I do need to have blank cells in my columns. Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Exel Auto Filter
Select all data first Dave before you turn on AutoFilter
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave" wrote in message ... I want to use auto filter on columns, but I have cells that are blank and when I use the drop down on the auto filter, its doesnt pick up anything after the blank cells. Is there a way around this, as I do need to have blank cells in my columns. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| How do I "auto save" my file in MsOffice2003 Exel? | Charts and Charting in Excel | |||
| auto numbering an exel work book sheet everytime it opens or print | Excel Discussion (Misc queries) | |||
| how to auto save in exel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
