How to Create a Table in Microsoft Excel

How to Create a Table in Microsoft Excel

1.     Open Microsoft Excel.

2.     Click “Insert” and then click “Table”.

3.     Create Table Dialog box Appears.

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

5.     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, …..)

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

7.      Click “OK”

8.      Your table is created with default style shown below.