How to unify excel table format

Uniform method of excel table format: first hold down Ctrl and select these two labels; then set the row height in the first worksheet; finally, the same goes for column width and text, and select all Just set it up.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Uniform method of excel table format:

1. Open the excel table and open a table. You can see that this table has two worksheets.

#2. You can see that the format of each table is different, including each table size, line spacing, column width, text, etc.

3. Hold down Ctrl and select these two labels, or click the first label, right-click and select Select all worksheets. You can select all tables. You will see that all worksheets are white.

#4. Then set the row height in the first worksheet, change it to 20. points, and click OK. You can see that the row heights of both tables are unified to 20 points.

5. The same goes for the column width and text. Select all, set the font Song Dynasty in the first table, center it, the font size is 12 bold, and the column width for 20 lbs.

Related learning recommendations: excel tutorial

The above is the detailed content of How to unify excel table format. For more information, please follow other related articles on the PHP Chinese website!