Excel provides short-cut commands for different types of information you may want to add to your header or footer.ĥ. Look in the ribbon and go to the Header & Footer Elements grouping of commands. Select the box where you want to add the information (Left, Center or Right).Ĥ. This activates the Header and Footer Tools>Design menu in the ribbon.ģ. Click on the text to open the header text boxes. Adding a Headerįor the header of our document, we will add the page number and date. Now that we have an overview of the Page Layout view, let's look at the steps to adding the details. This allows you to decide where you want the information. Click on the right-hand side and…well, I think you get the idea. Click in the center, and the center text box is activated. Yes, 'boxes.' It is not clearly noticeable at first, but if you click your mouse on the left side of the header, a left-hand text box is activated. (Likewise, at the bottom of the page, we have Click to Add Footer.) Clicking on the text will open the header's text boxes. In the Page Layout view, notice the text 'Click to Add Header' that appears centered in the top margin of the page. (It's in the lower, right-hand side of the screen - second icon from the left.) This view can be opened by clicking on the Page Layout view icon located in the status bar at the bottom of the screen. Regardless, if you are adding a header or a footer, the first step is to open the Page Layout view. In this lesson, we will use our client list to demonstrate the steps for adding key information to headers and footers in Excel. There are a several key pieces of information that would be good to include in the header and footer of the document. He would like a printed copy of the client list. My assistant is going to gather the information and send the materials. But first, I want to send them an email, notifying them it's on the way. I would like to send each client a packet of information via postal mail.
Headers and footers only show on the printed Excel document or in the Print>Preview. Headers and footers will usually display information such as the page number, date, workbook/worksheet name and the author. The footer is the text that appears in the bottom margin. The header is the text that appears in the top margin. When adding these to an Excel workbook, it also makes it easier to read. Headers and footers, added to any document, help to make the printed version a bit more professional.