Great article, Thanks! Skip to main content. Search form Search. Scale your spreadsheet to fit on one page when printing from Excel. Scaling your spreadsheet when printing You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. If you're using Excel Click the Page Layout tab.
Set the Scale to Fit options for Width and Height to the values you want. Print your spreadsheet. If you're using Excel and earlier for PC, or Excel for Mac or Open Page Layout In Excel , click the Page Layout tab, then click the small arrow in the bottom right corner of the Page Setup group this also works for Excel as an alternative to the instructions above In earlier versions of Excel, and for Excel and for Mac, click File , then Page Setup.
Enter the number of pages wide and tall you want your spreadsheet to be when printed. For example, you may choose to set your spreadsheet to be 1 page wide and 2 pages tall when printed.
Scaling an Excel spreadsheet to a specific number of pages Suppose you want your Excel spreadsheet to print out one page wide , but you don't mind how many pages tall the print out is. Set the Scale to Fit option for Width to be 1 page. Set the Scale to Fit option for Height to be Automatic.
Open Page Setup. Click the Page tab. Click the Fit To option. Enter 1 for the number of pages wide. Delete the value for the number of pages tall and leave it blank. Want to learn more? Try these lessons: Scale your Excel spreadsheet to fit your screen. Print an Excel spreadsheet with page numbers. Print an Excel spreadsheet with header rows at the top of every page. Select cells quickly and easily in Excel using the keyboard instead of the mouse.
Freeze or lock rows and columns in an Excel worksheet. Our Comment Policy. Comments on this lesson I am quite a savvy Excel user Hi Otto Sounds like it's working as designed, except Excel is getting confused about what you want to print and including cells that you don't want to include in the printout. There are a couple of possibilities that might be causing you to have problems: You have manual page breaks in your spreadsheet.
This will cause the technique outlined here to fail. You have cells outside the range you want to print that contain data. These are included when Excel determines the range of cells that should be printed, causing your spreadsheet to appear very small. Sometimes cells look empty but aren't so they are included when printing your spreadsheet. This can happen when you've entered data into a cell and then deleted it later.
If you had formatted the cell and then only deleted the values in the cell, then Excel can be confused and think that the cell is still part of the range it should print. Regards David. Notify me when new comments are posted. All comments. Replies to my comment. Related files optional. You can share the file you are working on by uploading it here. Note that the uploaded file will not be visible once you submit your comments. See screenshot:. In the Insert Watermark dialog, you can specify insert picture watermark from a folder or text watermark with formatting you need.
Click Ok or Apply , the watermark has been inserted in the current sheet. Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account.
A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.
If you are satisfied with the solution s provided, please mark your thread as Solved. Change to Solved Click Save. Labels, at the same time Page Break blue lines are also important to me. Help in the matter. Do not post a question in the thread of another member -- start your own thread. If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants.
0コメント