Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel printing
Our payroll is setup with 50 dept's spread over 75 pages. Each page is
formatted for 10 employees with a page break after every 10. If pages are blank we simply hide them to get them out of the way. Is there a way to print only the visible pages. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel printing
Maybe...
If your pagebreaks are not manually inserted (insert|page break), then hiding the unused rows should be sufficient. If your pagebreaks are inserted manually, then maybe... you can hide the rows. select the range to print edit|goto|special|visible cells edit|Copy select a new worksheet select A1 edit|paste and reinsert the page breaks. Then print that helper page. You could even record a macro that did this when one time, then tweak the macro and run that when you need to. PaulM wrote: Our payroll is setup with 50 dept's spread over 75 pages. Each page is formatted for 10 employees with a page break after every 10. If pages are blank we simply hide them to get them out of the way. Is there a way to print only the visible pages. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Contact List in Excel - Printing Labels in Word | Excel Discussion (Misc queries) | |||
How do I 2 worksheet duplex printing with MS Excel 2003? | Excel Discussion (Misc queries) | |||
Problems printing templates in Excel XP | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |