Table Properties: Resize The Table Tools include two more groups of options: Table Properties and Table Tools.  Before You Begin: Review the Properties The Table Properties include the Name and the Range. By default, the Table was named Table1 in this example. The Resize Table button lets you select the Range of Cells.   Try it: Resize the Table Click anywhere on the Table. The Table Tools should be available.   Go to Table Tools-> Design ->Properties Select Resize Table.   What Do You See? Microsoft Excel will outline the Range of the Table. In the example on this page, the Table is =$A$1:$H$71. The Range is in Absolute references.   If you wish, you can select a new range, but the Header must stay the same.

Exam 77-882: Microsoft Excel 2010 Core 3. Formatting Cells and Worksheets 3.1. Apply and modify cell formats: Edit the Table Properties Table Tools-> Design ->Properties-> Resize Table