How to Create a Table from range in Microsoft Excel

How to Create a Table from range in Microsoft Excel

1.     Open Microsoft Excel.

2.     Open excel sheet. (Example MARK SHEET of STUDENT DATA Workbook)

3.     Click “Insert” and then click “Table” or press crtl+t

4.     Create Table Dialog box appears.

5.     Select data range (cell range) for which you want to create a table or enter cell range “Where is the data for your table?”

6.     Check the “My table has headers” if you want to use the top row of the selected Range as Table Headers. (If top row if blank then table headers –Column1, Column2, …..)

7.      If you do not check this box, your table will have Headers – Column1, Column2, …

8.      Click “OK”

9.      Your table (table1) is created with default style with shown below.

When you convert a range into a table and Excel automatically provides −

• A Table Name (Table1, table2…)
• Column Header Names with a Filter button to filter the data.
• Formatting to the Data (Cell Color and Font Color) for better Visualization
• Table Tools appear in the ribbon for Table design and table modification.