Including a table in an Excel document is a quick and simple method to organize and categorize data.
The procedures for inserting a table in Microsoft Excel are listed below.
Including a table
- Open Excel and navigate to the cell where you want the table to be inserted.
- Navigate to the Insert tab.
- Select the Table option.
After inserting the table, you may change its size by dragging the mouse to the bottom right corner of the table until you see a double-headed arrow.
When this arrow appears, click and drag the table in the direction you want it to expand.
You may add extra columns by dragging the pointer to the right, or rows by dragging the mouse down.
Changing the appearance of the table
After you’ve added the table, take your mouse to a cell in the table and choose the Design tab.
You may change the Header Row, Total Row, and how the rows look under the Design tab.
You may also change the general appearance of the table by clicking one of the table’s styles.
Making use of your table
You can enter data into the table after you have it looking the way you want it to.
After you’ve entered data into the table, you can utilize the sorting features by clicking the down arrow in the column you wish to sort.
For example, you may sort a price column from smallest to largest to determine which item in a list is the cheapest.
Moving the table
After you’ve added a table, you may move it around by clicking any cell to make the table active and then hovering over an edge of the table.
When you see four arrows pointing in different directions, click and hold the left mouse button while dragging the table to the right.