To specify a custom header, click the “Custom Header” button.Ī “Header” box will open. On the “Page Setup” dialog box, click the “Header/Footer” tab. On the “Page Layout” tab, in the bottom-right corner of the “Page Setup” section, click the arrow icon. While your worksheets are selected, in Excel’s ribbon at the top, click the “Page Layout” tab. Do this by holding Shift while you click on each worksheet tab. To add a header to several worksheets at once, first, launch your spreadsheet containing multiple worksheets in Excel.Īt the bottom of the spreadsheet, select the worksheets in which you want to add a header.
How to Put a Header on Multiple Worksheets Later, if you decide to delete the header, follow the above steps and clear the contents of the header. Your selected worksheet now has your custom header on it. To go back to Excel’s default viewing mode, in the ribbon at the top, click View > Normal.Īnd that’s it.
Similarly, if you’d like a different header for the first page, or different headers for the odd and the even pages, use the “Different First Page” and “Different Odd & Even Pages” options at the top. If you want to add dynamic content to your header, such as the current page number or the current date, then in Excel’s ribbon at the top, click an appropriate option. To stop editing the header, click anywhere outside of the header section. Click each section and add your header content. Your worksheet’s view will immediately change, and you can now start adding your header.Īt the top of your worksheet, you have a left, middle, and right section to specify your header’s content. In the “Insert” tab, click Text > Header & Footer. In Excel’s ribbon at the top, click the “Insert” tab. In your spreadsheet, at the bottom, click the worksheet in which you want to add a header. To add a header to your single worksheet in Excel, first, open your spreadsheet with Microsoft Excel. How to Insert a Header in a Single Worksheet Use this method if you want to add a header to multiple worksheets at once. The other way to use a header in Excel is to utilize the “Page Setup” dialog box. If you are looking to add a header to a specific worksheet, use this method. One way to add a header in Excel is to use an option in the “Insert” tab. Two Ways to Make a Header in ExcelHow to Insert a Header in a Single WorksheetHow to Put a Header on Multiple Worksheets
It’s easy to add headers in Microsoft Excel, and we’ll show you two ways to do it. This should mean you can see both logo and data appropriately.įind out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Somerset and Hampshire.By inserting a header, you can display the page number, page title, date, or even custom text at the top of your spreadsheets. Make the Top margin bigger, then click OK. In that case, go to File – Print and click Page Setup, then go to the Margins tab. It may then be the size you require but still be covered by some of the data in your worksheet. Click on the Size tab and select a suitable % in the Height and Width boxes. The Format Picture dialog box will be displayed. It may well be too large, in which case, click on your logo again, then in the Header & Footer Elements group, click Format Picture. Move your cursor to another part of the header and your logo will be revealed. Until you move your cursor away from the area you inserted the logo, all you will see is &. Locate the logo you want to insert, then click Insert. (Alternatively, click on the Page Layout icon to the right of the Status Bar.).Ĭlick in the Header section, in the area where you want to insert the icon, then on the Header & Footer tab, and in the Header & Footer Elements group, click Picture. To insert a header, click the Insert tab, then in the Text group, click Header & Footer. When printing off an Excel spreadsheet, or indeed emailing it to a client, you may want to include your company logo as part of the header.