Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

printing

ResolvedVersion 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?

Edited on Thu 24 Apr 2008, 09:48

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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.