Excel how to make tables How to make tables in Excel. Computer has become an indispensable helper in our daily work, study and life. Many people will use Excel to make tables, and Excel to make tables is also one of the common operations in daily work. There are many ways and forms to make tables, so how does excel make tables? Below, Xiaobian will introduce the operation process of excel to make tables.

Production method

0 1

Create a new excel table and open it.

02

Click the "Table" option under the Insert menu.

03

Then use the mouse to select the number of rows and columns in the table. Here I choose a table with 10 rows and 5 columns, and then click OK.

04

At this time, this table was drawn.

05

If you don't like the default table style, you can choose your favorite table style in the upper right corner.

06

Double-click a cell in the table to insert text.

How excel makes tables

Turn on the computer and right-click the mouse to create a new excel file on the desktop.

Make a form

Open the excel file, use the mouse to select the number of columns and rows required by the table, right-click the mouse and click "Format Cells".

excel

Click Borders, select Outer Borders and Inner Borders in Presets, and click OK.

Make a form

Select the title bar of the table with the mouse, right-click the mouse, click Align, check Merge Cell, and click OK.

spreadsheet

Select all the rows and columns in the table with the mouse, right-click the mouse, click Align, and set the horizontal alignment and vertical alignment to "center" so that the text in each cell is in the middle position.

Make a form

Enter all the contents of the form to be made, and click Save in the upper left corner.

Make a form