Syntax. OFFSET(reference,rows,columns,height,width)

Definition. This function returns a cell reference that is a specified number of rows and columns from a given reference.


  • reference (required). The reference from which you want to base the offset, a reference to a single cell or to a range of adjacent cells. An argument with a different reference type causes the #VALUE! error.


If the argument is a named range, you need to press Ctrl+Shift+Enter after you enter the formula even if you enter the formula in a single cell. Otherwise you get an error.

  • rows (required). The number of rows that you want the upper-left cell of the range to be moved up or down.

  • columns (required). An expression that can be evaluated to an integer. ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.