Excel2007 Document Reverse Print settings

In Word2007, just click the Office logo → print in the upper left corner, click the Options button in the Open Print Settings window, switch to the Advanced tab in the Word Options window that appears, and then check the "Print pages in reverse order" option in the print item. This way the printer will print from the last page in reverse order to print to the first page, after printing, the last page naturally at the bottom, and the first page is at the top, so there is no need to rearrange the document in reverse order, can be bound directly to the book, for long print documents especially convenient.

Excel's printing functionality pales in comparison to Word, and there is no improvement to the print functionality in Excel2007. But we only need a little bit of bother, also can let Excel2007 easy to have "reverse print" function.

Operation Steps

A. Printer properties are set skillfully

Some printers can find print options similar to reverse order printing in print properties as long as they have their own drivers installed. Taking the author's Canon Pixma iP1000 as an example "Please install the printer with the driver on the CD" in advance, when printing, just open the Excel2007 workbook, click the Office logo → print in the upper left corner, open the Print Setup window, and select "Canon" in the printer name. Pixma iP1000 ", then click the" Properties "button, bring up the" Canon Pixma iP1000 Properties "window, switch to the Page Settings tab, check the" Reverse "checkbox and click" OK "button.

Two. Macro code realization method

Some printers do not have these properties, but you can also achieve reverse printing by using macros.

Open the Excel file, switch to the "View" tab, click "Macros" → "Record Macro", the "Record New Macro" window, the "macro name" to define a name: Reverseprint, click "OK" exit;

Click "Macros" → "View Macros", select "Reverseprint" under "Macro name" and click "Edit", open the Microsoft Visual Basic Editor, replace all the code in the right window with the following, and then save the VBA editor:

Sub Reverseprint ()

Dim numpages as Long, Page as Long

NumPages = ExecuteExcel4Macro ("Get". DOCUMENT (50) ")

For Page = numpages to 1 Step-1

Activesheet.printout From:=page, To:=page

Next Page

End Sub

Then click "Macros" → "View Macros", select "Macro name" under "Reverseprint" and click "Execute" that is, reversible sequence printing.