98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Printing
Printing
Resolved · Low Priority · Version 2003
Marthie has attended:
Excel Intermediate course
Excel Advanced course
Printing
How do I copy the same print settings to several tabs in the same worksheet?
RE: Printing
Hi Marthie, thank you for your post, in answer to your question, this operation cannot be accomplished by using the File>Print Area command, what you need to do is to group your worsheets, select the area you wish to print and then go to File>Print, in the Print dialog box, choose the option Selection and then click Preview, you will see that each sheet is shown on a separate page and the selected area only is displayed. You can now return to the Print dialog box and print as necessary, I hope that has helped, best regards Pete.
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. |
Excel tip:Printing spreadsheets without opening them firstHere's a fast way of printing a spreadsheet from Windows Explorer/My Computer. |