You should confirm the data cell range, if your table has headers you should check the My table has headers checkbox. Now to create a table based on these cells, you should select all the data cells ( not include the title cell ( Sale Report cell ) ), then click Insert -> Table ( in Tables group ).To do this, you should select all of it’s sibling cells and then click Home -> Merge & Center item in Alignment group. The title Sale Report cell has merged all it’s sibling cells.The example data is car sales report for different car brands in month January, February, and March. Create a worksheet and input the below data into it.
