How to create a table in Excel 2022

Insert a Table | Sort a Table | Filter a Table | Total Row

Master Excel tables and analyze your data quickly and easily. Learn how to insert, sort and filter a table, and how to display a total row at the end of a table.

Insert a Table

To insert a table, execute the following steps.

1. Click any single cell inside the data set.

2. On the Insert tab, in the Tables group, click Table.

The Create Table dialog box appears.

3. Excel automatically selects the data for you. Check 'My table has headers' and click on OK.

Result. Excel creates a nicely formatted table for you. This may still seem like a normal data range to you but many powerful features are now just a click of a button away.

Sort a Table

To sort by Last Name first and Sales second, execute the following steps.

1. Click the arrow next to Sales and click Sort Smallest to Largest.

2. Click the arrow next to Last Name and click Sort A to Z.

Result.

To filter a table, execute the following steps.

1. Click the arrow next to Country and only check USA.

Result.

Total Row

To display a total row at the end of the table, execute the following steps.

1. First, select a cell inside the table. Next, on the Table Design tab, in the Table Style Options group, check Total Row.

Result.

2. Click any cell in the last row to calculate the Total (Average, Count, Max, Min, Sum etc.) of a column. For example, calculate the sum of the Sales column.

Note: in the formula bar see how Excel uses the SUBTOTAL function to calculate the sum. 109 is the argument for Sum if you use the SUBTOTAL function. Excel uses this function (and not the standard SUM function) to correctly calculate table totals of filtered tables.

You might wonder— ‘How to create a table in excel?’ Many like you are knowledgeable about excel but don’t know how to create it. Yes, we all know that MS Excel is the thing that drives people’s essential abilities. Also, it aids in the enhancement of efficiency and production. It helps in the proper record-keeping of data.

Moreover, the Excel pivot table has grown ingrained in most businesses throughout the world. Business organizations utilize MS Excel for several functions. And, Some businesses use Excel to create notes, track sales trends, and keep track of other company data.

Don’t worry. This blog will be will your ultimate guide on pivot tables in Excel default style. So, follow the content list here and go through the whole blog. Also, click here to know more about Excel Assignment Help.

• Excel Table definition.
• What is there in an excel table?
• Why should you use an Excel table?
• How should you create a table in Excel?
• Which way to follow to customize the Excel table data?
• What shortcuts to use for the Excel tables?

So, here is the answer.

Excel Table definition – Pivot Table

In Excel, a table is a helpful tool for grouping data. You can consider a table a collection of rows and columns in a spreadsheet. On the same page, you can have many tables. Here, a create table dialog box assists users in calculating, organizing, and visualizing quantitative data and providing information to managers and senior management.

Also, pivot Table tools make it easier to deal with data in Microsoft Excel, and there’s no reason you shouldn’t utilize them. And, you will find several table style options group on the Excel page. Don’t worry, you will learn about it as well. Before focusing on the tables group, let’s know the part of the table in excel.

Excel tables get made up of blank rows and blank column, and they all have a few things in common.  If you are willing to understand more about Educational VR, follow here. Moreover, The table is a rectangular range of cells with unique column headings. On the Design tab and in the insert tab, you’ll see the table name box. So, the three main components of any table data range are— header row, the data in the table, and the total row.

Table Headers row——

It shows the names of the columns. Although the header row is not required, most tables will include one.

The data in a table——

It contains all of the rows in the table range. Only the data get picked when you utilize the name box to choose a table.

The total row—-

It is the table’s last row, and it gets used to store summary calculations. It gets often termed as calculated columns.

Besides this, you will find the home tab, table design tab, cell range, different table styles, etc. Let’s say that for better understanding, table excels should get followed with one blank row and one blank column between a table and other data. Moreover, you can remove blank rows with just a click. Also, You will know more about it in the section on creating a table in excel.

Why should you use table in excel?

Because Excel identifies each column as an independent field, there are several advantages to utilizing Excel with different table styles. So, the following are some of the factors why you should use Tables in your Excel workbooks:

You want a set of data that is consistent and uniform.

Over time, your information will get updated (additional rows, columns over time). Yes, you will find several options in the drop-down list.

You’re looking for a quick and easy solution to format your work professionally.

You can automatically get totals by default table style.

You can make dynamic charts.

Forms can get added to make entering new data easier.

Following knowing why you should also use an excel table, now comes the crucial part— how to create it. So let’s go and find out in the below passage. Sometimes, experts’ assignment help is crucial and in such cases, follow here to know more Assignments4u.com.

You will be happy to learn that several styles are there to cite a poem in your content. You can use any citation format to make your academic paper authentic.

At first, let’s learn the styles of the type and then will know more about it with examples.

MLA (Modern Language Association).

APA (American Psychological Association).

Harvard.

So, after you have learned about the types of citing a poem, let’s discover the types in detail. Here comes first the MLA handbook format.

Let’s say that creating a table in excel is not that hard if you know the process. What is it? Don’t worry; you will know it here now.

Within the data set, click any single cell. Excel will assume your data range based on your selection when creating the table.

Now, select the ‘Insert Tab’ in the Tables group and click ‘Table.’

A create dialogue box will appear in this step. You have to tick the box— ‘My table has headers.’
Then click OK.

Finally, the table will form. You now have an Excel table, and depending on the default style of your tables, your data should appear like this.Meanwhile, if you want to know how to cheat on a proctored exam, read the article here.

Now, your excel table is showing in the default format. So, if you are willing to rename it, you have to go through the following step.

Step to follow to rename the Table in Excel—-

• Go to any cell in the table to activate the Table Tools.
• On the Design tab, go to the Properties group.
• In the Table name box, type the new table name.
• Finally, press the Enter key.

Now, see your table excel has got renamed.

Steps to follow to add data with total row to extend table in Excel—-

• Select the cell in your table where you wish to add a row.
• Go to the Layout tab (this is the tab next to the Table Design tab).
• Copy the data that you want to add by pressing Ctrl+C).
• Now, press Ctrl+V to paste the copied data.

Way to convert an excel table to data range—-

You could want the table look without the table functionality once you create a table in excel. You may convert a table to a standard range of data on the worksheet to cease working with the data cell in a table without losing any table-style styling you’ve done. So, follow the step here—

1. Select a place in the table by clicking anywhere on it.
2. On the Ribbon, go to Table Tools > Design.
3. Click Convert to Range in the Tools category.

-OR-

1. Give a right click of your mouse in the table.
2. A shortcut menu will appear.
3. Click the table and then convert to the range.

After knowing the mentioned details, you might want to customize the table. So, how to do it? Here is the guidance.

On the Home tab, in the Styles group, click format as Table command.

A drop-down menu or single column will appear with a list of pre-defined table designs.

Choose a specific style. To use color and design to your table, click one of the colored boxes in the “Table Styles” area of the Design toolbar.

The range of cells you’ve chosen for your table will be confirmed in a dialogue box.

Make sure the option ‘My table contains headers’ is checked.

To accept these changes, click OK.

Let’s be clear first if you want to filter your table data, both the “Headers box” and the “Filter” boxes in the “Table Style Options” section of the Design tab must be ticked. Now, follow the step—-

• Open the filter menu and select the column whose data you wish to filter by clicking— drop-down sign to the right of the header.
• A drop-down menu will pop up on the screen.
• Choose a filter from one of the following options in the drop-down menu.
• In the final step, click OK.

Once you complete the step, now you can see your table data get filtered with the style you chose.

What shortcuts to use for the Excel tables?

If you frequently use Excel Tables, you should know a few shortcuts to simplify your life. These shortcuts work on both the mouse and the keyboard and are compatible with Windows. In such cases, here are some of the shortcuts you may use:—-

For the selection of columns— 

 Ctrl + Space is the keyboard shortcut for choosing a column and rows in Excel tables.

To select a row—

Shift + Space is the keyboard shortcut for selecting a row.

Select the entire table—  

You can use Ctrl + A to select all of the data in the table.

To move Columns—- 

Select the header cell in the column you wish to move it. Then move your cursor over the cell’s edge until it turns into crosshairs. Then, while maintaining the cursor in the header row, drag it to where you want it to go. As you drag the mouse between columns, a vertical green bar shows where the column will finish up when you release it.

Select any cell in the table. Keep in mind that the added row will appear above that cell. After that, press Ctrl + +. You may need to press Ctrl + Shift + + if using a laptop.

The process is similar to the insert row method. First, pick it in the row you wish to delete to remove a cell, then press Ctrl + -.

Use the keyboard shortcut Alt + J T A to rename a table. Following this, the Table Name box in the ribbon will appear, allowing you to make changes to the name.

Conclusion

As said, the data table in Excel has powerful features that make our work simpler. So, I hope this blog will guide anyone willing to create an excel table by themselves. Yes, From existing formatting or default names to customizing the table with new styles and names, adding more data, everything will become handy with practice. Thus, it is not rocket science. You will learn its helpful features such as—its different clear formatting, how to remove rows in the last column or first row, or using the subtotal function in a total cell. Also, A little guidance which you were required hopefully will find in this article. So try it now.