Filter question...

  • Thread starter Thread starter sameer27p
  • Start date Start date
S

sameer27p

Hi,
i have a filter on the item numbers in a sheet.but when i use thi
filter,the row number changes for each sheet.i need to print out thes
reports.so the records that i get after using the filter should star
from row 1 instead of 456 or 345.....How do i do this ? do i have t
change any setting in the filter ?

Regard
 
Sameer,

Filtering doesn't move items around, it simply hides those that don't meet
the criteria. Printing a filtered sheet will print only the items showing -
just don't use inserted pagebreaks.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lastrow function help 6
VBA: How can I use a string variable as autofilter criteria? 4
How do I identify range of filtered sheet? 5
Advance Filter 4
Is it possible to just act on the filtered data 2
Last used row within filter 5
Storing Multiple Selected Pivot Table Report Filter Values 2
Help with my macro 8

Back
Top