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”.