From this position, you can customize some of the other printing and layout options, including margin size and sheet orientation. Another useful customization when printing Excel spreadsheets is to print the top row of each page. This customization can make it much easier to determine what particular data exists on additional pages of a printed document. There may be times when you want to print a workbook to view and share your data offline. After choosing your layout settings, you can easily preview and print a workbook in the print area of Excel. The steps in this article assume that your spreadsheet is currently configured to print to a different page size than the legal page. If you manually inserted page breaks or manually configured the sheet to print differently than what is applied to the default sheet, you may need to go back and adjust these settings to reflect the change in paper size. If you don`t see the paper size you want, select Other Paper Sizes. If you want, you can also set the print area in advance so that you can see which cells will be printed when you work in Excel. Simply select the cells you want to print, click the Page Setup tab, select the Print Area command, and then select Set Print Area. Keep in mind that if you need to print the entire workbook, you will need to clear the print area. Bob has a workbook with about fifteen spreadsheets, and he has to change the page size for the entire spreadsheet from the letter to A4. There is a quick way to make the change by doing the following: Printing in Excel has always been a bit tricky because there are many factors that affect how your spreadsheet looks when it`s sent to a printer.
Monochrome laser printers are a good choice for homes or businesses with many printing needs. Discover a good one here. If you have a data range that is too wide or too large for a page, scale it to make sure it fits properly. Here you can choose the number of copies you want to print. One of the things you may want to do is learn how to print on legal paper in Excel 2010. This can be useful by allowing you to print more rows on a portrait sheet or by inserting more columns in a landscape orientation. Luckily, switching from a letter to a legal paper in Excel 2010 is a setting you can change in a few steps, so skip below to see how. We`ve written about ways to adjust print settings in Excel 2010 to print all your columns on a single sheet, which may be the best solution if your spreadsheet is barely too big to fit on a letter-sized sheet of paper.
However, if you have a lot of columns or a lot of data, it can result in small, hard-to-read text. Note that spreadsheets are harder to read when they shrink, so you may not want to use this option if you`re printing a spreadsheet with a lot of information. In our example, we change the scaling setting to No scaling. You can also select the More Paper Sizes option at the bottom of the drop-down menu if you want to enter your own custom paper size for your Excel spreadsheet. From the Page Setup > Page Setup->Try clearing the print area, our guide below will show you how to print on legal paper in Excel if you need to use it instead of the current selection. Most users typically print on standard letter-size paper (8.5″ x 11″), but Excel can print on many other paper sizes. Here you can choose to print the active worksheets, the entire workbook, or a selection. If you find that you make changes to your Excel files when you open them, consider changing some of the default settings.
You can find them by going to File > Options and clicking on the different tabs in the Excel Options menu. For example, you can change the default file type, change the default font, and use a different default view. Learn how to center horizontally when printing in Excel when you want your data to appear in the middle of the page instead of aligning it to the left. If some of your content is truncated by the printer, you can use scaling to automatically adjust your workbook to the page. However, if you need to keep all these columns on one page, it may be better to simply use larger paper, such as legal paper. Fortunately, this is a setting that you can adjust quite easily in Excel. So, read below to learn how to change the paper size for a worksheet in Excel 2010. If only for a particular sheet, it is difficult to say something concrete without having seen the sheet.
Note that individual printers may require additional modifications to print on legal-sized paper. This can often mean using the printer`s manual feeder option or a different paper tray on larger printers. If you follow these steps, the paper size setting in Excel will be changed, but the paper size setting of your printer cannot be changed. If your printer does not print on legal paper, refer to your printer model documentation for instructions on how to print on a paper size other than the letter. With the steps above, you can specify that the current spreadsheet will be printed on paper in legal format, but what if you want to indicate that the current workbook will be printed on paper in legal format? There you go; The paper size is now set for all worksheets. However, this approach has a drawback: if individual worksheets have different layout settings (orientations, margins, headers, footers, etc.), following these steps sets them all the same. If you only want to change the paper size and no other settings, you can only use one macro to make the change. You can select the desired paper size if your printer supports this setting. Fortunately, Excel offers many tools to change the print settings of your document, and one of the settings you can choose is the paper size you are going to use. Watch the video below to learn more about layout and printing. If you want to print a worksheet on non-Letter size paper, you must select a different paper size in Excel.
You can adjust the scale of the printed worksheet to stretch or shrink the printed data based on the specified number of pages. The Scaling section has two options from which you can choose to adjust the scale of the worksheet for printing: Before you print an Excel workbook, you need to decide exactly what information you want to print. For example, if your workbook contains multiple worksheets, you must decide whether you want to print the entire workbook or only the active worksheets. There may also be times when you only want to print a selection of content from your workbook. Sometimes you may need to make small adjustments in the print area to perfectly fit the contents of your workbook to a printed page. The Print pane contains several tools for customizing and scaling your content, such as scaling and margins. Here`s an overview of how your spreadsheets will look when printed. You can also change the page orientation.
To do this, click the Orientation button and select the Portrait or Landscape option. Our guide continues below with additional information on switching to legal paper in Excel, including images of these steps. Excel spreadsheets are notoriously difficult to print. The default print settings do not include gridlines, do not repeat titles or headers on each page, and are not at all optimized to accommodate your data to the limitations of your paper size.