Array or Table in Excel They are now widely used because of the benefits they bring. When using, you can edit or view the contents of data areas easily and don’t worry about confusing with other information. Moreover, they will also make your job much easier. SO How to Create a Table in Excel how ? Lets go Blog Thiên Minh discover!
Why create a table in Excel?
Advantages of creating tables in Excel
The creation of tables in Excel is increasingly used in work. Available formats will help you work easily and increase your work efficiency. Moreover, when creating a table in Excel, there are some advantages as follows:
Partition for each data type via header rows.
Users can filter data quickly and easily without having to use the Sort/Filter command.
Easily edit points that need to be highlighted inside the chart for memorization.
How to Create a Table in Excel
Creating a table 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 easiest ways anyone can do it easily. The steps are as follows:
Step 1: First go to Insert tab => Select Table
Click on Insert then select Table
Step 2: After the Create Table dialog box appears, scan the data area where you want to create a table => click OK to finish. In case the data cells contain header cells, you should choose to add My table has headers.
Scan the data area you want to create a table
Create a table in Excel with Format as Table
Format as Table will help you create a more professional Excel table with different colors to decorate the data table. You also won’t feel as monotonous as the default way of creating tables that you still use every day.
Step 1: Go to Home tab, Styles section => select Format as Table.
Find the table format in the Home tab
Step 2: The table type list of Format as Table will simultaneously appear for you to choose. Choose a style that you like the most.
A list of tables will appear
Step 3: As soon as you choose the table type, the Format as Table dialog box appears immediately. You select the data area to create the table => click OK to finish. Note, if there are header cells, select My table has headers.
Create a table using the Border command.
How to create this table is considered the easiest and fastest. You just need to create borders for data cells to separate them for easy viewing, not like Excel table.
Step 1: Select the data range in which you want to create the table.
Select data area
2nd step: You go to the Home tab in the Font section => Click on Border => Then select All Borders.
You already have a complete table
How to create a table in Excel is extremely easy, even new users can do it. Tables in Excel will make your work easier and reduce many unnecessary steps. Therefore, apply any of the above ways to create a table to save time and increase work efficiency.
Besides, you also need to know about editing a table in Excel and deleting the created table to apply it if necessary. These will make your work more convenient and smooth.
here are the How to create a simple table in Excel? which you can follow. Hope this article will help you gain more necessary knowledge and minimize the time spent on tasks.