View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default 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