If you use Microsoft Excel, you often collect data in tabular form so that the data looks neat and easy to read. By creating tables, data processing becomes easier and the results are more organized.
Therefore, active users need to master how to create Excel tables. There are several ways that can be used. This method will also make it easier for beginners who will learn to make tables in Microsoft Excel.
No need to worry, these methods are quite easy. You can definitely get the hang of it quickly.
Well, here how to make a table in excel along with tips that can be applied. Check out the explanation, come on!
1. How to make a table in Excel with the ‘Format as Table’ menu
When using Microsoft Excel, you may have to collect numerical data. After collecting data, you also need to group it.
So that data is not just a collection of numbers, you also have to analyze and visualize it.
Data sets will be easy to process if you use tables. For that, you need to understand the steps to create a table for data storage.
Reported Support Microsofthere’s how to create a table in Excel:
- First select the cells in the worksheet that will be made a table
- Then, go to ‘Home’ or ‘Home’
- After that, click ‘Format as Table’
- You just have to choose the model or table style that suits your needs
- Verify again that the table ranges are correct. Usually, this section is found in the ‘Create Table’ dialog box
- Next, mark or check the ‘My table has headers’ section
- Finally, select ‘OK’
- You can make a table with certain colors so it’s not boring.
Also Read: 41 Practical Microsoft Excel Shortcuts on Mac, Mandatory Skills!
2. How to make a table in Excel with the ‘Insert Table’ menu
Excel table illustration (freepik.com/rawpixel.com)Apart from using the menu Format as Table, there is a way to make a table in Excel that is no less easy. Somewhat different from the previous method, you need to create a basic table with a menu Insert Table.
How to do it? Here are the steps you need to follow:
Continue reading the article below
Editor’s picks
- First select the cells you want to make a table
- After that, select ‘Insert Tab’, then click ‘Table’
- Another way, you can use shortcut Microsoft Excel, namely Ctrl + L or Ctrl + T
- After ‘Create Table’ appears, check the table range is correct
- Select ‘My Table has Header’ if you want the table to have a header column
- If not checked, then the top of the table will form columns
- These columns can be edited according to your needs
- Finally, select ‘OK’
- Your table will appear and can be used.
The first and second methods are almost similar, but not the same. You just need to choose the method that best suits your needs.
In order for the table to be more effective in displaying data, you also need to make adjustments or changes. For example, naming or changing the color of a table. So, tables can be grouped according to the contents of the data.
3. How to delete a table in Excel
illustration of how to delete a table in Excel (freepik.com/rawpixel.com)Now, you already know how to make a table in Excel, right? This method is definitely very useful if you frequently use Microsoft Excel. Besides how to create, you also need to understand how to delete table.
When there is a wrong table, you can delete it easily. If you want to completely delete the table, use this method:
- Select or table data block to be deleted
- Select ‘Home Tab’, then select ‘Delete’
- An easier alternative, you can immediately press the ‘Delete’ button.
So, what if you want to delete a table but the contents and format remain? No need to be confused, follow the following method:
- Click the table to delete
- Select the ‘Design tab’
- Then, select ‘Covert to Range’
- Select ‘Yes’ if you want to delete the table.
Instead, you can just delete the contents of the table. This way, the table stays on the worksheet.
Here’s how to delete table contents:
- Block table contents to be deleted
- Then, click on the ‘Home Tab’ and ‘Delete’ on group cells
- Another option, you can directly press the ‘Delete’ button on the keyboard.
That’s it how to make a table in excel which you can easily practice. You can also delete the table or the contents of the table in the ways above.
Try to apply the method when using Excel, OK?
Also Read: How to Equalize Column Sizes in Excel, Can Be Automatic or Manual
