excel consultants - PAGESETUP

The UK's most regular instructor-led training courses.
Training information: excel consultants · Advanced.excel · VBA courses London UK

Resolved · Low Priority · Version Standard

PAGESETUP

Sheila has attended:
Excel Intermediate course

by - delegate Sheila [1 post] (2007 Oct 4 Thu, 15:57) Reply

How do I fit to worksheets on to 1 page

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: PAGESETUP

by - trainer Amanda platinum contributer [968 posts] (2007 Oct 5 Fri, 11:18) Reply

Hi Sheila

Thank you for your question.

You can do this by going to File - Page Setup - Page and selecting the Fit to: option. Bear in mind that this does change the Scaling automatically for you and sometimes the text will get scaled so much that it will be difficult to read when the spreadsheet is printed.

Amanda

· Crazy Things People Have Done With Excel
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Identifying Suitable Candidates For VBA For Excel Training
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Fun Things I've Done With Excel

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips