Microsoft Office Tutorials and References
In Depth Information
Defining Excel tables
the Excel table. If you never want Excel to include adjacent data in an Excel table again, click
Stop Automatically Expanding Tables.
TIP To stop Table AutoExpansion before it starts, click the File tab, and then click Options.
In the Excel Options dialog box, click Proofing, and then click the AutoCorrect Options
button to open the AutoCorrect dialog box. Click the AutoFormat As You Type tab, clear
the Include New Rows And Columns In Table check box, and then click OK twice.
You can add rows and columns to an Excel table, or remove them from an Excel table
without deleting the cells’ contents, by dragging the resize handle at the Excel table’s
lower-right corner. If your Excel table’s headers contain a recognizable series of values
(such as Region1, Region2, and Region3), and you drag the resize handle to create a
fourth column, Excel creates the column with the label Region4 —the next value in the
Excel tables often contain data that you can summarize by calculating a sum or average,
or by finding the maximum or minimum value in a column. To summarize one or more
columns of data, you can add a Total row to your Excel table.
When you add the Total row, Excel creates a formula that summarizes the values in the
rightmost Excel table column. To change that summary operation, or to add a summary
operation to any other cell in the Total row, click the cell, click the arrow that appears, and
then click the summary operation you want to apply. Clicking the More Functions menu