Microsoft Office Tutorials and References
In Depth Information
3. Choose Insert ⇒ Tables ⇒ Table (or press Ctrl+T).
Excel responds with its Create Table dialog box. Excel tries to guess the range and also whether the table
has a Header row. Most of the time, it guesses correctly. If not, make your corrections before you click OK.
4. Click OK.
The table is automatically formatted, and Filter mode for the table is enabled. In addition, Excel displays its
Table Tools contextual tab (as shown in Figure 9-3). The controls on this tab are relevant to working with a
Figure 9-3: When you select a cell in a table, you can use the commands on the Table Tools contextual
Another method for converting a range into a table is Home ⇒ Styles ⇒ Format as Table.
This command name is a bit misleading. Choosing this command not only formats a
range as a table, but it also makes the range a table.
In the Create Table dialog box, Excel may 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 dialog box. Or, click Cancel and rearrange your worksheet such that the table is separ-
ated from your other data by at least one blank row or column.
To create a table from an empty range, just select the range and choose Insert ⇒ Tables ⇒ Table. Excel creates the
table, adds generic column headers (such as Column1 and Column2), and applies table formatting to the range.
Almost always, you'll want to replace the generic column headers with more meaningful text.
Changing the look of a table
When you create a table, Excel applies the default table style. The actual appearance depends on which docu-
ment theme you use in the workbook. If you prefer a different look, you can easily change the entire look of the
Select any cell in the table and choose Table Tools ⇒ Design ⇒ Table Styles. The Ribbon shows one row of styles,
but if you click the bottom of the vertical scroll bar, the Table Styles group expands, as shown in Figure 9-4.
The styles are grouped into three categories: Light, Medium, and Dark. Notice that you get a live preview as
you move your mouse among the styles. When you see one that you like, just click to make it permanent.