Specify That the Current Worksheet Will Print on Legal Size Paper Excel 2013

Here you can choose the number of copies you want to print. 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. You can make additional changes to your Excel document by selecting the Page Setup tab, and then clicking the Page Setup dialog box launcher in the lower-right corner of the Page Setup group on the ribbon. From there, you can format the settings of your Excel spreadsheet, whether it`s one or multiple pages. This includes things like the orientation of the printed data, the number of printed pages to adapt the data to, or the scaling of the printed 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. 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. Most users typically print on standard letter-size paper (8.5″ x 11″), but Excel can print on many other paper sizes. Monochrome laser printers are a good choice for homes or businesses with many printing needs. Discover a good one here.

The Zoom button on the right zooms in and out in the preview window. On the left, the margins are displayed in the preview window. Sign up for a free trial of Amazon Prime to see if two-day free shipping and video streaming will benefit you. 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. Here`s an overview of how your spreadsheets will look when printed. You can then click the File tab in the upper-left corner of the window, and then click the Print button in the left column. You should see that the page size is set to A4.

In the Scaling section, you have two options for adjusting the scale of the spreadsheet for printing: Are you still having trouble printing your spreadsheets after choosing the correct paper size? Our printing guide has some suggestions on Excel settings and features that can reduce much of the frustration of printing in this app. 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. If you print multiple copies, you can choose whether to sort them or not. If some of your content is truncated by the printer, you can use scaling to automatically adjust your workbook to the page. 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? Watch the video below to learn more about layout and printing. 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. Our guide continues below with additional information on switching to legal paper in Excel, including images of these steps.

In our example, we print the Top 40 records on the central spreadsheet. There is also a More Paper Sizes option that you can click to make further changes to your printer`s paper size settings in Excel. You can select the desired paper size if your printer supports this setting. Step 4: From the list of paper sizes, go ahead and click on the Legal option. If you don`t see the paper size you want, select Other Paper Sizes. This guide shows you how to adjust page size in Excel. We assume you have a spreadsheet that you need to print on A4 paper and you have A4 paper in your printer. If not, you must change the page size to match the type of paper you want to print on. For example, if you`re in the United States and you`re printing a spreadsheet that was sent to you by someone in another country, the file might be A4 by default. If your printer only has stationery, you may get an error if you don`t switch to the correct page size. 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. Some printers still try to print to your printer`s paper size, even if it doesn`t match the paper size set by the Excel application.

Sometimes it will be fine, but you might also end up with a sheet printed on the side or clogged paper in the printer. 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. There are several different paper sizes you can use to print a spreadsheet. The selected paper size may depend on the size of the printed sheet, but there may also be geographic preferences that go into this selection. 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. 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.

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.