Playback starts YouTube’s embedded player (privacy-enhanced mode).
Insert Header and Footer in Excel - Tutorial
ChannelYAcosta SolutionsDescription from the creator
In this Excel tutorial, we walk through how to insert Header and Footer notes in your spreadsheet, your Header & Footer options, and how you can format your Headers and Footers.
Excel makes it easy to insert Header and Footer fields to your reports. You just need to know your options and how to get to them.
We start by going over where you can find the option to insert a Header & Footer.
You'll see how you can quickly get to a list of popular Header or Footer fields to insert in the center section of your header or footer.
For more personalization, we then review some of the Header, Footer reference elements. These elements update based on changes to your spreadsheet or workbook. For example, the Page Number field will update as the number of pages in your spreadsheet changes.
You'll then see how to add a different header or footer on the first page of your document than the rest of the pages. Or how you can create different header / footer notes for even and odd pages.
We end with how you can insert a logo in the header and then format the image so that it fits and displays the way that you want for it to look.
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
Excel makes it easy to insert Header and Footer fields to your reports. You just need to know your options and how to get to them.
We start by going over where you can find the option to insert a Header & Footer.
You'll see how you can quickly get to a list of popular Header or Footer fields to insert in the center section of your header or footer.
For more personalization, we then review some of the Header, Footer reference elements. These elements update based on changes to your spreadsheet or workbook. For example, the Page Number field will update as the number of pages in your spreadsheet changes.
You'll then see how to add a different header or footer on the first page of your document than the rest of the pages. Or how you can create different header / footer notes for even and odd pages.
We end with how you can insert a logo in the header and then format the image so that it fits and displays the way that you want for it to look.
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
About this tutorial
YAcosta Solutions published this 5:38 video tutorial on October 28, 2019. It has been watched 15,884 times on YouTube.
- Channel
- YAcosta Solutions
- Category
- Education
- Duration
- 5:38
- Published
- October 28, 2019
- Views
- 15,884
- Likes
- 40
Tags
Share
This tutorial in other languages
- FRInsérer en-tête et pied de page dans Excel - Tutorial
- ESInsertar encabezado y pie de página en Excel - Tutorial
- PTInserir cabeçalho e rodapé no Excel - Tutorial
- ITInserisci intestazione e piè di pagina in Excel - Tutorial
- DELegen Sie Kopf- und Fußzeile in Excel - Tutorial
- NLInsert kop- en voetteksten in Excel - Tutorial
- RUВставьте Колонтитулы в Excel - Учебник
- PLWkładka Nagłówek i stopka w Excelu - Tutorial
- JAチュートリアル - Excelで挿入ヘッダーとフッター
- ARإدراج رأس وتذييل في Excel - دروس
- HIहैडर सम्मिलित और Excel में पाद - ट्यूटोरियल
- IDInsert Header dan Footer di Excel - Tutorial