Excel table making tutorial

Making tables with excel is a very common skill in our life, so do you know how to make tables with excel? Next, I will bring you the steps of making tables with excel tutorial _ Steps of making tables with excel.

Please click to enter the picture description (maximum 18 words).

catalogue

A tutorial on the steps of making tables with excel

Summary of the most commonly used formulas of 18 in Excel

Interpretation of Excel Function Formula by Daquan Method

A tutorial on the steps of making tables with excel

Right-click the desktop and choose Properties-New excel Sheet from the shortcut menu.

2 Name the newly created table "Statistics" and double-click to open the file.

3 Set the operating range of the table, that is, the paper size, which is set to A4 here, and the page layout-paper size-A4.

4 Select all the lines in the page, and right-click the "Line Height" command to set the line height.

5 Select the cell in the header position and right-click to select the cell format.

6 Select the Alignment tab in the Cell Format dialog box, select the merged cells, and then click OK.

7 After merging, enter the text "Statistical Summary" and center it.

8 input data, here only part of the input.

9 Select the cell where the table data is located, right-click and select the Format Cell command, select the Border tab in the dialog box, set the line thickness of the table frame, and then click OK.

After the basic setting of 10 form is completed, enter the data and save it, and the form is completed.