Change the small details to make the Excel form instantly more beautiful

It's not difficult for Excel to edit a form. But we also hope that the edited form is beautiful? No, now let's get the beauty of our form and make our form beautiful.

　　1. Change the default form line color

By default, the edge of a cell is always that gray line of detail. Long time, there will be "aesthetic fatigue" phenomenon. We can change the color of this border line again.

Click the menu command "tools → options" to open the "Options" dialog box and click the "View" tab. In the bottom gridline color drop-down list, we can reassign the cell border line to a color, as shown in Figure 1. When you're sure, the grid line is no longer that gray.

Figure 1 to reassign a color to a cell border line

Of course, we can select cells directly, and specify border lines and colors for them. When you select a range of cells, click the menu command format → cell to open the Format Cells dialog box. We can click on the "Borders" tab, and then specify the border line color, line style, for the cell's four borders, specify the border lines, as shown in Figure 2. Click the Pattern tab to specify the fill color and pattern for the cell.

Figure 2 Specifies a border line for the four borders of a cell

　　2. Use automatic format

If you do not want to set the table format, then we can select the table area, click the menu command "format → AutoFormat", Open the AutoFormat dialog box. Select a format in the list, as shown in Figure 3. Get the same type of table immediately after the confirmation. We can also click on the "Options" button in the dialog box and choose among the multiple options in the "format to be applied" below the dialog box to make the resulting format more appropriate for your own requirements.

Figure 3 Selecting a format in the list

3.0 value Display

There may be zero values for some of the cells in the edited table. These all affect the appearance of the worksheet. Modifying cells individually can be cumbersome. We can simply make all 0 values not appear.

Click the menu command "tools → options", click the "View" tab in the Open Options dialog box, and then remove the option "0 values" in the window options. As shown in Figure 4.

Figure 4 Removing the option of "0 value" options in Window options

　　4. Turn off error value display

If you use a formula, you may get an error value in the worksheet, such as a cell in which we use as a divisor, which contains empty cells. This error value, if modified, is also troublesome. So the easy way to do that is to let it show.

Select the range of cells that contains the error values, such as b1:g100. Then click the menu command "format → conditional formatting" to open the Conditional Formatting dialog box. Click the "Cell Value" Drop-down button on the left, select "Formula" in the list, and then enter "=iserror (B1)" In the input box to the right, as shown in Figure 5. Click the Format button below and click the Font tab in the Open Cell Format dialog box to set the font color to the worksheet background color (generally white). The error values are not visible when you are sure.

Figure 5 The "format" button below the click

However, Excel also automatically adds an error smart flag to these error values, which is the small green triangular flag in the upper-left corner of the cell. Remove it by clicking the menu command "tools → error checking" and clicking the "Options" button in the Open Error Checking dialog box to open the Options dialog box. Uncheck the "Allow background check error" complex option, as shown in Figure 6. When you are sure to close the Error checking dialog box, the green triangle disappears.

Figure 6 Uncheck the "Allow background check error" duplicate option

Of course, it is better to avoid these erroneous values in advance than to try to hide them after the error value is generated. Just use the IF function with the ISERROR function to achieve the goal. Assuming the original formula is "=d1/e1", then if you enter the formula "=if" (ISERROR (D1/e1), "", D1/e1) ", then when the result of the formula is an error value, the cell is blank, and the result of the formula is displayed directly when the results are not error values.

　　5. Suitable column width, row height

The appropriate row heights and column widths are also an important factor in the appearance of the table. Click the Select All button in the upper-left corner of the worksheet. Select all cells, and then move the mouse over any two columns of the border, and when the mouse pointer changes to a vertical bar with two directional arrows, double-click the mouse to get the appropriate column width (exactly the contents of the cell will be fully displayed). Similarly, we can also get the appropriate row heights by moving the mouse over the line and the line's border.

When you do this, you can adjust the rows or columns that have special requirements, and use the Format Cells dialog box to get the best results.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join