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

microsoft-excel-courses - printing

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Printing

microsoft-excel-courses - Printing

ResolvedVersion Standard

Joanne has attended:
Excel Intermediate course

Printing

How do I get all the pages and columns to print on one page?

RE: Printing

Hi Joanne,

Thanks for your question.

In order to fit your content all on one page, you need:
1) FILE menu > PAGE SETUP > PAGE tab
2) Under SCALING: select Fit to (1) page wide by (1) page tall
3) press OK

If the worksheet is big, you may adjust the number of pages it will spread on.
For multiple landscape setting, amend no. of pages WIDE;
for multiple portrait setting, amend no. of pages TALL.

Hope this helps.

Katie

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

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