How To Print Odd Pages In Excel 2010

How To Print Odd Pages In Excel 2010

How To Print Odd Pages In Excel 2010. Click the page setup button. Enable the sheet you want to print its odd or even pages, and press alt + f11 keys to open the microsoft visual basic for application s window.

How to Print Even or Odd Pages of a PDF Adventures with Art
How to Print Even or Odd Pages of a PDF Adventures with Art from adventureswithart.com

Print odd or even pages only with macro code. Then click kutools plus > printing > print specific pages, see screenshot: Enable the sheet you want to print its odd or even pages, and press alt + f11 keys to open the microsoft visual basic for application s window.

Sub Printtwopages () Dim Sht As Variant For Each Sht In Activewindow.selectedsheets Sht.printout From:=1, To:=2, Preview:=True Next Set Sht =.

On the page layout tab in the page setup group click the dialog box launcher next to page setup. Click the worksheet for which you want to change the printing order. Another way is by developing a macro using vba which is specifically instructed to print these even or odd pages using excel 2010.

Setting The Print Area And Print Titles.

Click page layout > page setup button, see screenshot: Select the “odd page” tab and insert a. Select the page layout tab.

With The Print Area Selected, Save The View.

Two tabs are now visible at the top of the screen. Open the worksheet you need to print only the odd pages, then click kutools plus > printing > print specified pages. In the page setup dialog, under margins tab, check horizontally and vertically checkboxes from the center on page section, see screenshot:

Click The Page Setup Button.

In word 2010 it is still being used. The following macro implements this technique: If you want to print directed pages and limited sections of a file, you need to give selective page command in order to automatically print the desired segments.

Use The Mouse To Select All The Cells Of Page 1.

In the print specified pages dialog box, select the odd pages option, and then click the print button to start printing the. And then only the odd pages or even pages have been printing. Ensure that “different odd and even pages” has been selected.

Leave a Comment