C
ClearInsight News

How do I insert a footer in Excel 2013?

Author

Olivia Carter

Published Feb 24, 2026

How do I insert a footer in Excel 2013?

On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text.

Subsequently, one may also ask, how do you add a header and footer in Excel 2013?

To insert headers and footers:

  1. Locate and select the Page Layout view command at the bottom of the Excel window.
  2. Select the header or footer you want to modify.
  3. The Header & Footer Tools tab will appear on the Ribbon.
  4. The footer will change to include page numbers automatically.

Furthermore, how do you insert a footer in Excel 2010? Adding a Standard Header or Footer in Excel 2010

  1. 1Click the Page Layout button on the View tab of the Ribbon.
  2. 2Position the mouse pointer over the Click to Add Header section at the top, or in the Click to Add Footer section at the bottom.
  3. 3Click to position the insertion point in either the left, center, or right section of the header or footer area.

Also know, how do I add a footer to page 1 in Excel?

Insert Page Numbers in Excel: Page Setup Dialogue Box

  1. Go to Page Layout tab –> Page Setup. Within the Page Setup Group, click on the dialogue launcher. This will open the Page Set dialogue box.
  2. In the Page Setup dialogue box, select the Header/Footer tab.
  3. In the Footer drop-down, select Page 1 of ? option.
  4. Click OK.

How do I close header and footer in Excel 2013?

Select the worksheets from which you want to remove a header or footer. Open the Page Setup dialog box (Page Layout tab > Page Setup group > Dialog Box Launcher). In the Page Setup dialog box, click the drop-down arrow to open the list of preset headers or footers, and select (none). Click OK to close the dialog box.

Add a built-in header or footer in Page Layout view
  1. Click the worksheet where you want to add or change a built-in header or footer.
  2. On the Insert tab, in the Text group, click Header & Footer.
  3. Click the left, center, or right header or the footer text box at the top or the bottom of the worksheet page.

How do I view the header in Excel 2013?

Click the worksheet where you want to choose header and footer options. On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. Click the left, center, or right header or footer text box at the top or the bottom of the worksheet page.

How do you insert page numbers in Excel 2013?

Step 1: Open your spreadsheet in Excel 2013. Step 2: Click the Insert tab at the top of the window. Step 3: Click Header & Footer in the Text section of the navigational ribbon at the top of the window. Step 4: Click inside the section of the header or footer where you want to display your page number.
If you want to add a header or footer to all sheets, select every sheet by right-clicking one of the sheet tabs at the bottom of the Excel screen and clicking "Select All Sheets" in the pop-up menu. It's fairly common to put an Excel header on all pages of all worksheets in your document.
To add a header and/or footer in your worksheet, follow next steps:
  1. On the Insert tab, in the Text group, click Header & Footer:
  2. Click the left, center, or right header or footer text box at the top or at the bottom of the worksheet page.
Remove headers or footers
  1. On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view.
  2. Click the left, center, or right header or the footer text box at the top or the bottom of the worksheet page.
  3. Press Delete or Backspace.

How do I create an existing header row in Excel?

Go to the "Insert" tab on the Excel toolbar, and then click the “Header & Footer” button in the Text group to start the process of adding a header. Excel changes the document view to a Page Layout view. Click on the top of your document where it says “Click to Add Header,” and then type the header for your document.
To insert headers and footers:
  1. Locate and select the Page Layout view command at the bottom of the Excel window.
  2. Select the header or footer you want to modify.
  3. The Header & Footer Tools tab will appear on the Ribbon.
  4. The footer will change to include page numbers automatically.
On the Insert tab, in the Text group and click the Header & Footer button. On the Design tab, click Go to Footer or scroll down to the footer boxes at the bottom of the page. Depending on the desired location, click the left, center, or right footer box, and type some text or insert the element you want.
Put cell value in header or footer of a worksheet with VBA code
  1. Active your worksheet which you want to insert herder or footer with a cell value, then hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
  2. Click Insert > Module, and paste the following code in the Module Window.

How do you insert a footnote in Excel?

Click the "Home" tab. Click the small "Down Arrow" in the bottom right corner of the Font section of the ribbon. Click on the "Superscript" box to insert a check mark, then click “OK.” The footnote takes on the traditional, small and slightly higher appearance compared to normal text.

How do I use AutoFill in Excel?

How to Use AutoFill in Microsoft Excel
  1. Begin a new spreadsheet. Add initial data that is needed.
  2. Select the cell that you wish to AutoFill. Move the cursor to the bottom right corner of the cell. It will turn into a solid cross.
  3. Notice how Excel fills the series of months for you automatically. Drag the cursor across the cells to as many as you need.

How do I insert a header in Excel 365?

Select the worksheet you want to add a header or footer to. Click the Insert tab, and click Header & Footer. This displays the worksheet in Page Layout view. The Header & Footer Tools Design tab appears, and by default, the cursor is in the center section of the header.

How do I merge and center in Excel?

To do this, select the cells you want to merge. In the “Alignment” section of the “Home” tab, click the “Merge & Center” button. The cells are merged and the text is centered in the single resulting cell. If you don't want to merge the cells, you can still center text across them.

In which view headers and footers are visible?

Answer: Header and footer option are available under insert menu. Header and footers can be used to display information in the top and bottom margins of your document. They can include details like the author's name, page numbers, the date, and more.
To insert a header or footer:
  1. Select the Insert tab.
  2. Click either the Header or Footer command.
  3. From the drop-down menu, select Blank to insert a blank header or footer, or choose one of the built-in options.
  4. The Design tab will appear on the Ribbon, and the header or footer will appear in the document.
Remove headers or footers
  1. On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view.
  2. Click the left, center, or right header or the footer text box at the top or the bottom of the worksheet page.
  3. Press Delete or Backspace.
Open the target workbook; the one to which you want the headers and footers copied. Open the workbook that is the source of your header and footer, and make sure the desired worksheet is displayed. Choose Move or Copy Sheet from the Edit menu. Excel displays the Move or Copy dialog box.
Method C: Header & Footer in File Menu of Microsoft Excel 2010 if you have Classic Menu
  1. Click File drop down menu under Menus tab;
  2. Click the Page Setup item;
  3. Then you will get into the Page Setup dialog box;
  4. Select the Header/Footer tab at the top;
  5. Here you can easily set the Header & Footer at ease.
On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text.
Excel 2007 Just the Steps For Dummies
  1. Click the Page Layout button on the View tab of the Ribbon (or click the Page Layout View button on the Status bar).
  2. Position the mouse pointer over the Click to Add Header section at the top or the Click to Add Footer section at the bottom.

How do I get Excel to go back to normal?

Right-click anywhere in on the screen while in Full Screen view and select "Close Full Screen." This will exit the mode and return you to the previously used mode. Alternatively, press "Esc" on your keyboard. Click the top "View" tab and click "Normal" from the Workbook Views group to return to Normal view.

How do I create a header in Excel 2010?

To create a custom header or footer in Excel 2010, follow these steps:
  1. Click the Page Layout button on the View tab of the Ribbon (or click the Page Layout View button on the Status bar).
  2. Position the mouse pointer over the Click to Add Header section at the top or the Click to Add Footer section at the bottom.

Continue Reading

Where can I watch King Kong vs Godzilla?

How do you know if an Aquarius man is playing you?

How many signatures do you need for a petition to pass?

How do I insert a footer in Excel 2013?