excel microsoft training - 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 » excel microsoft training - Printing

excel microsoft training - Printing

resolvedResolved · Low Priority · Version Standard

replyReply Wed 12 Dec 2007, 15:38Delegate Nour said...

Nour has attended:
Excel Introduction course

Printing

What is the best way to fit a speardsheet on one page while printing without breaking it up.

For upcoming training course dates see: Pricing & availability

replyReply Fri 14 Dec 2007, 16:45Trainer Andrew said...

RE: Printing

Hi Nour

you can try this to see if it produces the results you are looking for. From the file menu, choose page setup, and on the page tab choose Fit to 1 page tall by 1 page wide. Excel will fit the contents to the page for you.

Do let us know if you have any further questions.

Kind regards,

Andrew

 

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

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