How do I do this

Dear Dan

Thank you for attending Excel 2007 Intermediate course. I hope you enjoyed the training.

Format as table in the previous versions of Excel was called Creating List. There are various advantages of formatting the range of data into a table. Following are some of them:

* The table looks more professional
* You can perform calculations such as Sum, Average, etc… with a click of a button.
* When you scroll down the sheet the column Letters automatically change to the column headings of your table.
* You can perform Auto filters as well as sort conveniently.

To convert the range of data into table:

Click anywhere inside your range of data.
Choose Home Tab on the Ribbon and under Styles Group choose Format as table.
From the list of various styles please select any one.
Press OK when the Format as table dialog box appears.

NB: You will observe a contextualized tab as your last tab where you can perform many of the options relevant to Format table feature.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003