[vicsireland] Re: Excel Query - fitting a spreadsheet onto one page
- From: "Cearbhall O Meadhra" <cearbhall.omeadhra@xxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Wed, 14 May 2008 15:58:47 +0100
Dear Ulla,
Here is the instruction from excel help:
Microsoft Office Online: Help and How-to: Print a worksheet to fit a paper
width or a number of pages
Print a worksheet to fit a paper width or a number of pages
Show All Show All
list of 4 items
1. Click the worksheet.
2. On the File menu, click Page Setup, and then click the Page tab.
3. Under Scaling, click Fit to.
4. Do one of the following:
Hide Print a worksheet to fit a paper width
In the first box beside Fit to, enter 1 (for 1 page wide). In the second box
beside Fit to, delete the value so that the number of pages tall is
unspecified.
Show Print a worksheet on a specified number of pages
list end
Notes
list of 3 items
. Microsoft Excel ignores manual page breaks when you use the Fit to option.
. When you change the values for Fit to, Excel shrinks the printed image or
expands it up to 100 percent, as necessary. To see the how much the image
will
be adjusted for your new values, click OK, and then click Page Setup on the
File menu. The Adjust to box on the Page tab shows the percentage that the
printed size will be adjusted.
. Printed data does not exceed the specified number of pages. Excel does not
enlarge the data to fill the pages.
list end
All the best,
Cearbhall
"Good design enables - Bad design disables"
Tel: 01-2864623 Mob: 087 9922227 Em: cearbhall.omeadhra@xxxxxxxxxx
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Ulla Quayle
Sent: 14 May 2008 15:34
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Excel Query - fitting a spreadsheet onto one page
Hi Everyone
I am currently working on a spreadsheet on Excel. It has 11 columns.
When I tried to print it it came out over two pages. I did go into the page
layout and change it to landscape.
Apparently there is a way to fit the spreadsheet onto one page but when I
asked a colleague to show me how to do this she only knew how to do it by
using the mouse and dragging the blue line which appears to the end of the
columns. She clicked on something at the bottom of the right of the screen
which I am not able to see. The dialogue that came up was called page break
preview.
Would anyone have any idea how to make a spreadsheet fit onto one page using
keystrokes? I am using Excel 2007.
Any help would be much appreciated.
Ulla
Ulla Quayle
Training & Development Division
Mental Health Commission
Coimisiun Meabhair-Shlainte
St Martin's House
Waterloo Road
Dublin 4
Direct Dial - (01) 636 2415
Main Office - (01) 636 2400
Fax - (01) 636 2440
E-Mail - ulla.quayle@xxxxxxxxx
Web - www.mhcirl.ie
Other related posts: