Current location - Recipe Complete Network - Complete recipe book - The whole process of making excel tables
The whole process of making excel tables
The first step is to open the Excel spreadsheet page that we need to operate, as shown in the figure.

Step 2: Insert blank cells in the first row and the first column respectively, as shown in the figure.

Step 3: After insertion, we merge the extra blank cells.

The fourth step is to frame what we need to do and make a table, as shown in the figure.

Step 5: Right-click the box and select the border. Add a border to our content, select the cell format, set the border size, and then click OK to make the table in our excel more obvious.

Step 6: Finally, you can add field names with different effects. If you don't want to add black, select this line and click Add Black. The effect of adding black to the field name will be cancelled. Finally, add a table name to the table and center it, and the final effect will come out.

note:

1. Select cell A 1, right-click to set the cell format, select the border tab in the pop-up dialog box, select the diagonal line, and click OK.

2. Enter the account name in cell A 1, then move the cursor to the account and click word wrap.