In all Office documents, the header represents the top margin of the page while the footer represents the bottom margin. Headers and footers are useful for including information that you want to appear on every page of a document. For example, page numbers, document titles, or footnotes.
In Microsoft Excel, you can only access headers and footers in Page Layout view, Print Preview, or in the Page Setup dialog box.
So if you want to add headers and footers to your Excel spreadsheet, here’s how you can do it.
To include a header or footer in Microsoft Excel, you should do the following:
Step 1: Launch Microsoft Excel.
Step 2: Click the Insert tab.
Step 3: Select the drop-down menu in the Text group.
Step 4: Selecting Header and Footer will change the sheet view to Page Layout.
Step 5: On your worksheet, place the cursor in the field named Title. At the top of the Ribbon, select the elements for your title (Page Number, Picture, Current Time, Date).
Step 6: At the top of the Ribbon in the Navigation field, select Go to Footer to access the bottom margin of the sheet.
Step 7: On your worksheet, place the cursor in the field named Footer. At the top of the Ribbon, select the elements for your footer (Page Number, Picture, Current Time, Date).
Step 8: Select the Escape (Esc) key on the keyboard to exit the Header and Footer menu.
To create a custom header or footer in Excel, you need to access the Page Setup Dialog in Excel. Here’s how it works:
Step 1: Select the sheet where the header or footer will be inserted.
Step 2: On the Ribbon, select Page Layout.
Step 3: On the Field titled Page Setup, click the launcher to see more options. This will open the Page Setup dialog box.
Step 4: On the Page Setup box, select the Header/Footer menu.
Step 5: Select the button titled Custom Header or Custom Footer.
Step 6: In the Left, Center or Right section, enter details about your Header or Footer. This can be Page Number, Image, Current Time, Date. Excel also provides on-screen instructions on how to edit the contents of the header or footer.
Editing or changing headers or footers in Microsoft Excel can only be done through Page Layout View. Here’s how to navigate to the Page Layout view:
Option 1: Change view from bottom right corner of Microsoft Excel
If you’re using Microsoft Excel from your desktop, switching to Page Layout view is pretty straightforward. Here’s how to do so:
Step 1: In the lower right corner of Excel aka the status bar, put your mouse pointer on the icons.
Step 2: Select the icon to display Page Layout View.
Step 3: On your worksheet, place the cursor in the Header or Footer field and make the changes live.
Option 2: Change View From Microsoft Excel’s Ribbon
If you are using Microsoft Excel from the web, this option is more convenient. Here is how it works.
Step 1: On the Ribbon, select View.
Step 2: In the Workbook Views field, select Page Layout. This changes the view to the Page Layout view.
Step 3: On your worksheet, place the cursor in the Header or Footer field and make the changes live.
If the header or footer is no longer needed on the Excel file, you can always delete it. Here’s how to do so:
Step 1: Select the sheet where you need to remove the header or footer.
Step 2: On the Ribbon, select Page Layout.
Step 3: On the Field titled Page Setup, click the launcher to see more options. This will open the Page Setup dialog box.
Step 4: On the Page Setup box, select the Header/Footer menu.
Step 5: On the Field titled Header, select the drop-down arrow. Scroll up until you see the option None.
Step 6: On the Field titled Footer, select the drop-down arrow. Scroll up until you see the option None.
Step 7: Save your changes by clicking OK.
View Microsoft Excel sheets side by side
The functionality of Page Layout View is not limited to inserting headers and footers in Microsoft Excel. You can also use tabs to view multiple Excel sheets side by side.
Categories: How to
Source: thpttranhungdao.edu.vn/en/