Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automate printing different ranges on 1 worksheet at different tim
I have an expense worksheet that contains different weeks. I want to print
each week's expenses on a separate page without having to set up a new print range every time. This to allow the office person to print the new week's expenses for processing. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
automate printing different ranges on 1 worksheet at different tim
Set-up a view you want, (i.e. hide rows and columns, etc.), jncluding having the "print area" defined. Then go on the menu bar go select "VIEWS" - then - "CUSTOM VIEWS" and follow the directions. As far as I know you can set as many different custom views as you want (depending on the limits of your machine and memory). -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=496166 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
automate printing different ranges on 1 worksheet at different
OK, that worked. Thanks. Now the 2nd part: How do I create a button to
allow someone to print the given "view" without having to go to the views dropdown menu? "wjohnson" wrote: Set-up a view you want, (i.e. hide rows and columns, etc.), jncluding having the "print area" defined. Then go on the menu bar go select "VIEWS" - then - "CUSTOM VIEWS" and follow the directions. As far as I know you can set as many different custom views as you want (depending on the limits of your machine and memory). -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=496166 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing multiple copies of a worksheet | Excel Discussion (Misc queries) | |||
Automate worksheet copy | Excel Discussion (Misc queries) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |