Excel printing skills summary of twelve excel printing skills

Mention printing , You're all familiar , In daily work or life, you will encounter the documents to be printed , There is no technical activity for printing , You'll know how to operate it once you see it . about Excel Do you know the worksheet printing operation ？ Xiaobian summarizes twelve kinds here Excel Printing skills , Partners who are not very clear about the operation , Follow Xiaobian to have a look ！
Twelve Species Excel Summary of printing skills ：
The first one is ： Print the same title on each page
1、 When printing , The first page has a title , There is no title on the second page and beyond , Make reading inconvenient , How to make every page print the same title ？
2、【 The page layout 】→【 Print title 】.

3、【 Worksheet 】→【 Top title line 】→【 determine 】.

4、 Here's a reminder ： Cannot be in the print preview window 【 Page setup 】 Set in .
5、 As shown in the figure below, it is gray , Cannot set .

The second kind ： Print the selected area
1、 Select the area to print 】→【 Print 】→【 Print active sheet 】 Choose 【 Print the selected area 】.

The third kind of ： Custom zoom print
1、【 Print 】→【 No scaling 】 Choose 【 Adjust the worksheet to one page 】.

A fourth ： Hide page breaks
1、 There will be a dotted line when printing （ Here's the picture ） Called page breaks , It will not be printed when it is actually printed , If you don't want it to appear in the table , How to solve it ？

2、【 file 】→【 Options 】→【 senior 】.
3、 Uncheck the 【 Show page breaks 】 Check the box →【 determine 】.

The fifth ： Print gridlines
1、 Here's the picture ： It looks like it has a border .

2、 But in actual printing, there is no border .

3、 Do not add borders , There are border lines when printing , How do I do that ？
4、【 The page layout 】→【 Gridlines 】→ Check 【 Print 】 Check box .

6 kinds of ： Center print
1、 When printing , The left and right sides are wide on one side and narrow on the other , Not beautiful .

2、 Is there any way to make it print in the middle ？
3、【 Print 】→【 Page setup 】.

4、【 Page margins 】→ center on page → Check 【 level 】 Check box → Check 【 vertical 】 Check box .

Seventh kinds ： Monochrome printing
1、 for instance , Some important information or something , You like filling colors .

2、 Different color patches will appear when printed .
3、 Print preview .

4、【 The page layout 】→【 Dialog launcher 】.

5、【 Worksheet 】→ Check 【 Monochrome printing 】 Check box →【 determine 】.

Eighth ： Error cells are printed blank
1、 When excel When an error value appears in the table , In order not to affect the beauty , How to print without printing the error value ？

2、【 The page layout 】→【 Dialog launcher 】→【 Worksheet 】→【 The wrong cell is printed as 】： blank .
3、 After setting up , Print preview .
4、 The one marked with red circle is the wrong value before setting , It is blank after setting .

The ninth ： Print comments
1、Excel Annotated in the table , How to print annotations when printing ？

2、 When printing, the comments are at the end of the worksheet .
3、【 The page layout 】→【 Dialog launcher 】→【 Worksheet 】→ notes →【 At the end of the worksheet 】.
4、 Print preview .
5、 When printing, annotations appear as if they were in a worksheet .
6、【 The page layout 】→【 Dialog launcher 】→【 Worksheet 】→ notes →【 As shown in the worksheet 】.
7、 Print preview .

The tenth ： Print header / The footer
1、【 The page layout 】→【 Dialog launcher 】→【 header / The footer 】.

The eleventh ： Print logo
1、【 The page layout 】→【 Dialog launcher 】→【 header / The footer 】→【 Custom header 】.

2、【 Insert a picture 】.

3、 After choosing the picture .

4、 determine .

5、 Print preview .

The twelfth ： Page printing
1、 Sort by customer .

2、【 data 】→【 Subtotal 】→【 Category field ： Customer 】→ Check 【 Each group of data paging 】 Check box →【 determine 】.

3、 Set the print top header line .
4、 Operation is completed .