Dear Ulla, I am glad you got it sorted. I agree that it does look as though you have found the same function that I described from Excel 2003. Has the Help function changed? If not, you might try the F1 key and enter the key words "page layout" and see what is on offer. I find the Excel help to be very good indeed. 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: 15 May 2008 09:51 To: vicsireland@xxxxxxxxxxxxx Subject: [vicsireland] Re: Excel Query - fitting a spreadsheet onto one page 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