Home>Article>Topics> How to unify excel table format

How to unify excel table format

coldplay.xixi
coldplay.xixi Original
2021-02-09 11:02:32 83883browse

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.

How to unify excel table format

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.

How to unify excel table format

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

How to unify excel table format

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.

How to unify excel table format

#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.

How to unify excel table format

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.

How to unify excel table format

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!

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