[vicsireland] Re: Excel Query - fitting a spreadsheet onto one page
- From: "Ulla Quayle" <Ulla.Quayle@xxxxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Thu, 15 May 2008 09:51:19 +0100
Hi Cearbhall
Thanks for your response to my query yesterday.
As I said in my original Email, I am using Excel 2007. It looks like
the piece you copied and pasted from the help file in to your message is
from an older version, as I am unable to find some of the items
described. The file menu no longer exists. Some of the file menu
functions are under the office button but only a few. A lot of the old
functions have to be looked for in different places now. It is all
there but sometimes it is just a matter of looking around until they can
be found. Office 2007 seems to operate with ribbons now rather than
menus.
Now I have had time to look at the problem I think I may have found the
solution. There is a ribbon on the top entitled page layout and alt p
will take me there. In that there is a width tab which can be reached
by pressing w once I am in the page layout ribbon. The default there is
automatic but if I scroll down with the arrow keys I can choose a one
page option. Height is the next tab in that ribbon and again I can use
the arrow keys to scroll down to 1 page.
All a little different from the old system unfortunately.
Once again many thanks.
Regards.
Ulla
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Cearbhall O
Meadhra
Sent: 14 May 2008 15:59
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: Excel Query - fitting a spreadsheet onto one
page
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:
