O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

OFFSET()

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.

Arguments

  • 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.

Important

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required