Microsoft Office Tutorials and References
In Depth Information
Creating a table
1. Make sure that the range contains no completely blank rows or columns.
2. Activate any cell within the range.
3. Choose Insert
Table (or press Ctrl+T).
Excel responds with its Create Table dialog box, shown in Figure 158-2. Excel tries to
guess the range and whether the table has a header row. Most of the time, it guesses
4. If Excel does not guess correctly, make your corrections before you click OK.
Figure 158-2: Use the Create Table dialog box to verify that Excel guessed the table dimensions correctly.
The range is converted to a table (it uses the default table style), and the Table Tools contextual
Excel might guess the table’s dimensions incorrectly if the table isn’t separated from
other information by at least one empty row or column. If Excel guesses incorrectly,
just specify the exact range for the table in the Create Table dialog box. Or, click
Cancel and rearrange your worksheet so that the table is separated from your other
data by at least one blank row or column.