How to Organize a Table
In a sense, you can call anything you put in a contiguous block of spreadsheet cells a table, but in Excel the term has a more specific meaning. It refers to a block of data organized so that each row refers to an item (a person in an address list, a sale in a transaction log, a product in a product catalog, and so on) and each column contains one piece of information about that item (for example, the postal code of a contact, the date of a sale, or the catalog number of a product). In addition, for a block of data to become a table, you have to designate it as such. (See Creating a Table, next.)
Typically, the worksheet range defined as a table should have the following characteristics:
The top row should consist of labels, ...
Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
