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 any Cell in the Total Row.

Go to Home -> Cells->Insert.
Click on Insert Table Rows Above.

 

What Do You See?  After you insert a new Row or Column, you may see a small format painter. You can click on the arrow and choose the formatting for the new Row.

 

Home->Cells->Insert->Insert Table Rows Above

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.1. Apply and modify cell formats: Modify a table