Microsoft Office Tutorials and References
In Depth Information
Defining Excel tables
To create an Excel table, enter a series of column headers in adjacent cells, and then enter
a row of data below the headers. Click any header or data cell into which you just entered,
and then, on the Home tab, in the Styles group, click Format As Table. Then, from the
gallery that appears, click the style you want to apply to the table. When the Format As Table
dialog box opens, verify that the cells in the Where Is The Data For Your Table? field reflect
your current selection and that the My Table Has Headers check box is selected, and then
click OK.
Excel can also create an Excel table from an existing cell range as long as the range has no
blank rows or columns within the data and there is no extraneous data in cells immediately
below or next to the list. To create the Excel table, click any cell in the range and then, on
the Home tab, in the Styles group, click the Format As Table button and select a table style.
If your existing data has formatting applied to it, that formatting remains applied to those
cells when you create the Excel table. If you want Excel to replace the existing formatting
with the Excel table’s formatting, right-click the table style you want to apply and then click
Apply And Clear Formatting.
When you want to add data to an Excel table, click the rightmost cell in the bottom row of
the Excel table and press the Tab key to create a new row. You can also select a cell in the
row immediately below the last row in the table or a cell in the column immediately to the
right of the table and enter a value into the cell. After you enter the value and move out of
the cell, the AutoCorrect Options action button appears. If you didn’t mean to include the
data in the Excel table, you can click Undo Table AutoExpansion to exclude the cells from
Search JabSto ::




Custom Search