how to have different margins on different pages

Right-click on a sheet tab, and then click Select All Sheets from the shortcut menu. Then hold down Ctrl while you click the tabs of the other sheets that you want to select. 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. The inside margins are the same width, and the outside margins are the same width. In this case, the margins of the left page are a mirror image of those of the right page. 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: Set margins for facing pages Use mirror margins to set up facing pages for double-sided documents, such as books or magazines. 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 To change a master page's or page's margins select the pages in the Pages panel before choosing Layout>Margins and Columns. Tip: Although Excel for the web doesn't support setting page margins, it does offer some Page Setup options on the Page Layout tab. When you initially setup a document the margins you set in the New Document dialog are applied to all of the pages and master pages.

How to have different margins on different pages