Microsoft Office Tutorials and References
In Depth Information
Creating an Excel table
Creating an Excel table
One popular way to maintain data in Excel is by creating a data
list. A list describes one type of object, such as orders, sales, or
contact information. Structurally, a list consists of a header row,
which contains labels describing the data in each column, and
data rows, which contain data about a particular instance of the
list’s subject. For example, if you use a list to store your
customer’s contact information, you could have a separate column for
the customer’s first name, last name, street address, city, state,
postal code, and telephone number. Each row in a list would
contain a particular customer’s information.
In Excel 2013, you can store your data lists in an Excel table. An
Excel table is an object that you can refer to in your formulas
and use to summarize your data.
Create an Excel table
1 Type your table headers in a single row.
2 Type your first data row directly below the header row.
3 Click any cell in the range in which you want to create a table.
4 On the Home tab, click Format As Table.
5 Click the table style to use.
6 Verify that Excel identified the data range correctly.
7 If your table has headers, select the My Table Has Headers check
Click OK.
TIP You can display the Create Table dialog box by clicking
any cell in an existing cell range and pressing Ctrl+L. If you click
OK, Excel 2013 creates an Excel table using the default Excel table style.
Search JabSto ::

Custom Search