In Microsoft Excel 2010,
how do you convert your existing data into a table and apply a table style to it?
Hint: As with so many functions in Microsoft Office programs across the board, there is more than one way to do this. The steps I take to achieve this particular goal may differ from what you would do, but if the end result is essentially the same then you’ve done it correctly!
Answer :
1. With your worksheet already open and on the screen, select the data from which you wish to create your table.
2. On the Home tab, in the Styles group, select the drop down arrow associated with the Format as Table button. Select the table style of your choice.
That’s all there is to it!
-Katie Caplan,
Client Service Coordinator and Instructor,
Sector Learning Solutions
Sector Learning Solutions 