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

print areas

ResolvedVersion 2007

Yan has attended:
Excel Intermediate course

Print areas

Do you need to clear print area before you set print area?
are does setting a print area effectively clear any previous?

RE: Print areas

Hi Yan,

Thank you for your question.

When you creating a print area you can use Ctrl + Click to select multiple areas.

If you have a print area set and you create a new print area using another set of cells, the old print area is ignored and reset.

I hope this answers your question.

Regards

Simon

Mon 19 Mar 2012: Automatically marked as resolved.

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

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.09 secs.