Insert PDF into Excel with Data. When searching for software to deal with the documents you have to These options differ in terms of how many files you can upload at once, how well data is converted iSkysoft PDF Editor 6 Professional for Mac can also perform the following functions You will have tools like bookmarking, bates numbering, customizing the header and footer.
This guide will show you how to insert a header or a footer on your printed Excel files in just a few simple steps. Read on to learn the method and you will be able to insert a header and footer in Excel 2010, 2013 or 2016 in no time at all…
What is a Header and Footer?
It is always worth explaining the basics first as nothing is obvious until you know! A header is the section of a page at the top in which you can place titles, comments or notes and a footer is the same but found at the bottom of the page. Headers are often used for Titles, Sub Titles, Company Logos and the like while Footers are often used to show page numbers, details of the worksheet creator and anything else you might feel important to show on every printed Excel sheet:
Why Use Header’s and Footer’s?
Excel worksheets and reports are still commonly printed out on paper and inserting a Header and Footer on your Excel workbook ensures that certain pieces of information are retained when that file is printed out. For example the date the report was created is useful in a time-sensitive environment, the fact the document should be treated as confidential is another one commonly used in the business world or simply a page number which is useful in reports that print over multiple pages.
How to Insert a Header and Footer in Excel
It’s nice and simple to insert a Header and Footer into an Excel 2010 onward workbook, first set up your worksheet(s) for printing then go to “Page Layout” and left-click “Print Titles” on the Ribbon bar that runs along the top of the worksheet:
When you have left-clicked on “Print Titles” the following option box will appear:
The from that option box select the “Header/Footer” tab at the top, this will now display your Header and Footer options like so:
In order to insert a header or footer left-click on the “Custom Header…” or “Custom Footer…” buttons, you will then be presented with the details box for which you can enter the information you want shown on your header or footer:
The header and footer details box (header shown in above image) contain 3 sections, representing areas on the worksheet. You can place information in all of these, or just 1 or 2 depending on what you want to display:
The information can be free-typed into the appropriate box by left-clicking inside the box, this moves the flashing cursor to that section and you can begin typing away.
Excel also provides some very useful quick commands that can be deployed by first making sure the flashing cursor is in the required section, and then left-click one of the quick command icons:
Working from left to right these commands achieve the following when left-clicked:
- Format Text: Useful for changing the style, font or colour of the header/footer text.
- Insert Page Number: Places the page number of the workbook on the header/footer section.
- Insert Number of Pages: This is the total number of pages to be printed. You can combine this with the “Insert Page Number” and some text to have a header or footer like “Page 1 of 3”.
- Insert Date: Places the date in the header/footer
- Insert Time: Places the time in the header/footer
- Insert File Path: This will output the full file path of the Excel file, such as “C:/My Documents”
- Insert File Name: This will output the fill file name of the Excel file
- Insert Sheet Name: This will display the Excel worksheet name on the header/footer
- Insert Picture: Allows you to select a picture to insert into your header or footer. This is really useful for company logo’s that go on every printed document.
- Format Picture: This is shaded out slightly and is only selectable if you insert a picture into the header/footer. Once you do it allows you to make basic formatting to the image.
So if you wanted to display a header with the words “Confidential Report” on the top left, the date on the top right and the page number central at the bottom you would:
1) Select “Custom Header…”
2) Select the “Left Section” and type “Confidential Report”
3) Select the “Right Section” and left-click the “Insert Date” quick command icon
4) Then left-click “OK”
5) Select “Custom Footer…”
6) Select the “Center Section” and left-click the quick command icon for “Insert Page Number”
7) Left-Click “OK”
And that’s it, if you print preview you will see the changes have been made to the header and footer of your file:
If this, or any post of mine has helped you out then please leave a comment to share your experiences with other readers and myself.
Keep Excelling,
Have you ever printed an excel file with multiple tabs or worksheets, only to find you can’t tell which page came from which worksheet? There are several ways to solve this one, but the easiest is to just put the worksheet name in the header or footer, so that when you print the file, each page indicates the sheet it came from.
To include the worksheet name on every sheet:
- Start on the first worksheet, and highlight all the others by holding the control button and clicking each sheet name. This will apply the footer to all the sheets at once so that you don’t have to set each sheet individually.
- Go to the Page Layout, Page Setup menu and click the Header/Footer tab.
- Choose Custom Header or Custom Footer, depending on where you want the sheet name to appear
- Put the cursor in the Left, Center or Right sections and and select the icon that looks like a spreadsheet with multiple tabs at the bottom. This will put the formula &[Tab] into the space. Click OK.
- Print preview the file to ensure that the worksheet name appears where you would like it. If you need to adjust your margins so that there is enough space for the header/footer to not overlap data, you can.
- When you go to print, be sure you are on the first tab, and select Print Entire Workbook so that all the pages print at once.
If you need help formatting your spreadsheet to print, see this previous post on tips for formatting your excel spreadsheet to print.
Need help with a print job? Give us a call at 512-472-9911 or visit our printing services page to learn more about how we can help!