Add or Remove Table Rows and Columns

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

1. 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).
2. 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).
3. 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.
4. 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

1. Select a cell in the row below which (or above which) the new record should appear, per the instruction.
2. 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).
3. 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:

1. 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).
2. 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

1. Select any cell in the column to remove (or select the whole table column).
2. 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

1. Select a cell in the row to remove.
2. 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.

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:

1. Click inside the table.
2. Table Design → Resize Table.
3. Enter the full new range including headers (for example =$A$1:$E$40).
4. 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

1. 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.
2. Insert a table column to the left of column C; name the header Category.
3. Delete one unused table row with Delete Table Rows (not Clear).
4. Use Resize Table to set the table exactly to $A$1:$E$12 and confirm the border.
5. 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.