Paste the following code and press start above: Sub PrintOddOrEvenPages()ĭim TotalNumberOfPages, StartPageNumber, CurrentPage As Double Right click on and worksheet on the left hand side and click on “Insert” –> “Module”. Open the VBA editor by clicking on “Visual Basic” on the left hand side of the “Developer” ribbon. You still want to print all odd or or even pages? The only option is a short VBA macro.
You might have to search a little bit for that option.
Then the printer menu options – this windows looks different for each printer. Then click on the “Printer Properties” button (number 1 on the image). As usual, you will see the print preview. Therefore, press Ctrl + p on the keyboard. Most printers offer such option so that you don’t have to worry about odd and even pages. Most printer offer a two sided print option.įirst 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. 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Ĭode for inserting in Header/Footer window 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. Therefore enter “Page ” then click on button 4, type ” of ” and click on button 5. Once you’ve selected a picture with button “11” you can modify it by clicking on button number 12.Įxample: You want to insert “ of 3”. In most cases, you need at least to define the correct size of your picture.
Just click the button and select your picture. Besides the file path, you can also insert the file name.If you only want to insert the path without the file name, type “&”. By default, Excel adds the path and file name.
Insert the file path of your workbook.This is the date at which you are printing the workbook – not the last save date. Also this number depends on which sheets you are going to print. If you just print the second worksheet of your workbook, the numbering will still start at 1. This number will depend on the sheets you are printing. Insert the number of the current page.You can change the font style by clicking on the “A” button (number 3). Add a custom text by just typing into one of the text boxes.Now you’ve got many options for defining headers and footers. Click on “Custom Header” or “Custom Footer”.Now go to “Page Setup” and navigate to “Headers and Footers”. Enter the print screen by pressing Ctrl + p on the keyboard.Follow these steps for inserting headers and footers (the numbers are corresponding to the image on the right hand side): The advantage is that you won’t mix up the printed pages.