MS Excel: Convert Data Into Table [Video Included]


If you are new to microsoft excel and trying to learn excel basics, you should read this blog. In this blog, I am going to explain how to convert ordinary data into a good looking table in excel step by step.

Tables in ms excel not only look nice but also make your data look way more organized. So if you are targeting to represent your research or data professionally to your client, try converting it in tables. I am sure your client will be impressed.

(I have also added the video tutorial at the end of this blog for you to understand the entire process in a better way + Tips to expand table and sort table data in alphabetical order)

Let’s take a look at how to convert Data into Tables in microsoft office excel:

Step 1: Go to your excel spreadsheet and populate data in different columns.


Step 2: Select your data.


Step 3: Upon selecting the data you will notice an icon at the bottom right corner of your selection. Click on that to open the icon menu.


Step 4: Click on TABLESMS-Excel-Convert-Data-Into-Table

Step 5: Clicking on Tables will prompt you to 2 Options. Click on Table.


Step 6: As soon as you click on the table, it will convert your data into a table with added headers to it. Your data should look like this


Step 7: Update Column Headers as per your preference. I replaced Column 1 with Connect with me and Column 2 with Handles. (These are my social media handles, please do connect with me)


Step 8: Watch the full video attached below for a brief tutorial + Tips on how to expand table or sort table data in alphabetical order.

For more ms excel tutorials subscribe my YouTube Channel:  Click here to subscribe

Related Articles

MS Excel / Word – 2 Ways To Change Author Name

Microsoft Excel: How To Merge Data Of 2 Or More Columns

30 Keyboard Shortcuts To Create Symbols

Leave a Reply

Notify of