HEADER FOR EXCEL SPREADSHEET HOW TO
Click here and learn how to make it much simpler for your readers to identify cells when reading your data on pieces of paper. Click the OK button at the bottom of the window when you are done.Īnother helpful setting to use in Excel 2013 when you are concerned about printing a spreadsheet is to repeat the top header row on every page. You can then click the Header tab at the top of this window and enter the information that you want to appear at the top of the rest of the pages. Header and Footer is the top and bottom portion of a document respectively, similarly excel also has options for headers and footers, they are available in the insert tab in the text section, using this features provides us with two different spaces in the worksheet one on the top and one on the bottom. Step 7: Enter the contents of your first page header. Step 6: Click the First Page Header tab at the top of this window.
Step 5: Check the box to the left of Different first page, then click the Custom Header button. Step 4: Click the Header/Footer tab at the top of the Page Setup window. Step 3: Click the tiny Page Setup dialog launcher at the bottom-right corner of the Page Setup section of the ribbon. Step 2: Click the Page Layout tab at the top of the window. You will be able to customize the header that only appears on the first page, then you will be able to use a different header for the rest of the pages. The steps in the tutorial below are going to show you how to use two different headers for your Excel 2013 worksheet. Using a Different Header on the First Page in Excel 2013 Our guide below will show you how to specify a header that is different on the first page. But occasionally you might need to put different information on the first page of the spreadsheet that what will appear on every page after the first.Įxcel 2013 offers a formatting option that makes this possible, and you won’t even need to create and link multiple sections of a document.
You can even put a picture in a header or footer.
Headers and footers in an Excel spreadsheet offer a simple way to put repeating information at the top of every printed page of your spreadsheet.