View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Auto-filter includes too much range

Insert a completely empty row between your data that should be filtered and that
last couple of rows.

Atreides wrote:

Hi

I select a range (e.g. A6:Z267) and then apply the auto-filter. However once
the filter is applied it has picked up down to row 269 - i.e. rows below
where it should have stopped. How can I fix this?

Thanks

Atreides


--

Dave Peterson