Forum home » Delegate support and help forum » Microsoft Excel Training and help » Printing
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Printing
Resolved · Low Priority · Version 2003
Reply Thu 16 Apr 2009, 11:48Delegate Tessa said...
Tessa has attended:
Excel Intermediate course
Excel Advanced course
Printing
Is it possible to set a workbook up to automatically print selected worksheets, or do you have to print them one by one?
For upcoming training course dates see: Pricing & availability
RE: Printing
Hi Tessa
If you want to print out a selection of worksheets in a workbook you do the following:
1. Holding down the Control (Ctrl) button click the worksheets to be printed
2. Select the File menu and click Print
3. On the Print dialog box in the Print what section ensure that Active Sheet(s) is selected.
This will print all the selected sheets.
If you want to automate this action so that you print the same sheets every time you want then you should record the above steps in a macro. To do this:
1. Select Tools menu then click Macro
2. Click Record New Macro
3. Give the macro a relevant name like
Wed 22 Apr 2009: Automatically marked as resolved.
|