microsoft-excel-courses - printing

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

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

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:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


View all Excel hints and tips


Server loaded in 0.1 secs.