You are currently viewing How to create a table in Excel

How to create a table in Excel

Microsoft tablets are created to group and analyze data for easy understanding visually. They are beneficial to every user or Excel as they give structure to substantial data sets from lists. Some users assume that the rows and columns in Excel already represent data tables. It is simply not true as the data is only in a list and an actual table can be created easily using Excel command tabs or keyboard shortcuts. Furthermore, regular sheets lack all the benefits that come with tables. The best thing about Excel tables is that you can format, design, and use custom filters to make them look sophisticated in reports.

Here let's get to learn how you can create, format, design, and apply custom filters in an Excel table.

Creating a table in Excel using the keyboard

1. From the start button of your PC, go to Microsoft Office suite and launch the Microsoft Excel program.

2. Open the worksheet you need to create a table. If you are working with an empty or blank worksheet, you will first need to create a data list.

3. Select the location. Click on the cells you want your table to be. Do this by clicking, holding, and dragging the cursor.

4. On your keyboard, press Ctrl key + T. a Create Table dialogue box will display. Select where the data for your table is.

5. Click OK, and your table will form in the cells you selected.

Using Insert tab to create a table

1. Open the Excel spreadsheet.

2. Select your table's data. To do this, click the cell in the top left corner of the data list. On your keyboard, hold the shift key and click the list's bottom right cell.

3. From the main menu's ribbon, click the Insert tab. It will open a toolbar with different groups.

4. Click Table. It will bring up a pop-up window.

5. Check the box 'My table has headers' if your table has them.

6. Click OK. Doing so will create your table.

How to Change the Table's Design

1. Click on the Design tab. It will open a toolbar for the design of your table.

2. Select a design style. Click on the drop-down arrow under the 'Table Styles' section. Scroll through the different options given and select a design you like.

3. Under the design tab of the table, set your table styles. Go to 'Table Styles Options' to do this. Check all the options given here. These include a Header row, Total row, Banded rows, Banded columns, Filter button, First and Last columns.

4. Click the Home tab. Changes made on your table will remain.

Remember,

When you want to add or insert or even delete columns and rows from your table, you can do so using the Home tab. Then go to Cells group, select Insert or Delete buttons depending on what you want to do.

Conclusion

Creating Excel tables and playing around with different table styles is fascinating. Apart from this, you will be able to come up with a professional-looking table from any given data set. From the given methods above, I believe this would not be hard to achieve.