3 Ways to Create Tables in Excel for Beginners (All Excel Versions)

The use of Microsoft Office has been so closely related to office activities in various companies. This software suite is indeed created and designed according to its name, intended for employees or office employees to support all their activities in the office.

One of the most widely used office applications in Microsoft Office is Microsoft Excel. This application does have many functions and features that allow all your activities and reporting to be easier. It would be a shame if you don’t understand how to use it.

For starters, we will provide a little tutorial for beginners who want to learn to use Microsoft Excel. The Excel tutorial that we will explain is about how to easily create tables in Excel, even if you are a beginner it will be easy to understand the contents of the tutorial below. You can read more about how to create a table in Excel below:

How to Create a Table in Excel for Beginners

1. First of all, please open the Microsoft Excel application on your computer.

2. Then on the main page, you will be faced with several workbook templates that you can use for work. In this option, please select Blank Workbook.

3. Wait until the page moves to a blank workbook page as shown below.

4. Since you want to create a table, please write down the contents of your table. An example might be like the image below.

5. Then drag the cursor on the table contents. Then select Insert on the Ribbon then select and click Table.

6. Then you will see a pop up box. When this pop up box appears, you will see that the area that was dragged earlier has changed to a dotted line. In the pop-up box, you will see the cell area that was previously dragged. Click on the text “My table has headers” When finished, click OK.

7. Next you will see a simple table like this.

1. Creating Borders on Microsoft Excel Tables

1. First of all, please open the Microsoft Excel application on your computer.

2. Then on the main page, you will be faced with several workbook templates that you can use for work. In this option, please select Blank Workbook.

3. Wait until the page moves to a blank workbook page as shown below.

4. Since you want to create a table, please write down the contents of your table. An example might be like the image below.

5. Then drag the cursor on the table contents. Then select Home in section Ribbon then select and click one of the appropriate border types, in this case we choose outside borders because you want to frame the entire table content in one area or area.

6. In addition to the method in no. 5, you can also use this method. After you drag the cursor on the table contents, right click on the mouse and then click Format Cells..

7. Next will come out a box Format Cells. Select tab Border. In the border box, you can select any part you want to be bordered or lined with. After adding a border, then click OK.

8. You can see the final result in the image below. Your table has also been framed in a border.

2. Coloring Microsoft Excel Tables

1. First of all, prepare a table along with the data to be colored.

2. Then point and drag the cursor to the area or area to be colored.

3. Next on Ribbon Home, click Fill Colors. In this section, please select the color you want to apply to the previously selected area.

4. The result is like the image below.

5. You can try tweaking other columns and rows so that you can make your table more colorful.

3. Beautify Microsoft Excel Tables

1. First open the table that was previously created in the first tutorial.

2. Then open Ribbon Design and hover over the menu Table Styles.

3. Click the down arrow so that all table style options are clearer. Please select and click the one that best suits your wishes.

4. The following is one of the results.

Microsoft Excel has a very complete and capable function when used for office activities. This application is perfect for those of you who want to do various reporting tasks requested by superiors in the office. Hopefully the tutorial on how to create a table in Excel above is useful and good luck!

…in it for your literacy need

Share :