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 » Excel 2007 - Creating Tables
Excel 2007 - Creating Tables
Resolved · Low Priority · Version Standard
Cristin has attended:
Excel Intermediate course
Excel 2007 - Creating Tables
What tab do I create a table under?
RE: Excel 2007 - Creating Tables
Dear Cristin
Thank you for attending Excel 2007 Intermediate Course. I hope you enjoyed the course.
Compared to earlier versions Excel 2007 Format as Table is one of the features that made significant changes to.
Once your list of data has been converted to Table you can perform the following features:
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.
[b]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:Sorting List SubtotalsIf you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. |