How to Insert Footer in Excel

If you are new to Excel and want to add a professional touch to your spreadsheets, inserting a footer can be a great step. The footer is a section at the bottom of your worksheet where you can place important information such as page numbers, company name, or copyright notice. Although it may seem like a minor detail, including a footer can make your spreadsheet look more polished and impressive. In this blog post, we will guide you through the simple steps to insert a footer in Excel.

What is a Footer in Excel?

A footer is a section of a worksheet that appears at the bottom of every page, including when you print or export the sheet. It is a great place to put detail information such as page numbers, date and time, file path, names, company name, logo, or any other specific information you want to include on every page.

How to Insert a Footer in Excel?

Step 1: Open Your Excel Sheet

First, open the Microsoft Excel program and select the worksheet where you want to insert the footer.

Step 2: Click on the Insert Tab

Next, click on the “Insert” tab located at the top left corner of the window. The “Header & Footer” section is in the middle of the toolbar.

Step 3: Choose the Type of Footer You Want to Add

You will see three Footer options to choose:

1. Blank: This option will open a footer that is blank and ready to customize.
2. Page Number: This option will insert a page number into the footer section.
3. Page X of Y: This option will insert “Page X of Y” into the footer section, where “X” is the current page number, and “Y” is the total number of pages.

Select the appropriate footer option according to your requirements.

Step 4: Enter the Information into the Footer

Now you can enter your desired information into the footer section. You can add text, numbers, symbols, and any other information. You can also adjust the margins of the footer by clicking on the “Footer margin icon” and dragging it to the left or right as per your need.

Step 5: Save Your Footer Changes

Finally, select the “Close Header and Footer” button to save the footer changes. You can preview your footer by going to “File” -> “Print preview” or “Page Layout” -> “Page Layout view.”

By following the above steps, you can add a footer to your Excel sheet and include essential information that can make your worksheet look more professional and systematic. You can repeat these steps to create a custom header and make it consistent on every page. Adding a footer may seem like a small addition, but this simple feature can make a big difference in the quality of your Excel sheets!

Customize Your Footer

You can customize your footer using different options, such as font style, size, color, and alignment. To do this, click on the “Design” tab located in the Header & Footer Tools in the toolbar. From here, you can select predefined footer templates and change the font style, size, and color to suit your needs. You can also add images, pictures, logos, and other graphic elements to give your footer a distinctive look.

Moreover, you can also add fields such as the total number of pages, current date and time, worksheet name, file name, and path. To include these options, click on the “Insert Fields” button in the Header & Footer Tools, and select the required option.

Modify and Remove Footer in Excel

If you need to modify header or footer information, simply go to the “Header & Footer” section and double-click on the relevant section. This will open the header or Footer area where you can make changes. Once you make the changes, click on the “Close Header and Footer” option to save the changes.

If you want to remove the footer section from your worksheet, go to the “Header & Footer” section and click on the “Header & Footer Tools” option. Select the “Footer” option and click on the “Remove Footer” button. This will remove the footer from your worksheet.

Adding and customizing a footer section in Excel is an easy and convenient way to provide essential details to your worksheet without taking up valuable space within the cells. Using this feature can enhance your spreadsheet’s appearance and give you a more professional look. Follow the quick steps and customize your footer section to make your worksheet more organized, systematic, and visually pleasing!

FAQ

Here are answers to some of the frequently asked questions related to inserting a footer in Excel:

Can I use different footers for different pages in Excel?

Yes, you can use different footers for different pages in Excel. To do this, click on the “Page Setup” button in the “Page Layout” tab, and select the “Header/Footer” tab. From here, you can choose the “Different first page” option to create a unique footer for the first page. Similarly, choose the “Different odd & even pages” option to create a different footer for odd and even pages.

How do I remove the page number from the footer section in Excel?

To remove the page number from the footer section in Excel, go to the “Header & Footer” section and double-click on the footer area. Delete the text that represents the page number, and click on the “Close Header and Footer” option to save the changes.

Can I include custom text in the footer section in Excel?

Yes, you can include custom text in the footer section in Excel. This is an excellent way to include important details such as company name, logo, or copyright notice. To do this, open the header & footer section, click on the “Footer” tab, and enter the text you want to include.

What are the benefits of using a footer in Excel?

A footer in Excel can enhance the spreadsheet’s appearance and improve its readability. It is also an excellent way to provide relevant details such as page numbers, author information, or copyright notices. A footer can also make your Excel sheet look more professional and well designed.

How do I edit the footer size and position in Excel?

To edit the footer size and position in Excel, click on the “Page Layout” tab and navigate to the “Page Setup” section. From there, choose the “Margins” option and locate the “Footer” box on the bottom of the dialog. Here, you can modify the footer size by inserting the desired dimensions or dragging the margin icon. You can also select the “Center on page” option to align the footer text to the center of the page.