Although Word makes it easy to insert a footer, limiting that footer to only one page poses a much harder task. How to Insert a Footer on Only One Page in Microsoft Word; How to Insert a Footer on Only One Page in Microsoft Word. By: Lily Medina. Share; Share on Facebook. Does anyone use Excel on a Macbook Pro? I'm an old pro on PCs, but I'm tired of carrying around two computers or running Windows on my Mac. Has anyone had success building financial models on a Mac OS running Excel?
To make header and footer on the first page of the current worksheet different from the rest of the pages, click the “Page Layout” tab. In the “Page Setup” section, click the “Page Setup” button in the lower-right corner. The “Page Setup” dialog box displays. Click the “Header/Footer” tab. Click the “Different first page” check box so there is a check mark in the box. Once you’ve turned on the “Different first page” option, you can customize the header for the first page of the spreadsheet and the header for the rest of the pages. Click “Custom Header”.
The “Header” tab is where you specify the header for all the pages after the first page, which, in our example, is the. For the first page of your spreadsheet, you may want to leave the header blank, which is the default. However, for our example, we’ll add different text. To do so, click the “First Page Header” tab. Click in the “Left section” box, “Center section” box, or “Right section”, depending on where you want to put the content of your header.
You can have content in all three boxes. We’re going to add the filename to the center of the header, so click in the “Center section” box and then click the “Insert File Name” button.
To accept your changes and close the “Header” dialog box, click “OK”. You’re returned to the “Page Setup” dialog box. Click “OK” to close it. We created a custom header in this example, but you can also create a custom footer in the same way using the “Custom Footer” button on the “Page Setup” dialog box. You can also use this dialog box to make the header and footer different for odd and even pages, by selecting the “Different odd and even pages” check box on the “Header/Footer” tab on the “Page Setup” dialog box.
Then, you can customize the different headers and footers for the odd and even pages using the “Custom Header” and “Custom Footer” buttons.
First step: Press Ctrl + p on the keyboard and see the print overview Starting is simple: Press Ctrl + p on the keyboard. Now you can see the print preview and change the print settings as shown on the image on the right hand side. But the actual work begins now: Defining the print range, page settings and all the other settings in detail. But maybe you got luck and somebody formatted the printout already Most settings can also be accessed via the Page Layout ribbon. The advantage to to it within the print screen (as shown in the image above) is that you can see changes right away. How to squeeze everything on one page? By default, Excel often wants to print your worksheet in a large size and spreads it over many pages.
Fortunately there is a quick method of squeezing everything on one page:. Open the print preview dialogue by pressing Ctrl + p on the keyboard. On the left hand side click on “No Scaling”. Now you got the following options:.
“Fit Sheet on One Page”. That way everything will be squeezed on one printout page.
“Fit All Columns on One Page”. Excel scales your page so that all columns are on one sheet. Rows might extend over several pages though.
“Fit All Rows on One Page”. As it says, all rows will be fitted on one page. That means, the columns could spread over several pages. Set the print range with just two clicks on the Page Layout ribbon. The fast way of setting the print range: Select the cell on the worksheet which you want to be printed. Now click on “Print Area” on the “Page Layout” ribbon (number 1 on the picture on the right hand side).
After that, click on “Set Print Area”. One more advice: There is a tiny arrow in the right bottom corner which opens the window for all the printing preferences (number 2). With this button you can also set the rows and column to repeat.
For more information on that topic please check the paragraphs below. Switch to “Page Break Preview” for fine tuning the print range.
Especially when printing large worksheets on more than one page, you might want to fine tune the print range. For example, change the page break. Therefore, switch to “Page Break Preview”: Click on “Page Break Preview” on the “View” ribbon. Excel then shows you the pages with blue and dotted blue lines. Not printed areas are greyed out.
You can drag and drop these line to your desired format. Please note that the mouse arrow often doesn’t work correctly: In many cases it doesn’t switch to the drag and drop mouse pointer. If that happens to you: just proceed. Usually the dragging and dropping still works well. Set the rows and columns to repeat by clicking on “Print Titles” within the “Page Layout” ribbon.
If your worksheet spreads over more than one printed page, you can define rows and columns to repeat. That way, the header row or column will be printed on each page. Large tables are much easier to read. You have to go through the “Page Layout” ribbon and set the print range there.
Click on “Print Titles” within the “Page Setup” section on the “Page Layout” ribbon. Select the rows or column you want to be repeated. Confirm by clicking on “OK”. Please note: You can’t change these settings if you go through the print preview window (see paragraph below). Set print headers and footers easily Very useful: Define headers and footers. The advantage is that you won’t mix up the printed pages.
Follow these steps for inserting headers and footers (the numbers are corresponding to the image on the right hand side):. Enter the print screen by pressing Ctrl + p on the keyboard.
Now go to “Page Setup” and navigate to “Headers and Footers”. Click on “Custom Header” or “Custom Footer”. Now you’ve got many options for defining headers and footers. Add a custom text by just typing into one of the text boxes. You can change the font style by clicking on the “A” button (number 3). Insert the number of the current page. This number will depend on the sheets you are printing.
If you just print the second worksheet of your workbook, the numbering will still start at 1. Insert the total number of pages.
Also this number depends on which sheets you are going to print. Insert the current date. This is the date at which you are printing the workbook – not the last save date.
Insert the current time. Insert the file path of your workbook.
By default, Excel adds the path and file name. If you only want to insert the path without the file name, type “&Path”. Besides the file path, you can also insert the file name. Often useful: Insert the sheet name. You can also insert a picture. Just click the button and select your picture. In most cases, you need at least to define the correct size of your picture.
Once you’ve selected a picture with button “11” you can modify it by clicking on button number 12. Example: You want to insert “Page 2 of 3”. Therefore enter “Page ” then click on button 4, type ” of ” and click on button 5. These settings you can also add in different ways by typing the code. If you want to work with the codes, please refer to this table. For those of you who like to do some VBA programming we’ve also added the corresponding VBA code but we won’t go more into detail here: Header/Footer element Code for inserting in Header/Footer window VBA code Insert Page Number &Page &P Insert Number of Pages &Pages &N Insert Date &Date &D Insert Time &Time &T Insert File Path &Path &Z Insert File Name &File &F Insert Sheet Name &Tab &A. Change the print settings for several sheets at the same time Changing the print settings for several worksheets simultaneously is quite easy: Select all the sheets and press Ctrl + p on the keyboard.
Now the changes will be applied to all the selected worksheets. Attention: Even if you just want to change one setting (e.g.
The headers and footers), everything will be resetted, for example also the print range or orientation. You could use this method as a starting point: Roughly define the print settings for all worksheets and afterwards fine tune each sheet separately. Please refer to the next point if you want to change or update headers and footers for many sheets at the same time. Comfortably change headers and footers with Professor Excel Tools – all other print preferences will remain! As described in our previous point, Excel destroys all existing print settings if you want to change the headers and footers of several sheets simultaneously. You basically have two options:.
Change the header and footer manually on each worksheet. Use an Excel add-in. Our Excel add-in “” provides a simple and comfortable tool for changing printing headers and footers without destroying existing print preferences like the orientation. Even better: It saves your previous print preferences. Most printer offer a two sided print option.
First question: Why do you want to print odd or even pages only? If the reason is that you want to print your Excel sheet on front and back side of the paper, please take a look at the print menu first.
Most printers offer such option so that you don’t have to worry about odd and even pages. Therefore, press Ctrl + p on the keyboard.
As usual, you will see the print preview. Then click on the “Printer Properties” button (number 1 on the image). Then the printer menu options – this windows looks different for each printer.
You might have to search a little bit for that option. You still want to print all odd or or even pages? The only option is a short VBA macro. Open the VBA editor by clicking on “Visual Basic” on the left hand side of the “Developer” ribbon.
Right click on and worksheet on the left hand side and click on “Insert” – “Module”. Paste the following code and press start above. Sub PrintOddOrEvenPages Dim TotalNumberOfPages, StartPageNumber, CurrentPage As Double TotalNumberOfPages = Application.ExecuteExcel4Macro('GET.DOCUMENT(50)') StartPageNumber = InputBox('There are ' & CStr(TotalNumberOfPages) & ' pages selected in total.' & Chr(13) & Chr(13) & 'Which page do you want to start with?' & Chr(13) & Chr(13) & 'This number determines wether odd or even pages will be printed. ' & 'Also make sure that the correct printer is selected as the printing will start right away.'
) If StartPageNumber 0 And StartPageNumber. Hi Henrick very very thanks for your reply but the problem still persists. I have 01 sheet, a lengthy one, 4 or 5 pages(some sheets are loner). Last 3 rows of sheet are for name, signature, date. Similarly top few rows consist of headers, now i want that when i print, top rows should be printed on top of every page (this can be done by print titles).
Also i want last 3 rows to print on bottom of every page (including formatting), this i can’t achieve and need your help for this. Thanks for your time.
Hi shahzad, ok, I think I understand now. As far as I know, you could achieve this on two ways: 1st: You could split the worksheet manually into 5 pages and copy the signature under each of them. This method is not elegant but could work. 2nd: Try to use the printing footers.
If some complex formatting can’t be done there, you also have the opportunity to embed pictures into the footer (at least with recent versions of Excel). If your signature is too complex, try to insert it as a picture. Either way, please let me know if you could make it work.
If you find another way, I’d of course also be interested to learn it. Good luck and best regards, Henrik.