Basic methods of making excel tables

Do you know the basic method of making excel tables? Many computers are blank in this respect. Actually, excel is not difficult to learn. The following is the basic method of making excel tables, which I have carefully prepared. I hope it will help you.

The basic method of making excel tables 1 the first step

Open the excel presentation, enter the page, select some cells, and then right-click the selected cells to format the cells.

Step 2: Click on the border, click on the outer border and the inner border respectively, and confirm.

Third step

At this time, the table is ready. If you need to enter a title, you can select the cell table in the first row. On the menu of the Start tab, click Center after Merge and enter a title and the following.

The above is the content of excel table making, I hope it will help you.

The basic method of excel table making 2 The basic method of Excel table making

Excel spreadsheet is an office software that we often need to use in our daily work. Today, I will share with you the basic methods of making Excel tables. This tutorial is very simple and easy to use for users who only need to use Excel tables. This paper mainly talks about the three most commonly used skills of Excel tables: merging cells, setting borders and inserting shapes.

1. In the first row, select columns A to G ... Click Center after Merge on the toolbar. Enter the text "Employee Payroll".

2. Select two cells in column A of column 2 and column 3, and then click Merge Center on the toolbar. Enter the word "event", press ALT+Enter on the keyboard, and then enter a name.

3. Click the left center on the toolbar. Adjust the width of the cell, then double-click the cell to enter the editing state, and use the space bar of the keyboard to move the word "matter" to the right.

4. Click Insert in the toolbar, click the shape, select a line, and then pull a line from the diagonal of the line.

5. Select the cells to be merged and use the merge function to merge, as shown.

6. Finally, select these cells, click the border on the toolbar and add a border to the table to complete the table.

If you need tables with the same title due to too many rows when printing, please refer to the resources:

How to print the same title?

Matters needing attention in basic methods of making Excel tables:

Due to different versions of office, the location on the toolbar above may be different.