Revision as of 17:49, 1 May 2012
Dflak (Talk | contribs)
← Previous diff |
Revision as of 17:56, 1 May 2012
Dflak (Talk | contribs)
Next diff → |
| Line 6: |
Line 6: |
| | *They automatically “copy down” formulas you enter. | | *They automatically “copy down” formulas you enter. |
| | ===Creating Tables=== | | ===Creating Tables=== |
| - | Data coming into a spreadsheet as a result of a query or data import will come in as a table. However, any existing range of data can be converted into a table. In this article, the following data are used | + | Data coming into a spreadsheet as a result of a query or data import will come in as a table. However, any existing range of data can be converted into a table. In this article, the following data are used<br><br> |
| | + | [[Image:File01.jpg]]<br><br> |
| | + | To convert a range of data that isn’t already a table into a table, put the cursor anywhere in the range and select Format as Table from the Home Ribbon. |
Revision as of 17:56, 1 May 2012
<>
Excel Tables
Excel Tables came into existence with Excel 2007. They are a powerful tool that can make life a lot simpler. The main strengths of tables are:
- They are dynamic (they automatically adjust as data is added or deleted)
- They address the elements in a number of ways.
- They automatically “copy down” formulas you enter.
Creating Tables
Data coming into a spreadsheet as a result of a query or data import will come in as a table. However, any existing range of data can be converted into a table. In this article, the following data are used
To convert a range of data that isn’t already a table into a table, put the cursor anywhere in the range and select Format as Table from the Home Ribbon.
Excel Tables
