This determines the order in which the worksheets are printed. 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. From the Page Setup group –> Page Layout — >Try clearing the print area. On the Page tab of the Page Setup dialog box, you can collapse the worksheet data to a specified number of pages when printing. Click the Fit To radio button, and then type the page width and height that you want. 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.
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. 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. Use the Page tab of the Page Setup dialog box to set the resolution of the print job. Print quality is measured in dpi or dots per inch. A higher dpi ensures better print quality. 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`ve used color in your spreadsheet but don`t want to waste ink on your color printer, use black and white. 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 Layout tab and select 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. Most users typically print on standard letter-size paper (8.5″ x 11″), but Excel can print on many other paper sizes. This determines whether the gridlines are printed. However, disabling gridlines does not affect their appearance in Normal mode. 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. Margins define the location of the worksheet on the Excel page on which Excel prints. By default, Excel XP sets the top and bottom margins to 1 inch, while the left and right margins are set to 0.75 inches.
Border settings can be changed arbitrarily. Different margins can be set for each worksheet in the workbook. You can insert placeholder buttons in the header and footer to format text and insert page numbers, dates, times, file names, and tab names. Excel replaces these placeholders with the information that each represents when you print the worksheet. Follow the instructions in the header and footer dialog boxes. Is your spreadsheet aligned with the left side of the paper to make it look a little strange? Learn how to center your printed spreadsheet to improve it. 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. 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. 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? If you don`t see the paper size you want, select Other Paper Sizes. But sometimes you create a fairly large table and you can insert more rows or columns on the page. This might make you want to use a different and larger type of paper, such as legal. Our tutorial below will show you how to switch to legal page size in Excel. On the Page tab of the Page Setup dialog box, you can change the page orientation (portrait or landscape) and paper size (for example, letter size or legal size). The default paper size in Excel XP is 8.5 x 11 inches with portrait orientation, which is printed from top to bottom on the long side of the page. A landscape orientation, on the other hand, prints from top to bottom on the short side of the page. Select Design Quality to print the worksheet without gridlines or charts.