| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Columns with filter enabled
Hi all,
I have a workbook with several sheets with filters acting on columns within the sheet. If I apply a filter, it acts on all columns. My question is how can I set it up so the filters only act on columns A-P? Or is it easier to set it up so filters do not act on columns O? Paddy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
View Columns with filter enabled
Select A1:O1. Data Filter AutoFilter.
Or, did I miss something here? Ryan--- -- RyGuy "Paddy Henderson" wrote: Hi all, I have a workbook with several sheets with filters acting on columns within the sheet. If I apply a filter, it acts on all columns. My question is how can I set it up so the filters only act on columns A-P? Or is it easier to set it up so filters do not act on columns O? Paddy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
View Columns with filter enabled
ryguy7272 wrote:
Select A1:O1. Data Filter AutoFilter. Or, did I miss something here? Ryan--- Ryan, Tried that but still doesnt work paddy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I view filter list used? | Excel Discussion (Misc queries) | |||
| Delete rows in filter view | Excel Worksheet Functions | |||
| How do you use filter to view duplicated records in Excel? | Excel Discussion (Misc queries) | |||
| View & Filter Worksheet | Excel Discussion (Misc queries) | |||
| Detect if a command bar is enabled in View-Toolbars | Excel Programming | |||
Linear Mode
