Quick Access Toolbar (QAT) The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the. Before Excel 2007, you followed this rather convoluted process to create a setting equivalent to step 6 above. Environment Quick Access Toolbar Customizable toolbar for one-click shortcuts Tabs Backstage View Tools located outside the document viewing window. After the 1 is highlighted, press Delete to leave this entry completely blank. Using your mouse, highlight the 1 in the spin button for Tall. There are 4 sub-sections there namely: Page. a version later than Office 2010), Navigate to the Layout tab. Leave the first spin button at 1 Page(s) Wide. If you are using Microsoft Excel 2010+ (i.e. Choose the Page tab of the Page Setup dialog. Excel 2003 and earlier versions of Excel. If the margins are not displayed, click Show Margins in the Preview group. On the Page Layout tab of the ribbon, click the dialog launcher in the lower-right corner of the Page Setup group. Describes a problem that occurs when you put graphics in a header or a footer section in Excel. Results: The report will fit on one page wide and three pages tall.Īlternate Strategy: You can use the Page Layout dialog to indicate that the report should fit to one page wide by pages tall. (This is much easier than using the Page Setup dialog, as discussed in the following alternate strategy.) On the Page Layout tab, open the Width dropdown in the Scale to Fit group.
You can now drag the margins to a new location. Alternatively, use Print Preview and click the Show Margins icon in the lower right. Adjust the bottom to 0.5 inch and the footer margin to 0.25 inch. On the Margins tab of the Page Setup dialog, set the top, left, and right margins at 0.25 inch.
In the Copies box, enter the number of copies you want to get. This will get you to the Print Preview window. To select two or more non-adjacent sheetsĬlick the tab for the first sheet. In your worksheet, click File > Print or press Ctrl + P. 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.