How-To Geek on MSN

Stop manually naming ranges in Excel: There is a much faster way

Transform your spreadsheets and save valuable time by automatically mapping headers to data for readable formulas.

Create Dynamic Excel Data Validation Lists Using Table Spill Ranges

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets ...