How to do simple Excel2013 in a table

This is mainly about the three techniques most commonly used in Excel tables: Merging cells, setting borders, inserting shapes.

1. In the first row, select the A~g column. Click "Center after Merge" on the toolbar. Enter the text "Employee Payroll."

2. Select 2, 32, two cells in column A, and click "Center after Merge" on the toolbar. Enter the word "item" by pressing the Alt+enter key on your keyboard to enter "name".

3. Click "Center left" on the toolbar. Adjust the width of the cell, double-click the cell to enter edit state, and use the keyboard spacebar to move the word "matters" to the right.

4. Click on the toolbar "insert", click "Shape", select a line, and then pull the line diagonally out of a line.

5. Select each cell that you want to merge, and use the merge feature to merge, as shown in the figure.

6. In the final step, select the cells, click "Borders" on the toolbar, add a border to the table, and complete the form.

If the table prints because there are too many rows and you need to have the same header, see resources: How to print the same title.

          Learn more about triple excel tutorials   columns