02:57:00
Easy ways to Create a table
You can use one of two ways to create a table. You can
either insert a table in the default table style or you can format your data as
a table in a style that you choose.
Insert a table using the default table style
On a worksheet, select the range of cells that you want to
include in the table. The cells can be empty or can contain data.
On the Insert tab, in the Tables group, click Table.
Keyboard shortcut You
can also press CTRL+L or CTRL+T.
If the selected range contains data that you want to display
as table headers, select the My table has headers check box.
Table headers display default names if you do not select the
My table has headers check box. You can change the default names by selecting
the default header that you want to replace, and then typing the text that you
want.
Excel Tips
After you create a table, the Table Tools become available,
and a Design tab is displayed. You can use the tools on the Design tab to
customize or edit the table. Note that the Design tab is only visible when a
cell in the table is selected.
Unlike lists in Office Excel 2003, a table does not have a
special row (marked with *) for quickly adding new rows.
Insert a table using a style of your choice
On the worksheet, select a range of empty cells or cells
that contain the data that you want to quickly format as a table.
On the Home tab, in the Styles group, click Format as Table.
Note When you use
Format as Table, Excel automatically inserts a table.
Under Light, Medium, or Dark, click the table style that you
want to use. If the selected range contains data that you want to display as
table headers, click a table style that includes a header row.
Note Custom table styles are available under
Custom after you create one or more of them.
Excel Tips
After you create a table, the Table Tools become available
when a cell is selected in the table, and a Design tab is displayed. You can
use the tools on the Design tab to customize or edit the table.
Unlike lists in Excel 2003, a table does not have a special row
(marked with *) for quickly adding new rows.
