Table operations in Excel

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

When working with tables you should pay attention to the following:

1. Edit the widths of rows and columns.

There are many ways to edit the widths of rows and columns.

Method 1: With the column moving into the vertical bar of the column -> when the mouse pointer appears 4-way arrow -> drag and drop to adjust the width of the column:

Table operations in Excel Picture 1

- Similarly, if you want to edit the width of the row -> click on the horizontal bar of the row to drag the mouse to adjust the width of the row:

Table operations in Excel Picture 2

Method 2: Select the columns to resize -> Home -> Cells -> Format -> Column width .

Table operations in Excel Picture 3

- The Column width dialog box appears -> enter the column size to change -> OK:

Table operations in Excel Picture 4

- After selecting OK , the column widths have changed:

Table operations in Excel Picture 5

2. Insert more rows, columns, cells.

- Insert more columns: Select the position of the column to be inserted (the column is inserted to the left of the selected column) -> Home -> Cells -> Insert -> Insert Sheet Column:

Table operations in Excel Picture 6

- Similar to inserting rows: Select the position to insert rows -> Home -> Cells -> Insert -> Insert Sheet Row.

Table operations in Excel Picture 7

- The insertion of a cell into a worksheet you manipulate similarly by selecting Insert Cells.

3. Delete rows, columns or cells.

- Delete rows: Select the rows to delete -> Home -> Cells -> Delete -> Delete Sheet Rows:

Table operations in Excel Picture 8

- After selecting Delete Sheet Row blank rows have been deleted from the Table.

Table operations in Excel Picture 9

- To delete a column you do the same thing by clicking Delete Sheet Columns.

4. How to hide / show column rows in Excel.

- Hide 1 column:

+ Right click on the column to be hidden -> Hide:

Table operations in Excel Picture 10

+ After selecting Hide columns have been hidden by shrinking the maximum size:

Table operations in Excel Picture 11

+ If you want to show the column again, move the mouse to the vertical bar of the hidden column -> right-click and choose Unhide:

Table operations in Excel Picture 12

- With the hidden and displayed you manipulate the same.

- In addition to the above operations, to quickly operate on the table you use the following features: Right-click on the column or row to be manipulated -> the frequently used features in the table such as Insert, Delete are displayed, you just need to click. Choose those features:

Table operations in Excel Picture 13

The above is a detailed guide of table operations in Excel 2013.

Good luck!