Click the Page Layout tab on the Ribbon, then select the Margins command. Select the desired margin size from the drop-down menu. In our example, we’ll select Narrow to fit more of our content on the page. The margins will be changed to the selected size.

How do I enable the Options tab in Excel 2010?

Click the File tab jumping into backstage view; Then you will view the Options button at left bar. Click it into Excel Options window.

How do I make excel not show the margins?

Use the Page Layout tab: On the Page Layout tab, click Margins, and then select Custom Margins…. Use the arrows to increase or decrease the margin sizes, or enter the desired size in the appropriate box. When you’re done, click OK.

How do I see print margins?

Here’s how:

  1. Open a new Word document.
  2. Go to page setup:
  3. Set all margins to 0.
  4. Click OK.
  5. You’ll get a message saying the margins are outside the printable area (the message may vary slightly depending on which version of Word you’re using).
  6. Your printer’s margins will now populate the margin fields.

How do I show page numbers in Excel?

Add page numbers On the Insert tab, click Header & Footer. Excel automatically changes to Page Layout view. On Header & Footer tab, click either the Header or Footer, and then select the page number format you want. Header page numbers appear at the top of the printed page, and footer page numbers appear at the bottom.

How do I enable display options in Excel?

All of Microsoft Excel’s settings are accessible in the one dialog box, Excel Options. You can access this dialog box by clicking on the File tab and clicking on Options. The Excel Options dialog box provides a list of setting categories (down the left-hand side) that you can click on to access the related settings.

Where is display options in Excel?

Click the Ribbon Display Options icon on the top-right corner of your document. It is to the left of the Minimize icon. In the menu that opens, click Show Tabs and Commands to show the Ribbon with all tabs and full commands.

How do I change cell margins in Excel?

Follow these general steps:

  1. Select the cell you want to adjust.
  2. Display the Home tab of the ribbon.
  3. Click the small icon at the bottom-right of the Alignment group.
  4. Make sure the Alignment tab is displayed.
  5. Using the Horizontal drop-down list, choose Center.
  6. Using the Vertical drop-down list, choose Center.
  7. Click on OK.

How do I change the footer margins in Excel?

How to change height of header or footer to bigger or smaller in…

  1. Click View > Page Layout to entering Page Layout view.
  2. Then dragging the top margin up or down as you need to change the height of the header.
  3. If you want to change the height of footer, dragging bottom margin to resize.