How to insert Header and Footer in Excel : Tutorial
How to insert Header and Footer in Excel : Tutorial
How to insert Header and Footer in Excel
Headers and footers are used to add the same information on every page of the spreadsheet without actually entering the information on each worksheet. If you wish to insert Header and Footer in Microsoft® Excel 2013 then follow the easy steps shown in this video.
Content in this video is provided on an “as is” basis with no express or implied warranties whatsoever. Any reference of any third party logos, brand names, trademarks, services marks, trade names, trade dress and copyrights shall not imply any affiliation to such third parties, unless expressly specified.
Content
7.74 -> Hi Friends,
Headers and footers are used to add the same
11.46 -> information on every page of the spreadsheet
without actually entering the information
15.82 -> on each worksheet.
17.61 -> Here is how you can insert header and footer
in an Excel 2013 worksheet.
24 -> Open excel 2013 and then open a worksheet
Here on the bottom of the page we can see
30.849 -> the options like Normal, Page Layout and Page
Break Preview
36.21 -> Just click on the Page Layout option
Now if you take the cursor to the top of the
41.51 -> page, you will see 3 headers Center, left
and Right
47.03 -> Once you click on the header then a header
& footer tools will appear
51.21 -> Here we have different sections which can
be used to insert header and footer
56.18 -> If you want to insert a default set of header
then click the Header icon on the Header & Footer
61.48 -> Tools section, and then select the option
you want
65.059 -> Here you can see the file name and the page
number is inserted automatically
70.49 -> Now if you click on the header you will see
a formula instead of your file name.
75.229 -> Just remove it and remove the page number
formula too
79.53 -> Click on the Center Header, and then click
on design tab under Header and Footer tools
85.189 -> Here we are inserting File Name in the Center
header
88.579 -> Current Date and Current Time in Left header
Page number and the total number of pages
95.659 -> in the right header.
97.88 -> Here it shows the page number as 1 and the
total number of pages as 3
103.35 -> Now let's click on Go to Footer icon under
Navigation section
107.539 -> For demo, we are inserting the file path in
the footer
111.88 -> Click on the first footer and you will be
able to see the file path instead of formula
118.09 -> Click on Go to header
Now when you click anywhere out of the header
122.48 -> or footer area, you will see that the Header
and Footer Tools have disappeared.
126.609 -> Hope this was easy
to follow.
138.76 -> Thanks for watching!
Source: https://www.youtube.com/watch?v=mgDBVVxtgvk