ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   View Columns with filter enabled (https://www.excelbanter.com/excel-programming/425306-view-columns-filter-enabled.html)

Paddy Henderson

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

ryguy7272

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


Paddy Henderson

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


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com