Add the formula in the Refers To: in 2010's Formulas > Name Manager > New > tbl > in Refers to: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) > OK.