Excel does not correctly print a continuous area of data

If you encounter a large Excel worksheet, but need to print a number of discrete areas of data, it should be how to do? In fact, we can use Excel's "face as Manager" can be resolved without a continuous regional printing problems.

1. Start Excel, open the appropriate workbook file.

2. Implementation of the "View ¡ú as face manager" command, open the "visual plane Manager" dialog box, click one of the "Add" button, in the following pop-up "Add View" dialog box, enter a name (such as " All ", etc.) to determine the return.

3. Hold down the Ctrl key, then use the mouse without the need to print each column (row) label, click at the same time do not need to print out to select multiple columns (lines). Then right-click the mouse, in the following pop-up shortcut menu, select "Hide" option, will not need to print out the column (row) hidden.

Tip: ¢Ù If you later want a hidden column (row) is displayed, first select the Hide while column (row) left (from top to bottom) of column (row), and then right-click the mouse, in the following pop-up shortcut menu , choose "unhide" option.
¢Ú Hold down the Shift key, then hold down the left mouse button, in the corresponding column (row) label on the drag, you can also select multiple contiguous columns (lines).

4. Readjust the column widths and row after the higher elements, and then modeled the operation of Step 2 above, add a "print" view.

5. After the need to print this region, the implementation of the "View ¡ú as face manager" command, open the "visual plane Manager" dialog box, select the appropriate view (such as "Print"), and then click the "Show" button, then the normal "print" operation becomes.

Tip: "regional" Print is completed, as long as the "All" view is displayed, the entire worksheet instantly rendered in front of you.

If you need to print the local area is a continuous range of cells that adopt a "Set Print Area" approach will be more simpler: select the need to print the local area, the implementation of the "File ¡ú Print Area ¡ú Set Print Area" command, and then according to their normal "print" operation on OK.

Tip: ¢Ù set the "print area", if there are hidden columns (rows), it will not be printed.
¢Ú If you need to unset the "print area", just click "File ¡ú Print Area ¡ú Cancel Print Area" command on the list.