Headers and footers in Excel: inserting, changing, deleting. How to remove headers and footers in Excel Insert a header and footers in Excel

Headers and footers are text placed in the top and bottom margins of an Excel sheet. Headers and footers can contain headings or technical information about the document.

This function is not used often, so many users do not know how to remove headers and footers in Excel. If you also encounter a similar problem, we suggest you read this article. The information will be relevant to users of all modern versions of Excel, including Excel 2007, 2010, 2013 and 2016.

When users ask how to remove headers and footers, they often mean not the headers themselves, but the display mode of the Excel document in which they are displayed. The fact is that if the “Page Layout” display mode is enabled in an Excel document, then instead of one solid sheet, the user will see a sheet divided into pages. In this case, at the top and bottom of each page, where there should be headers and footers, the following inscriptions will be displayed: “Header” and “Footer”.

If you have exactly this problem and want to remove the display of these labels, then you just need to change the page display mode to “Normal”. To do this, go to the “View” tab and click on the “Normal” button.

You can also switch to normal display mode using the small buttons in the lower right corner of the Excel window (next to the scale slider).

How to remove headers and footers

If you actually have headers and footers that appear at the top or bottom of the page when printed, and you want to remove them, then on the contrary, you need to enable the “Page Layout” mode. To do this, go to the “View” tab and change the page display mode from “Normal” to “Page Layout”.

After switching to the “Page Layout” mode, you need to double-click with the left mouse button on the footer.

As a result, the header and footer will be highlighted, and you can remove it from the page using the Delete button on your keyboard.

After this, the inscription “Header” will appear in place of the header and footer, which will not be displayed when printing. In order to continue working with the document, you can return to the normal display mode (Tab “View” - “Normal”).

Another way to remove headers and footers

In addition, there is another way by which you can remove headers and footers from the pages of an Excel document. In order to use this method, you need to go to the “Page Layout” tab and click on the “Page Options” button.

As a result, the Page Setup window will appear. Here you need to go to the “Header and Footers” tab.

On the “Header and Footer” tab, click on “Create Header” or “Create Footer” (depending on which header you want to remove).

Finally, you need to close the “Page Settings” window by clicking on the “OK” button.

This will save your header and footer changes.

In this article we will look at the question of how to create and remove headers and footers in Excel 2007.

There are two ways to insert a header and footer into an Excel 2007 document sheet.

Method 1– Page layout mode. Select the “Page Layout” tab in the ribbon and in the “Page Settings” group and click on the button in the lower right corner.

After this, the “Page Settings” window will open. Go to the “Header and Footer” tab and select one of the provided options by clicking on the arrow next to the Header and Footer fields.

If none of the presented options suits you, you can create your own header by clicking on the “Create header/footer” button. In this case, another “Header (or Footer)” window will open. Here you can create your own header text or select from the additional options provided (Insert date, Insert time, Insert file path, Insert sheet name, etc.). After everything is done, click OK. In the example below, we chose to insert a date in the header on the left, and a picture on the right.

Method 2– Inserting a header and footer through the “Insert” tab. Select the “Insert” tab in the ribbon and in the “Text” group click on the “Header and Footer” button.

After this, your Excel 2007 document will open in the “Working with Headers and Footers” - “Design” mode. In this window, in fact, you can do everything that was done in the first way.

Ready! Now, if you go to the Excel 2007 document preview, you will see the following

P. S. How to preview an Excel 2007 document?) Click the “Office” button in the upper left corner of the screen, and then “Print” - “Preview”.

In order to remove a header and footer in an Excel 2007 document, you need to go to the “Insert” tab in the ribbon and in the “Text” group click on the “Header and Footer” button. In the “Working with Headers and Footers” - “Design” mode, click on the “Header” button in the upper left corner of the screen and select “No” from the drop-down list. Do the same with the footer.

Excel sheets designed for printing often have elements at the top or bottom of the page. They contain company logos and details, the date and time the document was created, page numbers, etc. These elements are called headers and footers in Excel. Let's learn how to work with them.

Page layout

When working with a file, headers and footers can only be seen when the sheet is displayed in Page Layout mode. You can select this mode on the “View” tab in the “Book viewing modes” block.

You might be interested in:

Let's add text - the page title. For example, let's indicate the name of the travel company for the report table on hotel orders for the period. To do this, select the “Header and Footer” menu item in Excel in the list of “Text” commands on the “Insert” tab.

The sheet will immediately appear in layout mode, and we will see highlighted text fields at the top and bottom of the page. Here you can insert the necessary information. Both headers and footers are divided into three parts, each with a different text or object added to it. Thus, you can add, for example, a company logo on the top left, the name in the center, and details on the right. Likewise at the bottom of the page.

It should be noted that the ampersand (&) is a special character. Therefore, if the text you want to add contains this character, enter 2 characters in a row. That is, in the text “Horns & hooves” write “Horns && hooves”.

After completing entering and changing headers and footers in Excel, click in any cell to exit editing mode. If you do not want to save your changes, press the Esc key.

Page settings

From the "Page Layout" tab you can open the parameters window. To do this, click on the form open button in the lower right corner of any of the tab toolbars: “Page Options”, “Fit In” or “Sheet Options”. The window that opens contains 4 tabs, of which we are interested in “Header and Footers”.

This form allows you to customize the page headings and footers as much as possible, including or excluding them. To get started, click the “Create Footer (or Header)” button. Here you can not only enter the necessary text, but also format it.

The same window allows you to make settings: set special headers for even and odd, first and subsequent pages, scaling and alignment of fields, and also remove headers and footers in Excel. The same settings are available in the panel for working with headers and footers in the “Design” tab. The tab is only available in header and footer editing mode.

Built-in elements

MS Excel offers built-in elements and even entire headers and footers that are already pre-installed and ready to use. They are available for selection in the menu, respectively, of the top header and the bottom “footer” in the menu for working with footers.

The most suitable text is selected from the list, containing the page number, date, name or path to the file. If none of the options is suitable, you can arbitrarily combine the necessary elements using the buttons on the “Header and Footer Elements” panel in Excel (the “Design” tab), adding not only the serial number, but also the number of pages, the date and time the file was created, the name and path to the file, name of the sheet or picture.

After working with the headings, you can click anywhere on the page to edit the rest of the information on the sheet. At the same time, you will continue to see headings with “footers”. If you need to switch to normal sheet viewing, just turn on normal mode on the “View” tab, “Book View Modes” toolbar.

Removing headers and footers

Sometimes there is a need to remove the header and footer in Excel. For example, if the file came from outside, and for work and subsequent use the information contained in the headers is not valuable and even undesirable.

To remove headers and footers, switch to page layout mode using the corresponding button on the View tab. Excel will display information that is normally hidden. The second way to display headers and footers is to use the tool of the same name in the “Text” panel of the “Page Layout” tab.

To delete one or more blocks, select the one you need and press the Delete or Backspace key on your keyboard. If you want to remove the header, footer, or both entirely, you can do this in Design mode by selecting “none” in the Header or Footer menu in the Header or Footer panel, respectively.

Now you know how to insert headers and footers in Excel, make settings and remove them if necessary.

Headers and footers in Excel 2010

When finalizing a document in the Microsoft® Excel® 2010 editor, you can add to the pages headers and footers, representing text or graphic information containing the title of the chapter, the author of the book, section number and graphic design elements. Let's consider how to insert headers and footers.

Each section of the document can have its own header and footer. First, you need to select the “Page Layout” viewing mode by clicking on the corresponding icon in the lower right corner of the program window.

As you can see, there is a margin at the top and bottom of the page to place the header and footer. The header and footer area is also marked on the rulers located along the edges of the document page. By holding the left mouse button on the bounding area of ​​the header and footer and dragging the cursor, you can determine the size of the header and footer area. It is worth noting that all basic text formatting is available in the footer.

Now go to the “Page Layout” tab and click on the “Page Setup” icon.

In the dialog box that opens, go to the “Header and Footers” tab.

Here you can select header and footer templates from the corresponding drop-down lists, for example, assigning the document page number as the header, and the workbook sheet number as the footer. Thus, the header and footer in Excel® is also used to place page numbering.

You can create your own header or footer template by clicking on the “Create Header” and “Create Footer” buttons.

In the dialog box that opens, you can customize the information in the footer, as well as its location.

You can also insert a header and footer into the document by going to the “Insert” tab and selecting the command in the “Text” group "Header and footer".

As you can see, the “Working with headers and footers” tab has opened. Designer”, where you can select all the necessary parameters for the created header and footer. It is worth noting that when this command is executed, the worksheet will be divided into standard A4 sheets in portrait orientation according to the default settings in the Page Setup window.

To return to the worksheet, click on any cell.

The header and footer on the first page of a document may differ from the header and footer on all other pages. In an open worksheet window, click the text entry cursor in the header or footer text box.

On the “Design” tab, expand the “Options” button menu and activate the “Special header and footer for the first page” value.

Now you can format the header and footer of the first page without changing the header and footer of the remaining pages of the document. To return to the worksheet, also click on any cell.

You can also add different headers and footers to your document for even and odd pages. For this worksheet, click the text entry cursor in the header or footer text box.

On the "Design" tab, expand the "Options" button menu and activate "Different headers and footers for even and odd pages."

As you can see, the header title now says “Odd Page Header.”

In order to edit the header and footer, left-click on it and enter the necessary information in the text field that becomes active.

Then secure the entered information by clicking on an empty table cell.

To delete a header and footer, left-click on the area of ​​the header and footer that you want to delete.

Using the Delete or Backspace keys, delete all data in the header and footer area. If there is no data in the header and footer, the header and footer will not be displayed either.

Thus, using headers and footers, you can design a document for printing, displaying all the necessary information on it.

(0)

Program overview
	1.	Program interface	4:21	2	81866
	2.	File menu	2:28	0	24183
	3.	Tab bar	5:03	1	22472
	4.	Command menu	3:08	0	17164
	5.	Viewers	3:41	0	15545
	6.	Basic program settings	2:46	0	16446
Working with books
	7.	Create, open, and save a workbook	7:06	0	18188
	8.	Working with books	4:20	1	14413
	9.	Cells and Cell Range	4:39	1	18364
	10.	Cell names and notes	5:17	11	18630
	11.	Data input	2:37	0	15012
	12.	Autofill cells	1:34	0	17201
	13.	Data Search	2:23	0	15321
	14.	Data formatting	3:22	0	14317
	15.	Graphically formatting cells	2:47	0	14200
Working with tables
	16.	Tables	2:16	0	30963
	17.	Working with tables	4:00	2	34724
	18.	Sorting data	2:56	0	18750
	19.	Results	2:02	0	16561
	20.	Calculated Columns	2:02	0	20925
	21.	Data filtering	2:35	0	15539
	22.	Custom filters	2:03	0	12313
	23.	Pivot table	3:05	0	46371
	24.	Calculated fields	1:52	0	15362
	25.	Consolidation of tabular data	2:30	0	18173
	26.	Table design	2:23	0	13133
	27.	Record a macro	3:00	0	24241
Formulas and functions
	28.	Formula Review	2:42	0	26116
	29.	Copying formulas	2:35	0	13181
	30.	Arrays	2:34	0	15464
	31.	Function Wizard	3:59	0	16326
Working with charts
	32.	Chart overview	3:16	0	19177
	33.	Formatting a chart	2:22	0	6514
	34.	Setting up chart axes	2:02	0	31139
	35.	Chart scale options	1:54	0	6570
	36.	Data Signatures	2:35	0	5632

Headers and footers- This is information that is automatically inserted on each page of a document, such as the title of the document or its section. As soon as you press the button Headers and footers, the appearance of the document on the screen will change, the cursor will blink in the window called Page header, and a tab will appear on the ribbon Working with headers and footers(Fig. 4.44).

The header can have different appearances. You can select it from the button list Page header, or you can, in the Header and Footer Elements group, specify what you want to see on each page of your document. In Fig. 4.44 in the header there will be the page number, date and current time. When you have played enough with the header, in the group Transitions click the button Go to footer.

Open list button Options, and you will see that you can set a special header and footer for the first page and different footers for the even and odd pages. For example, in Fig. 4.45 Author and date are selected as the footer.

To bring the document on the screen into the form you’re used to after typing headers and footers, on the tab View Click the Normal button.

We will talk more about the View tab in the corresponding section. In Group Text there are three more buttons. With their help you can add an object to the table WordArt, signature line and insert a foreign object into the table (insert an object from another file so that it can be changed in the program in which it was created).

27.10.2012