FinanceTier 015 minbeginner

Insert and Delete Rows and Columns

Add a missing account inside a table so its totals still pick it up, and remove a stray unused column cleanly.

What you will learn

• Insert a row inside an existing table so formulas referencing it expand automatically
• Delete a column so everything to its right shifts left, rather than merely clearing its contents
• Explain why adding a row outside a referenced range leaves totals silently wrong

Excel skills

Insert Row, Delete Column · Rows and Columns

The task

This account list counts and totals its balances with formulas above the table. Prepaid Expenses has a balance of 4084 but is missing from the table - insert a real row for it inside the table, not below the totals. The Notes column is empty and unused - delete it so Reviewed By shifts left.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free