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

formatting worksheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting worksheets

Formatting worksheets

ResolvedVersion 2007

Justine has attended:
Excel Introduction course

Formatting worksheets

Is it possible to print to worksheets on 1 page?

RE: Formatting worksheets

Hi Justine

Thank you for your question, and welcome to the forum.
I hope you enjoyed yesterday's training.

There are a few things you can try to get a single worksheet printing on one page:

- Try adjusting scaling (go to the Office button, Print, Print Preview then click the Page Setup button and change scaling on the Page tab)
- Try adjusting margins (go into Print Preview, then tick Show Margins to adjust margins manually; or click Page Setup and go to Margin tab to adjust using dialogue box).
- If your spreadsheet is spread across more columns than rows, changing page orientation to Landscape helps as well (go to Page Layout - Orientation).

I hope this helps.
Amanda

Tue 2 Dec 2008: Automatically marked as resolved.

Excel tip:

Apply Autosum with keyboard shortcut

If you press Alt and = at the same time, it applies autosum.

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