Manipulating tables editing in Excel

The following article provides detailed instructions for you to edit tables in Excel.

Manipulating tables editing in Excel Picture 1

1. Insert rows and columns in tables:

- For example, you want to insert 1 column after salary column 1 day:

Step 1: Select the Number of days column -> Go to the Home tab -> Cells -> Insert -> Insert Sheet Column:

Manipulating tables editing in Excel Picture 2

Step 2: After selecting the new column is inserted in the desired position. Notice the column is inserted to the left of the selection column:

Manipulating tables editing in Excel Picture 3

- Example inserting 1 row after the 2nd row in ordinal number:

Step 1: Select the 3rd row of the employee Manh Tuan -> Go to the Home tab -> Cells -> Insert -> Insert Sheet Rows:

Manipulating tables editing in Excel Picture 4

Step 2: After selecting the new row is inserted. Notice that the new row is inserted above the selected row:

Manipulating tables editing in Excel Picture 5

2. Merge cells in Excel.

Step 1: Select the cells to merge

Manipulating tables editing in Excel Picture 6

Step 2: Go to the Home tab -> Alignment -> Merge & Center ( or you can choose other types of Merge in the dialog box ):

Manipulating tables editing in Excel Picture 7

Step 3: After selecting the combined cells, the results are:

Manipulating tables editing in Excel Picture 8

- In case you want to split multiple cells back to the old state, do as follows: Go to Home tab -> Alignment -> click Merge & Center again:

Manipulating tables editing in Excel Picture 9

3. Align the text position in the data box:

For example, the column header text lines at the bottom and the left, want to align so that the text is in the middle position compared to the cell in the table.

Manipulating tables editing in Excel Picture 10

- Method 1:

Step 1: Select the headline to format -> right-click and select Format Cells:

Manipulating tables editing in Excel Picture 11

Step 2: The Format Cells dialog box appears, select the Alignment tab in the section:

+ Horizontal: Select Center.

+ Vertical: Select Center.

Finally, click OK to complete:

Manipulating tables editing in Excel Picture 12

Step 3: After clicking OK, the text is edited to fit the size of the cell:

Manipulating tables editing in Excel Picture 13

- Option 2: Select the subject line to align -> Home -> Alignment -> click on the Middle Align icon :

Manipulating tables editing in Excel Picture 14

The above is a detailed guide for manipulating table editing in Excel 2013.

Good luck!