microsoft-excel-courses - printing
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

microsoft-excel-courses - Printing

resolvedResolved · Low Priority · Version Standard

replyReply Wed 5 Dec 2007, 17:05Delegate Joanne said...

Joanne has attended:
Excel Intermediate course

Printing

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

For upcoming training course dates see: Pricing & availability

replyReply Thu 6 Dec 2007, 14:28Trainer Katie said...

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:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard