Filter question...

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
 
B

Bernie Deitrick

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
 
Top