How to Convert Excel spreadsheet data into a Table

How to convert an Excel spreadsheet into a Table.

SPECIAL NOTE:
August 2022 NOTE: I created this video a few years back for Excel 2017 but it is still applicable to the newest version of Excel Office 365.

There are multiple data analysis benefits to converting your data to a Table. However, this quick video focuses only on the time-saving tip of the formatting benefits of conversion to a Table.

Save time formatting every other row of data in an Excel spreadsheet by converting the data into a list. Click in your list and press CTRL + T and click OK (older versions of Excel used CTRL + L). The table feature can also be accessed from the Insert ribbon. Once converted, every other row will be shaded. In the future, when you delete, add and/or insert rows and columns, the formatting will automatically adjust accordingly.

[tshepomalaka]

This is great, thank you - I look so smart now

[lindas.]

Wow! That's very helpful. Thank you for sharing!!

[GaneshChatnale]

When we enter ctrl +t then they open new tab

[julenehunter]

Donna is there a way to take a table and merge to individual tables for each row? I've tried this in a WORD merge directory, but would love to keep in a spreadsheet so I can embed the tables. Example : Current table includes a library of books with ISBN, titles, descriptions etc. = 19 Columns, 300 books with descriptions. Great - loads of bulk detail. Now, I want each book to have a table w 2 columns - 1st column is the 19 descriptors, 2nd column is now the row info for just that title. Each book can have it's own tab?


It's got to be possible. Just beyond my figuring.

[informationtechnologyknowl]

but sir when i merge any cells its not merged in these method

[ladibug]

I have been formatting as table for many years, yet, today, when I click "Format as Table" it does not format it. What am I missing?

[curtisrace]

I need to remove the table format to a list format. How do I do this?