98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Format as table
Format as table
Resolved · Low Priority · Version 2007
RE: format as table
Dear Maria
Thank you for attending Excel 2007 Intermediate Course. I hope you enjoyed the course and believe it was beneficial to you.
This feature used to be called List in previous versions but Microsoft people have really polished this feature and there are some greate improvisations which are listed below:
Auto filter is automatically applied. (Arrows next to all your column headings to filter your data.
If you add data to the right hand of the last column in your table it will automatically be formatted and taken as a part of that table. Similarly if you start adding data on the bottom of the last row in your table it will do the same.
When you perform calculation it you can simply use the name of the column headings instead of typing the cell name. e.g. instead of C4 you can Type [Commissions]. Please note that the name of the column heading is in Square brackets.
All the below options can be accessed from the Table tools > Design contextualized tab which appears on the title bar as a last tab:
Change different table style
Have a Different first and the Last column
Branded Rows and columns so that the data can be easily read
Total Row. This feature by default totals only the last column that has numeric data. But once you have the Total Rows you can click at the bottom of the individual column and choose the relevant function from the drop down list.
Another interesting part of this Table facility is that if you have lots of rows and you start scrolling down you
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Recovering Unsaved Work in Excel 2010Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back. |