How to insert and delete header, footer, and header picture in Excel?
Do you need to insert the page numbers in printed workbook as well as author name, current date and file name? The Microsoft Excel’s Header/Footer command can help you show information in the header or footer at the top or bottom of each printed page easily. And you can also add some images in the header, such as your company’s logo, etc.
Insert header and footer with Header & Footer Tools Insert workbook information (workbook name, worksheet name, user name, etc) as header and footer Insert picture or logos in header or footer Delete any kind of header or footer
Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Insert header and footer with Header & Footer Tools
You can follow these steps to insert header and footer in Excel easily.
Note: You can also type custom header or footer into the Header box or footer box as you need. See screenshot:
Insert workbook information (workbook name, worksheet name, user name, etc) as header and footer
If you have Kutools for Excel installed, you can quickly insert the current workbook’s information as header or footer easily., such as workbook name, sheet name, workbook’s saving path, user name, etc. Please do as follows:
Kutools for Excel – Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Free Trial Now!
And now the specified workbook information is inserted as header or footer immediately.
Kutools for Excel – Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!
Insert picture or logos in header or footer
Sometime you want to display some images at the top of worksheet in every printed page, such as company logo, or others. You can do it with following steps:
Note: If you are using Excel 2010 or older versions, this dialog box won’t come out. Please just skip this step.
Delete any kind of header or footer
Demo: Insert workbook information as header and footer
Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails…
More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.