Revealing the Simple and Swift Method of Creating Tables in Excel

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

Guide on Creating Tables in Excel Quickly

Use Insert Table to create a default table

How to create a table in Excel using the Format as Table feature

How to draw a table in Excel using Borders

Guide on formatting tables in Excel

Easy Steps to Delete a Table in Excel

A Promise on Creating Tables in Excel

In Excel, there's a feature that assists users in organizing spreadsheets, making content within tables clear and easy to read. In today's article, Mytour will share the quickest and easiest way to create tables in Excel.

Efficiently sort names alphabetically in Excel
Explore easy methods for calculating age in Excel

Guide on Creating Tables in Excel Quickly

Use Insert Table to create a default table

Step 1:

On the main interface of Excel, click on the cell

Insert

> Choose the

Table

Step 2:A Create Table window appears; move the mouse to select the data range for table creation > Press

OK.

Note: If your data range includes headers, check the boxMy table has headers

If your data range includes headers, check the box

anymore.

Step 3:

At this point, the table will be created as shown below:

How to create a table in Excel using the Format as Table feature

If you find the previous method of creating a table in Excel a bit straightforward, try creating a table using the Format as Table feature below.

Step 1: Click on the Home tab

on the menu bar > Proceed to the

Format as Table

in the Styles section.

Step 2:

A list containing various table styles with different colors will appear >

Choose a table style by clicking on it

according to your preference.

Step 3:

After selecting a table style, a

Create Table

window appears; choose the data range to use for the table >

Click OK

to create the table.

Note:

If you need to select the data cell for the header as well, check the box

My table has headers.

Step 4:

The result after using the feature

Use Format as Table

to create the table as follows:

How to draw a table in Excel using Borders

Creating a table in Excel using Borders is the simplest method in today's guide. However, when using this method, it only helps create borders for cells, making the information separated and easier to read.

Step 1: Select the data position

you want to create a table.

Step 2:

In the

Home

tab, choose the

Border

> Proceed to the option

Select

All Borders.

Guide on formatting tables in Excel

Once you have completed creating the table, the next step we want to guide you through is formatting the table in Excel.

Step 1:

Perform

highlight the table position

and now the

Table Tools

> Click on

the Design tab.

Step 2:

In the Design section, under Table Style Options, you have features including:

Header row: The first row of the table for recording information.
Total Row: The last row of the table, used for total quantities.
Banded Row: Alternately color the cells.
First Column: Display special formatting for the first column of the table.
Last Column: Display special formatting for the last column of the table.
Banded Column: Alternately color between columns.

Out of these 6 table formatting options in Excel, some will be pre-selected. If you want to enable an option, simply

tick the box

; otherwise, leave it unchecked.

Step 3: In the Design tab

In the

Table Style Options

, make adjustments according to your preferences. If you want to add a total row, simply select

Total Row.

Easy Steps to Delete a Table in Excel

Note:

When you delete a table, the data inside it will be completely lost. Therefore, it's advisable to copy the data before proceeding with the deletion.

Step 1:

Drag the entire table to delete it.

Step 2:

Press the

Delete key.

To delete or choose the item

Clear

in the

Home tab

Select Clear All

To erase the entire table, follow these steps.

A Promise on Creating Tables in Excel

Thus, Mytour has guided you on the simplest way to create a table in Excel. We hope that these insights will be helpful for you in your usage. Wishing you successful implementations.

Explore more articles: Windows Tips, Basic Excel Tricks

Frequently Asked Questions

What are the simplest methods to create tables in Excel?

There are several simple methods to create tables in Excel, including using the Insert Table feature, Format as Table option, or manually drawing tables with borders. Each method has its unique steps to follow.

How do I use the Insert Table feature in Excel?

To use the Insert Table feature, click on the desired cell, go to Insert, select Table, choose the data range in the Create Table window, and click OK. If your data has headers, make sure to check the corresponding box.

Can I format tables after creating them in Excel?

Yes, you can format tables in Excel after creation. Select your table, go to Table Tools, click on the Design tab, and adjust options like Header row, Total Row, and Banded Rows to customize your table's appearance.

What should I know before deleting a table in Excel?

Before deleting a table in Excel, remember that all data within the table will be lost permanently. It's advisable to copy the data elsewhere if you need to keep it before deletion.

How can I create a table using the Format as Table feature?

To create a table using the Format as Table feature, go to the Home tab, select Format as Table, choose a style, and specify your data range in the Create Table window. Check the box for headers if necessary.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]