Excel Tables (Ctrl+T) & Auto-Expanding Design
Convert plain cell ranges into named Excel Tables so formulas, data validation, charts, and PivotTables auto-expand on new rows.
Key takeaways while you watch
- Press Ctrl+T inside any clean contiguous dataset to turn it into an Excel Table.
- Rename tables descriptively in Table Design (e.g. tblOrders instead of Table1).
- New rows pasted directly beneath a Table automatically inherit formulas and formatting.
Drill: Name an Excel Table Cleanly
Excel Table names cannot contain spaces. Which valid table name replaces 'Sales Orders 2026' cleanly?
| Property | Invalid Input | Valid Name |
|---|---|---|
| Table Name | Sales Orders 2026 | tbl_SalesOrders |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.