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.

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.