Excel supports both full column, andfull rowreferences.
A full column reference is a reference that refers to anentire column.
Like other ranges, a full column reference can include multiple columns.
Any value, no matter how far down the worksheet, will be included.
Charles Williams, an Excel performance expert, has published sometest results here.
If your goal is to create a dynamic range, anExcel Tableis a good choice.
If you need more flexibility, you could create adynamic named range.
