Small compile the data that teachs you to print discontinuous area correctly in

If encounter a bigger Excel labour tabulation, need to print the data of a few discontinuous area however, how should do? Actually we can use Excel " the management that look a scale implement " can solve discontinuous area to print a problem.

1. The Excel that start, open corresponding working book file.

2. Carry out " view → inspects face management implement " command, open " the management that look a scale implement " dialog box, click among them " add " pushbutton, playing subsequently those who go out " add view " in the dialog box, input a name (be like " all " wait for) , return certainly.

3. Press Ctrl key, part to be listed in what do not need to print with the mouse next (row) click on grade, at the same time pitch on many do not need to print the list that come out (travel) . Next right attack a mouse, in playing the quick menu that go out subsequently, anthology " conceal " option, will not need to print the list that come out (row) conceal.

Little hint: If ① wants to let a certain hidden list later (row) show come, first at the same time pitch on obscures a line (row) the left and right sides (up and down) row (travel) , next right attack a mouse, in playing the quick menu that go out subsequently, anthology " cancel to conceal " option can.
② presses Shift key, press mouse Zun Jian next, in corresponding row (row) on grade dilatory, can at the same time pitch on many successive row (travel) .

4. Adjust fine line wide mix an advanced element hind, follow again above the operation of the 2nd pace, add " print " view.

5. When need prints this area after, carry out " view → inspects face management implement " command, open " the management that look a scale implement " dialog box, the view with corresponding pitch on (be like " print " ) , click next " show " pushbutton, it is normal to be pressed again " print " the operation was become.

Little hint: "Area " print after finishing, as long as will " all " view is shown come, immediateness of whole industry tabulation appears in you before.

If need printed local district,be a successive unit division section, adopt " the setting prints area " the method will be more a few simpler: Pitch on needs printed local district, carry out " setting of → of the file → area that print prints area " command, it is normal to be pressed again next " print " operation with respect to OK.

Little hint: ① is in of the setting " the area that print " in, if hidden is listed (travel) , also won't be printed to come out.
If ② needs those who cancel a setting " the area that print " , should carry out only " → of the file → area that print cancels to print area " the command went.