If you find the table header’s text is only partially visible, you can select the table and click Home -> Format ( in Cells group ) -> AutoFit Column Width menu item to expand header columns.Click the OK button, it will translate the excel cell to the below table.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.
0 Comments
Leave a Reply. |