Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a master order sheet. I enter orders on this master daily. Not the
same items are ordered every day. I just want to print out the rows that have items ordered on them without having to delete the blank rows?? Thanks in advance Carol |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try DataFilterAutofilter
Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 13:20:02 -0800, CarSum wrote: I have a master order sheet. I enter orders on this master daily. Not the same items are ordered every day. I just want to print out the rows that have items ordered on them without having to delete the blank rows?? Thanks in advance Carol |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Carol,
I don't have a very clear idea of what's going on on this sheet, but I wonder if an Autofilter might let you hide the rows that are empty before you print. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "CarSum" wrote in message ... I have a master order sheet. I enter orders on this master daily. Not the same items are ordered every day. I just want to print out the rows that have items ordered on them without having to delete the blank rows?? Thanks in advance Carol |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a order spreadsheet that I enter amounts ordered into on different
lines. When I print out the order all the line print out unless I delete the ones that are blank. I was wondering if there was a way to just print out the rows that have something ordered written in them?? I need heading to print out as well that happen to be inbetween the ordered items. Confused yet I am. "Earl Kiosterud" wrote: Carol, I don't have a very clear idea of what's going on on this sheet, but I wonder if an Autofilter might let you hide the rows that are empty before you print. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "CarSum" wrote in message ... I have a master order sheet. I enter orders on this master daily. Not the same items are ordered every day. I just want to print out the rows that have items ordered on them without having to delete the blank rows?? Thanks in advance Carol |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
and AutoFilter does not work because ?
see links for filtering in http://www.contextures.com/tiptech.html Data that is filtered out will not be copied with Ctrl+C and will not be printed. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "CarSum" wrote in message ... I have a order spreadsheet that I enter amounts ordered into on different lines. When I print out the order all the line print out unless I delete the ones that are blank. I was wondering if there was a way to just print out the rows that have something ordered written in them?? I need heading to print out as well that happen to be inbetween the ordered items. Confused yet I am. "Earl Kiosterud" wrote: Carol, I don't have a very clear idea of what's going on on this sheet, but I wonder if an Autofilter might let you hide the rows that are empty before you print. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "CarSum" wrote in message ... I have a master order sheet. I enter orders on this master daily. Not the same items are ordered every day. I just want to print out the rows that have items ordered on them without having to delete the blank rows?? Thanks in advance Carol |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing Alternate Rows | Excel Discussion (Misc queries) | |||
printing worksheet with hidden rows | Excel Worksheet Functions | |||
Hide Empty Rows When Printing | Excel Worksheet Functions | |||
printing only selected rows in a sheet | Excel Discussion (Misc queries) | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) |