Home >Topics >excel >How to set up automatic formatting in excel

How to set up automatic formatting in excel

藏色散人
藏色散人Original
2020-03-02 09:40:4114135browse

How to set up automatic formatting in excel

How to set automatic formatting in excel

First click [Start]>[ in the green area above Style】

Recommend "excel tutorial"

How to set up automatic formatting in excel

Click the triangle button under [Apply Table Format] to pop up a drop-down list. There are many options here, and users can choose by themselves. The editor here chooses an orange color to demonstrate to everyone.

How to set up automatic formatting in excel

The [Apply Table Format] dialog box pops up, check the box in front of [Table Includes Title], and click [Confirm] below to complete the settings.

How to set up automatic formatting in excel

You can see that the A1 and A2 areas of the table have turned orange. Drag the lower right corner of the orange area in the picture to make the area larger (the red deepens).

How to set up automatic formatting in excel

The enlarged result is as shown in the figure

How to set up automatic formatting in excel

At this time, there are many table colors in the [Table Format] area above, the user only needs You need to move the mouse to the corresponding color area, and the color of the table below will change. You can choose your favorite style according to this function of Excel, which is very convenient.

How to set up automatic formatting in excel

The above is the detailed content of How to set up automatic formatting in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn