Note that you may need to change paper trays or make other printer-related adjustments after choosing to print on legal paper. All printers are different, so the specific steps for printing on legal paper vary depending on the printer model. If you don`t see the paper size you want, select Other Paper Sizes. Note: Before clicking Print, check the paper size setting in the printer properties and make sure that the printer actually has paper of that size. If the paper size setting is different from your printer`s paper size, Excel adjusts the print to match the printer`s paper size, and the printed worksheet may not match your print preview. However, if you need to keep all these columns on one side, it may be better to simply use larger paper. as legal documents. 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. 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. Printing in Excel has always been a bit difficult because there are many factors that affect how your spreadsheet looks when it`s sent to a printer. 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. Most users typically print on standard letter-size paper (8.5″ x 11″), but Excel can print on many other paper sizes. 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. 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. Use the Print Area command (Page Setup group) to exclude columns or rows that you do not need to print. For example, if you want to print columns A through F but not columns G through Z, specify that the print area contains only columns A through F.

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. 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 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. To print the worksheet, press CTRL+P to open the Print dialog box, and then click OK. Our guide continues below with additional information on switching to legal paper in Excel, including images of these steps. In the Scale Adjustment group, in the Width box, select 1 page, and then in the Height box, select Automatic. Columns now appear on one page, but rows can span multiple pages. 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. 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. Our Excel printing guide can show you how to solve many of these problems and help you create a printed spreadsheet that`s a little easier for your audience to read. Consider using a larger paper size to accommodate many columns. To change the default paper size, go to Page Setup > Layout Size > Format, and then select the size you want. Step 4: From the list of paper sizes, go ahead and click on the Legal option. If your worksheet contains many columns, you can use the Scale options to adjust to reduce the size of the worksheet to better fit the printed page. The Scale section contains two options from which you can choose to adjust the scale of the worksheet for printing: Note: If you want to shrink a spreadsheet to better fit printed pages, enter a percentage less than 100%. To enlarge a worksheet for printed pages, enter a percentage greater than 100%. You can shrink or enlarge a spreadsheet to make it easier to fit printed pages. To do this, click the window launcher button in Page Setup. Then click Scale > Fit To, and enter the percentage of the normal size you want to use.

Sign up for a free trial of Amazon Prime to see if two-day free shipping and video streaming will benefit you. 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. Click Page, and then in the Fit To box, select a percentage that the font size will increase or decrease. 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. If only for a particular sheet, it is difficult to say something concrete without having seen the sheet. From the Page Setup group –> Page Layout — >Try clearing the print area When you print an Excel spreadsheet, you may find that the font size does not meet your expectations. To print a worksheet to a specified number of pages, in Page Setup, click the Small Window Launcher button. Then, under Scaling, in both boxes, type adjust the number of pages (wide and high) on which you want to print the worksheet data. Follow these steps to scale the worksheet for printing by increasing or decreasing the font size. You can also change the page orientation.