Change the worksheet margins in Microsoft Excel 2013 to include more data on a printed page or to better align the spreadsheet on the page. The default top and bottom margins are one inch; the default left and right margins are one quarter of an inch. You can set different margins for each spreadsheet in the workbook or change the margins of several sheets at once. If you make the margins too narrow, the printer may cut off some of the content. Note that these custom margins are not applied to new workbooks.
Change the Page Margins
Select the sheet you want to edit. To select several adjacent sheets, select the first sheet, hold "Shift" and click the last sheet. Select several nonadjacent sheets by holding "Ctrl" and clicking each sheet. To select all sheets in the workbook, right-click one of them and click "Select All Sheets."
Select the "Page Layout" tab and then click "Margins" in the Page Setup group. Select one of the predefined margin sizes -- Normal, Wide or Narrow -- or click "Custom Margins" to use custom margins. Change the "Top," "Right," "Bottom" and "Left" margin sizes. To change the size of the header or footer, change the "Header" or "Footer" values. Check the "Horizontally" box to center the sheet horizontally on the page, or the "Vertically" box to center the sheet vertically. Click the "Print Preview" button to preview the document or the "Print" button to print the sheet.
How to Manually Change the Margins in Excel 2010
In Microsoft Excel 2010 the margins are not as clear as they are in other applications such as Microsoft Word. This is...
How to Calculate Gross Profit Margin Using Excel
Gross profit margin measures the amount of revenue a company has after the cost of goods sold is taken into account. If...
Unable to Adjust Margin in Excel
Unable to Adjust Margin in Excel. ... Worksheet Horizontally & Vertically in Excel 2003; How to Move Page Margins in Excel; ......
How to Change Print Settings for a Whole Workbook
Go to the "Margins" section and change the left, right, top and bottom margins. 10. Select the "Sheet" tab in the dialog...