Applying Header to certain pages I just want to apply a header only to certain pages, not the whole document but I can't seem to get away from 'same as previous'. Every time I apply a header it automatically goes on every page. Select the first page header (double click it) and in the design tab select 'Different First Page'. This will make the header and footer specific to the first page. Move to the second page and remove any header/footers there.
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. You can even. 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. Excel 2013 offers a formatting option that makes this possible, and you won’t even need to create and link multiple sections of a document. Our guide below will show you how to specify a header that is different on the first page. Using a Different Header on the First Page in Excel 2013 The steps in the tutorial below are going to show you how to use two different headers for your Excel 2013 worksheet. 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.
Step 1: Open your file in Excel 2013. Step 2: Click the Page Layout tab at the top of the window. Step 3: Click the tiny Page Setup dialog launcher at the bottom-right corner of the Page Setup section of the ribbon. Step 4: Click the Header/Footer tab at the top of the Page Setup window. Step 5: Check the box to the left of Different first page, then click the Custom Header button. Step 6: Click the First Page Header tab at the top of this window. Step 7: Enter the contents of your first page header.
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. Click the OK button at the bottom of the window when you are done.
Another 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. And learn how to make it much simpler for your readers to identify cells when reading your data on pieces of paper.
This is my first time posting anything so please excuse my lack of post formatting. I've been using this forum the past couple of months to help solve small vba issues I've come across while developing a semi-program in excel. It does a bunch of things I'd rather not explain but ive gotten to the point where I need to set the headder and footer for each page on each sheet. I've gotten where I want to place an image in the header to resemble a predetmined header layout but I need to make the first page a differnet picture than all the other pages. I can successfully place an image in the first page that translates to all the others as well as a place one on all the others but not the first. When I turn 'PageSetup.DifferentFirstPageHeaderFooter = True' and try to access the second or first page properties exclusively it give me an error stating that the property I'm trying to access is not valid. Below is an example of the part of my code I've having trouble with.
![]()
Yea thats what I saw as well. It seems that the '.PageSetup.FirstPage.CenterHeader.Picture.Filename = 'C: Users shg Pictures shg Pics Pot of Gold.jpg' line is what I was looking for. I also found that if you use a written macro the picture may not show up ulness there is already a picture designated for that section so to get around that you can use: 'Sheets(curSheet).PageSetup.FirstPage.CenterHeader.Text = '&G' to initailize the picture and then follow up the next line with the filename.
Thanks for your help!!
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |