Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
print all sheets in one print job so I can staple them
I know how to select all sheets to print them all at once, but my printer
adds a cover sheet to each Excel Worksheet. I need to staple all of the worksheets together as one document. Anyone know how? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
print all sheets in one print job so I can staple them
Have a look around in your Printer Properties or Options.
You may be able to disable the "cover sheet" printing. Gord Dibben MS Excel MVP On Fri, 31 Jul 2009 14:38:02 -0700, denman wrote: I know how to select all sheets to print them all at once, but my printer adds a cover sheet to each Excel Worksheet. I need to staple all of the worksheets together as one document. Anyone know how? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
print all sheets in one print job so I can staple them
I know how to select all sheets to print them all at once, but my
printer adds a cover sheet to each Excel Worksheet. I need to staple all of the worksheets together as one document. Anyone know how? In case you haven't found a useful approach yet, here’s one way -- admittedly not elegant. Print the first sheet to the "Microsoft Office Document Image Writer." This opens a "Microsoft Office Document Imaging" window for the sheet. Do the same for several sheets, and there’ll be several windows: one per sheet. You can use Window Arrange all to see all the windows at once on the screen. Next, combine the sheets into a single file. To do this, notice that each of the "Imaging" windows has a left pane with thumbnails of the page(s). Using right-click, "Copy" one or more thumbnails from the left pane of one window and “Paste” it into the left pane of another. Repeating this several times, the entire print job can be merged into a single window. Finally, print from that window. If you do this sort of thing a lot, you might want to look into third-party software like http://fineprint.com/products/fineprint/index.html It can (among many other features) combine several print jobs into one, with fewer steps than using Image Writer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print 100 Sheets | Excel Worksheet Functions | |||
How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
Print Sheets in PDF | Excel Discussion (Misc queries) | |||
Print 3 sheets on the same page | Excel Discussion (Misc queries) | |||
i made one spreadsheet but when i try to print two sheets print, | Excel Discussion (Misc queries) |