Creating tables in Excel is not only a simple way to organize data, but also a tool with many special features. In the article below, let’s learn 3 ways to create tables in Excel quickly and effectively!
Nội dung
I. Instructions for 3 ways to quickly create tables in Excel
Method 1: Use Insert Table to create a default table
This is the traditional, simple and fastest way to create a table in Excel.
Step 1: Highlight the content you want to create a table for, or create a new table without inserting content. Next, select the Insert tab on the toolbar, select Table . Or you can also use the shortcut Ctrl + T to create faster.
Step 2: Then, for users to customize the table creation area, the Create Table dialog box will appear. Excel will default to the data area you have selected. Users can also customize the data area according to their desired table creation.
- Check the My table has headers box , in case the data range already includes table headers.
- Default header names such as Column 1, Column 2,… will appear at the top of the table columns. People can freely change the header.
Click OK to complete how to create a table in Excel with the Insert Table feature .
Below will be the final result.
Method 2: Use Format as Table to create a custom table
Besides creating a table in Excel with Insert Table, people can use Format as Table to create a table.
Step 1: Highlight the data area where you want to create a table, select the Home tab, then click on Format as Table .
Step 2: A series of different tables with various colors appear. Select a table you want to create and click on it.
Step 3: The Create Table dialog box appears. If the table has additional headers, follow the same steps as above in the section on how to create a table in Excel with Insert Table . Click OK .
The Excel table style and colors that the user has selected will be instantly created and appear on the screen .
Method 3: Use Border to create a table
Actually, this is a way to create borders for content cells, but this is also a simple way to create tables on Excel that everyone should know. If people need quickness, convenience and do not require color table style, then this is also a feature to use.
Step 1: First, highlight the data area where you want to create a table and then select the Border icon.
Step 2: Click on the All Borders feature to create a table for the selected data.
II. How to customize tables in Excel
This customization or editing will help the content stand out more when you know how to create a table in Excel. Besides, this will not delete or change any of the original content.
Step 1: After successfully creating a table with the ways to create a table in Excel listed above, select any cell or column, the Table Tools section will appear. Select Design.
At this time:
- Header Row: The first row of the table is used to contain header information.
- Total Row: The last row, used to sum the numbers.
- Banded Row: Performs alternating color and cell grouping.
- First Column: The first column of the table will be displayed with special formatting.
- Last Column: The last column of the table will be displayed with special formatting.
- Banded Column: The columns will be colored alternately.
Some options are designed by default. If you do not want to use them, uncheck or check the items you need to use.
Step 2: In the Design tab of the Table Tools section, you can freely format as desired. Here, I will alternate the columns with Banded Column.
III. How to delete a created table completely in Excel
Delete all
With this deletion method, all data in the table will be lost. Therefore, copy the data to another empty area if necessary!
Step 1: Select the entire table.
Step 2: Select the Home tab, select Clear > Clear All to delete the table.
Clear table formatting
This will remove the table formatting from all cells. But the formatting that has been done like shading, borders, content will remain intact.
Step 1: Select any cell in the table, then the Table Design tab will appear.
Step 2: Select the Convert to Range feature .
Above is an article instructing how to create tables in Excel simply and quickly. Hope the article is useful to you!
See at: Create and format tables
See more: Detailed instructions on how to use Filter data in Excel