From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Customize headers and footers
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Customize headers and footers
- [Jennifer] If you have information that you would like to show on each printed page of a worksheet, then you'll want to use headers and footers. After watching this video, you'll know how to use the built-in options available to you for headers and footers and you'll know how to create a custom header or footer for your worksheet. Let's jump right into our Headers_Footers document and take a look at our Q1 2019 internet orders. We're going to use a header to give more information to our users about this document. Let's go to Insert, all the way over to the right on the ribbon, we'll click on Text and Header and Footer. We're now in a different view of our workbook and we're able to see the header margins at the top. They're divided into three regions, a left, a center, and a right. And if I scroll down to the bottom, you'll notice that I also have that same setup in my footer area, a left, a center, and a right footer. Now, when we're working in our header and footer view, we have…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Import TXT or CSV data into a new workbook3m 22s
-
(Locked)
Import TXT or CSV data into an existing workbook3m 7s
-
(Locked)
Search for data within a workbook2m 36s
-
(Locked)
Navigate data with named ranges and hyperlinks5m 27s
-
(Locked)
Format worksheets and workbooks5m 1s
-
(Locked)
Customize headers and footers4m 37s
-
(Locked)
Display and modify content in different views5m
-
(Locked)
Modify basic workbook properties2m 33s
-
(Locked)
Customize the Quick Access Toolbar3m 55s
-
(Locked)
Inspect and export workbooks6m 33s
-
(Locked)
Configure print settings4m 15s
-
(Locked)
Challenge: Manage worksheets and workbooks1m 10s
-
(Locked)
Solution: Manage worksheets and workbooks9m 10s
-
-
-
-
-
-
-