By default, Excel uses the letter or A4 format, which may not be ideal for the type of information you want to print. You can adjust some of the other printing and layout options from this position, 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 easier to determine specific data on additional pages of a printed document. Print settings are often an afterthought when working with data in Excel, but it can quickly become a headache when you print your spreadsheet and find that nothing is going right. You may not have lines between cells, data may be truncated and redirected to its own page, and you may even use the wrong paper size. 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. Note that individual printers may require additional modifications to print on legal-sized paper. This can often mean using the manual feeder option on the printer 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, you will need to consult your printer model documentation for information on how to print on a paper size other than a letter. With the steps above, you can specify that the current spreadsheet is printed on legal-sized paper, but what if you want to specify that the current spreadsheet is printed on legal-sized paper? 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. We`ve written about ways to customize print settings in Excel 2010 so that all your columns are printed on a single sheet, which may be the best solution if your spreadsheet is too large 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. Fortunately, Excel offers many tools for changing the print settings of your document, and one of the settings you can choose is the size of the paper you are going to use. Fortunately, you can use a simple trick that allows you to apply the same change to all worksheets in a workbook.
Right-click one of the worksheet tabs at the bottom of the window, and then select Select All Sheets. You can then click the Size button on the Page Setup tab and select the legal paper size. Now all your worksheets are printed on legal paper. 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. Our guide continues below with additional information on switching to legal paper in Excel, including images of these steps. Monochrome laser printers are a good choice for homes or businesses with high printing requirements. Discover a good one here. The steps in this article were performed in Microsoft Excel for Office 365, but also work in most other versions of Excel.
Note that in some earlier versions of Excel, the tab at the top of the window displays Page Setup, not Page Setup. Sign up for a free trial of Amazon Prime to see if the two-day free shipping and video streaming is something you`ll benefit. 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 to the left. 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. You can also change the page orientation. To do this, click the Orientation button and select the Portrait or Landscape option. 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.