Excel 2010 Bible

Part I: Getting Started with Excel

102

FIGURE 5.3

When you select a cell in a table, you can use the commands located on the Table Tools ➪ Design tab.

Creating a Table ................................................................................................................

Most of the time, you’ll create a table from an existing range of data. However, Excel also allows

you to create a table from an empty range so that you can fill in the details later. The following

instructions assume that you already have a range of data that’s suitable for a table.

1. Make sure that the range doesn’t contain any completely blank rows or columns;
   otherwise, Excel will not guess the table range correctly.


2. Select any cell within the range.


3. Choose Insert ➪ Tables ➪ Table (or press Ctrl+T). Excel responds with its Create
   Table dialog box, shown in Figure 5.4. Excel tries to guess the range as well as whether
   the table has a header row. Most of the time, it guesses correctly. If not, make your cor-
   rections before you click OK.

FIGURE 5.4

Use the Create Table dialog box to verify that Excel guessed the table dimensions correctly.