Excel 2010 Prints nonadjacent areas on the same page

Sometimes we don't want to print an entire table in Excel, just want to print part of the data, for example, to print multiple nonadjacent areas of data on the same page, how do you do in Excel 2010?

STEP01 open the. xls table file you want to print. Make a view of the whole table first, by clicking on the View menu, clicking the Custom Viewport button in the workbook view to open the View manager, click the Add button to the right, enter a view name in the Pop-up Add View dialog box (for example, print all the data), and then press OK to exit.

　　

STEP02 Hide columns and rows that do not need to be printed in the table. First click the mouse to select the first column without printing, hold down the CTRL key, and then use the mouse to select the other columns to hide, so that you can select multiple noncontiguous columns. Move the mouse over the column name cell, right-click the mouse, hide in the pop-up menu, and hide the columns without printing. Hide all lines that do not need to be printed as shown in the previous method. Next click on the View menu, click on the Custom View button to open the Views manager, add a view that contains only the rows you want to print (for example, print a report), and then press OK to exit.

　　

STEP03 need to print multiple nonadjacent areas on the same page, display the view (such as a printed report) in Excel 2010 first by clicking the View menu, clicking the Custom Face button to open the viewport manager, selecting the view (such as printing a report), and clicking the Display button, so that the table Only the data you want to print is available. Then click on the file → hit the Ying menu, open the Punch dialog box, under the settings to select the print selection options, set a print area, the last single hit Ying button can be.