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.

Exam 77-420 Microsoft Excel 2013
3. Create Tables
3.1 Create a Table: Add and Remove Cells within Tables


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