Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter question...
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter question...
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 "sameer27p " wrote in message ... Hi, i have a filter on the item numbers in a sheet.but when i use this filter,the row number changes for each sheet.i need to print out these reports.so the records that i get after using the filter should start from row 1 instead of 456 or 345.....How do i do this ? do i have to change any setting in the filter ? Regards --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter question | Excel Discussion (Misc queries) | |||
Filter Question | Excel Discussion (Misc queries) | |||
Filter question? | Excel Discussion (Misc queries) | |||
Filter Question | Excel Discussion (Misc queries) | |||
Filter Question | Excel Discussion (Misc queries) |