Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

format table

ResolvedVersion 2007

Maria has attended:
Excel Intermediate course

Format as table

what is the advantage?

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

Excel tip:

Repeat action

The F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.