Right-click on a sheet tab, and then click Select All Sheets from the shortcut menu. For documents that use facing pages, the document margins are Top, Bottom, Inside, and Outside. bottom, bmargin These two parameters set the distance from the bottom edge of the document to its baseline. top, tmargin These two parameters determine the height of the top margin. right, rmargin, outer These three parameters change the length of the right margin. In the Document Margins section, click the arrows or enter values in the fields next to Top, Bottom, Left, and Right. These three parameters change the length of the left margin.
Then hold down Ctrl while you click the tabs of the other sheets that you want to select. in the toolbar, then click the Document tab at the top of the sidebar. To select two or more non-adjacent sheetsĬlick the tab for the first sheet. Then hold down Shift and click the tab for the last sheet that you want to select. If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.Ĭlick the tab for the first sheet.
Select the worksheet or worksheets that you want to print.Ĭlick the tab for the sheet that you want to print.
Top and bottom page margins can be used for things such as headers, footers, and page numbers.įollow the steps below to set page margins: Page margins are the blank spaces between your data and the edges of the printed page. To better align an Excel worksheet on a printed page, you can change margins, specify custom margins, or center the worksheet-either horizontally or vertically on the page. Excel for the web Tip: Although Excel for the web doesn't support setting page margins, it does offer some Page Setup options on the Page Layout tab.