Office 2013 In Depth

Defining a Table Range

To define a table in Excel, you use the Format as Table command on the Ribbon’s Home tab. Before you can define the table, you need to create the table or import it from a source external to Excel. We look at working with external data later in the chapter, so let’s concentrate on issues related to creating your own table directly in Excel.

Tip

You might want to include a key field in your table. This provides a field column that contains a unique identifier for each record in the table, such as employee number or invoice number. You can then use the key field to quickly sort your records back into the original order. You ...