Table or table in Excel Nowadays, they are very commonly used because of the benefits they bring. During use, you can edit or view the contents of data areas easily and without worrying about confusion with other information. Additionally, they will also make your work much easier. SO How to create tables in Excel how ? Let’s go Blog Thien Minh Discover!
Why should you create tables in Excel?
Benefits of creating tables in Excel
Creating tables in Excel is increasingly used at work. The available formats will help you work easily and increase work efficiency. Additionally, creating tables in Excel also brings the following benefits:
Partition for each data type via header lines.
Users can filter data quickly and easily without having to use the Sort/Filter command.
Easily edit the points that need to be highlighted in the table for memorization.
How to create tables in Excel
Creating tables in Excel is quite simple and anyone can do it. You can create tables with Insert Table, Format as Table, or with the Border command.
Create a default table with Insert Table
Creating a default Excel table with Insert Table is one of the simplest ways that anyone can do easily. The steps are as follows:
Step 1: First go to Insert tab => Select Table
Click Insert then select Table
Step 2: Once the Create Table dialog box appears, scan the data area where you want to create a table => click OK to finish. If the data cells contain header cells, you must select My table has headers.
Scan the data area for which you want to create a table
Create a table in Excel using Format as Table
Formatting as Table will help you create Excel tables more professionally with many different colors to decorate the data table. You also won’t feel monotonous like the default way of creating tables that you often use every day.
Step 1: Go to the Home tab, in the Styles section => select Table format.
Find format as table in Home tab
Step 2: A list of Table Format table types will appear simultaneously for you to choose from. Choose a style you prefer.
A list of tables will appear
Step 3: As soon as you choose the table type, the Format as Table dialog box will appear immediately. Select the data area to create a table => click OK to finish. Note that if there are header cells, select My table also has headers.
Create a table using the Border command
This way of creating a table is considered the simplest and fastest. You just need to create borders for data cells to separate them for easy viewing, unlike Excel table.
Step 1: Select the data area for which you want to create a table.
Select data area
2nd step: Go to Home tab in Font section => Click on Border => Then select All Borders.
You now have a complete picture
How to create a table in Excel is extremely simple, even new users can do it. Tables in Excel will make your work easier and reduce many unnecessary steps. Therefore, apply one of the above methods to create a table to save time and increase work efficiency.
Additionally, you also need to learn how to edit tables in Excel and delete created tables to apply them if necessary. These will make your work easier and smoother.
Above, here are these How to create a simple table in Excel that you can follow. Hopefully this article will help you gain the necessary knowledge and save time on tasks.