Add or Remove Table Rows and Columns

Microsoft Excel Microsoft 365 Apps

Track your progress as you read

Finished sections get a check mark.

1 Introduction & Exam Overview

About the MO-210 Exam Performance-Based Exam Strategy

2 Import Data & Navigate Workbooks

Import Data from Text Files Import Data from Online Sources Search and Navigate to Named Cells, Ranges, Elements Insert and Remove Hyperlinks

3 Format Worksheets, Views & Collaboration

Page Setup, Headers, Footers, Row Height & Column Width Quick Access Toolbar, Views, Freeze Panes, Properties, Display Formulas Print Area, Export Formats, Print Settings, Inspect, Comments & Notes

4 Manipulate Data in Worksheets

Paste Special and Auto Fill Insert and Delete Rows, Columns, and Cells Generate Numeric Data with RANDBETWEEN and SEQUENCE

5 Format Cells and Ranges

Merge, Alignment, Orientation, Indentation, Wrap Text Number Formats, Format Painter, Format Cells Dialog Cell Styles, Clear Formatting, Group Worksheets

6 Named Ranges & Visual Summaries

Define and Reference Named Ranges Insert and Manage Sparklines Apply and Remove Conditional Formatting

7 Create and Format Tables

Create Excel Tables from Cell Ranges Apply Table Styles and Convert Tables to Ranges Add or Remove Table Rows and Columns

8 Table Options, Filter & Sort

Configure Table Style Options Insert and Configure Total Rows Filter Table Records Sort Data by Multiple Columns

9 Formula References

Relative, Absolute, and Mixed References Structured References in Tables

10 Calculate and Transform Data

SUM, AVERAGE, MIN, and MAX COUNT, COUNTA, and COUNTBLANK Conditional Operations with IF SORT and UNIQUE Functions

11 Format and Modify Text

LEFT, RIGHT, and MID UPPER, LOWER, LEN, CONCAT, and TEXTJOIN

12 Create Charts

Create Charts from Data Create Chart Sheets

13 Modify and Format Charts

Add Data Series and Switch Rows/Columns Add and Modify Chart Elements Chart Layouts, Styles, and Alternative Text

Add or Remove Table Rows and Columns

Key Takeaways Explain This Topic AI

Insert or delete rows and columns from inside the table so the table object resizes with the structure change

Press Tab in the last cell of the last data row to add a new empty table row quickly

Use Table Design → Resize Table when you must set an exact final range after adding or excluding cells

Deleting a table column removes that field from the table; clearing a cell does not remove the column

Distinguish inserting worksheet rows above a table from inserting rows inside the table—exam tasks usually mean inside

Last updated: August 2026

Why modifying table structure matters on MO-210

Under Modify tables in Domain 3, Certiport requires you to Add or remove table rows and columns . Creation gets you a table; structure tasks change its shape afterward—insert a field, delete a blank column, append records, or shrink the table so empty rows are no longer part of the object.

Task wording includes "Insert a new column in the table named Discount" , "Delete the empty table column" , "Add a row to the bottom of the table" , "Remove the last three unused table rows" , or "Resize the table so it includes A1:F25." Those map to Insert / Delete on the Home tab (or right-click menu) while a table cell is selected , the Tab key in the last cell, the resize handle , and Table Design → Resize Table .

Insert rows and columns inside a table

Working inside the table is the key. Excel adjusts the table boundaries when you insert or delete in a way that participates in the table object.

Insert a table column

Select a cell in the column to the right or left of where the new field should appear (follow the task: "to the left of Amount", "after Region", and so on).

Right-click → Insert → Table Columns to the Left (or use Home → Insert → Insert Table Columns to the Left when the selection is inside a table).

Type the new header name in the header cell if Excel created a generic Column1-style name or left it blank for you to label.

Enter data in the new column's cells as required.

You can also type a new header in the blank cell immediately to the right of the last header; many Excel builds auto-expand the table to include that column. On the exam, if auto-expand does not occur or the descriptor wants a column in the middle, use Insert Table Columns.

Insert a table row

Select a cell in the row below which (or above which) the new record should appear, per the instruction.

Right-click → Insert → Table Rows Above (wording may vary slightly by build: table row insert commands appear when the active cell is in a table).

Or use Home → Insert table row options when available for the selection.

Inserted rows inherit table formatting and stay inside the table. Formulas in calculated columns typically fill down automatically into the new row.

Tab key: fastest way to append a row

A classic MOS technique:

Click the last cell of the last data row in the table (not the Total Row—if a Total Row is on, go to the last data row above it).

Press Tab .

Excel adds a new empty data row at the bottom of the table and moves the active cell into that row. This is ideal for "Add a new record at the bottom of the table" without hunting Insert menus.

Caveats:

Tab from the middle of a row moves to the next cell; only Tab from the last column of the last data row appends a row.

If a Total Row is displayed, Tab behavior still targets data rows; do not confuse Total Row cells with the last data row.

Tab does not insert a column—use Insert or type beside the header for columns.

Delete table rows and columns
Delete a table column

Select any cell in the column to remove (or select the whole table column).

Right-click → Delete → Table Columns (or Home → Delete → Delete Table Columns).

The field disappears from the table and remaining columns close the gap. Sheet columns outside the table are unaffected unless you chose a worksheet-level delete by mistake.

Delete a table row

Select a cell in the row to remove.

Right-click → Delete → Table Rows (or Home → Delete table row command).

Prefer Delete Table Rows over clearing cell contents. Clearing leaves an empty row still inside the table; deleting removes the row from the table structure.

Goal Prefer Avoid as a substitute
Remove a field from the table Delete Table Columns Pressing Delete on header text only
Remove a record Delete Table Rows Clearing the row but leaving a blank table row

Add a record at the bottom Tab in last cell, or Insert Table Rows Inserting a worksheet row far below and hoping it joins

Exact final A1-style boundary Resize Table Guessing with random inserts only
Resize Table for precise boundaries

When the project gives an exact range—or when empty rows at the bottom should leave the table—use Table Design → Resize Table :

Click inside the table.

Table Design → Resize Table .

Enter the full new range including headers (for example =$A$1:$E$40 ).

OK.

Use Resize Table to:

Include adjacent data that was never absorbed by auto-expand
Exclude extra blank rows still marked as part of the table
Match a descriptor that states the table must refer to a specific address

The resize handle at the bottom-right corner does the same job visually: drag until the border frames the correct block. Resize Table is safer when addresses are specified in text.

Inserting worksheet rows vs table rows

If you select an entire sheet row above a table and Insert, Excel may push the table down. If you insert sheet rows through the middle of a table carefully, table size usually grows. On MO-210, when the task is about table structure, click a table cell first so the Insert/Delete menus show Table Rows / Table Columns . Using only sheet-level insert without noticing you are outside the table is a common miss.

Adding data that auto-expands the table

Typing in the empty row immediately under the table (adjacent) or in the empty column immediately to the right often expands the table automatically. That counts as adding a row or column for many practical purposes. If expansion does not happen (blank row gap, table options, or Total Row quirks), fall back to Tab, Insert, or Resize Table.

Keep a one-row gap between a table and unrelated content below it when you do not want accidental expansion—on the exam, follow the project layout; do not invent gaps that change scored ranges.

Interaction with Total Row and filters

With Total Row on, new data rows belong above the Total Row; Excel keeps the total at the bottom.

Filtered tables still allow structural edits, but be careful: deleting "what you see" can delete underlying rows. For Associate tasks, clear filters if you need to delete specific records by position unless the task says to delete filtered results only.

Calculated columns auto-fill formulas into new rows—useful confirmation that the row is truly inside the table.

Common exam pitfalls

Pressing Delete on cell values and thinking the table row was removed—empty row remains part of the table.

Inserting a column on the worksheet outside the table border so the table never gains the field.

Pressing Tab from the first column of the last row (moves sideways) instead of from the last column.

Resizing so aggressively that a title above the table or a notes column beside it gets swallowed into the table.

Deleting sheet columns that shift unrelated data when only a table column delete was required.

Forgetting to rename a new Column1 header when the task specified a field name like TaxRate .

Practice checklist

Create a table on A1:D10 . From the last cell of the last data row, press Tab to add row 11; enter a sample record.

Insert a table column to the left of column C; name the header Category .

Delete one unused table row with Delete Table Rows (not Clear).

Use Resize Table to set the table exactly to $A$1:$E$12 and confirm the border.

Optionally turn Total Row on, add another data row with Tab, and confirm the Total Row stays at the bottom.

Those moves—insert/delete inside the table, Tab to append, and Resize Table—cover adding and removing table rows and columns for MO-210.