Administration and Executive AssistantTier 015 minbeginner

Insert and Delete Rows and Columns

Add a missing team member inside a table so its totals still pick them 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 timesheet counts and totals its team with formulas above the table. Priya Naidoo worked 22 hours this week but is missing from the table - insert a real row for them inside it, not below the totals. The Notes column is empty and unused - delete it so Approved 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