Excel: The Table is Set  Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

Add to the Table

Is the Table flexible? Can you add another row or column to the table without losing the formatting, totals calculations, or otherwise breaking it?

 

Try It: Add a Row
Select the Total Row.

Go to Insert -> Table Rows Above.

 

 

What Do You See?  After you insert a new row or column, you may see a small format painter. If you click on the arrow, you can choose how you would like to format the new row.

 

 
Insert->Insert Table Rows Above

 
 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 2. Formatting Data and Content

  2.4. Format data as a table  2.4.2.  Insert and delete rows and columns in tables