Shulou(Shulou.com)06/01 Report--

Today, I would like to introduce to you the printing skills of Office office Excel forms. The content of the article is good. Now I would like to share it with you. Friends who feel in need can understand it. I hope it will be helpful to you. Let's read it along with the editor's ideas.

Office office software: Excel form printing have you ever encountered the following similar problems?

1. Is the grid line missing during print preview?

2, how to adjust the margin of the print area?

3, how to set up monochrome printing?

4what should I do if excel is not fully printed by paging?

How to solve these problems encountered in printing? Today, the editor will share with you some common tips for printing Excel forms!

01-display print gridlines

The Excel table has default gridlines when it is opened, but when we print preview, the gridlines are not displayed. How can we adjust them to show them?

Step: click [Page layout]-then check the small box on the left side of [print] in the "gridlines" in the "worksheet options" toolbar.

At this time, press [Ctrl+P] to print preview, and you can see the gridlines ~

02-set up full-page monochrome printing

When printing Excel forms with multiple background colors, we ask for a single color according to the demand, it is troublesome to adjust the background color one line at a time, and we don't want to destroy the color of the original form, how can we remove the background color only when printing?

In fact, it is very simple, setting [monochrome printing] can be easily solved. It can help you ignore all the colors in the table, whether it's font color or background color.

The procedure is the same:

Step 1: click "Page layout"

Step 2: click the icon in the lower right corner in the "Page setup" column.

Step 3: pop up the Page setup dialog box

Step 4: click the "worksheet" tab-check the check box in front of "monochrome print"

In this way, all the other colors when printing will disappear!

03-adjust the margins

In addition to the zoom function we taught last time to adjust the table to one page, you can also adjust the position of the data in the table by adjusting the margins of the table. The data can be printed on a piece of paper.

Step 1: press and hold [Ctrl+P] for print preview

Step 2: click * * Settings * *-> * * Page selection * *-> * * margin Settings * *-> * * Custom margins * *

Step 3: adjust the value of the upper and lower left and right margins according to your actual needs.

After that, everything can be printed on a piece of paper.

04-set print annotations

Sometimes we add annotations to the data in the Excel table, but we can't display them when they are printed. How can we make the annotations appear together when printing?

Step 1: click "Page layout"

Step 2: under the "Page setup" column, click the icon shown in the figure.

Step 3: pop-up [Page setup] window

Step 4: select the worksheet option-then select the worksheet end in the comments column.

This annotation is automatically generated at the end of the printed form. Is it very practical?

05-avoid print error valu

Sometimes due to the use of the wrong parameters or operation formulas, some of the data in the cell is wrong, and there are some wrong data in the cell.

But leaders are so anxious for data that they don't have time to correct it, and it doesn't matter, so how can we make sure that the wrong value is not displayed when printing, so that it can be written more flexibly after printing?

Step 1: click "Page layout"

Step 2: click the icon shown in the lower right corner of the "Page setup" column.

Step 3: pop up the following figure [Page setup] dialog box

Step 4: click the [worksheet] option-[print error cells as] and select [Blank].

In this way, the error value will be printed out and become blank.

These are all of the Office office Excel form printing skills, and more related to Office office Excel form printing skills can be searched for previous articles or browse the following articles to learn ha! I believe the editor will add more knowledge to you. I hope you can support it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.