Convert ranges to Tables (Ctrl+T) for auto-expanding ranges and clean references.
“Excel Tables & Structured References” is part of Excel — Basic to Advanced (3 Levels). Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.