# OFFSET

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns a reference to a range. The range is a specified number of rows and columns from a cell or range of cells. The function returns a single cell or a range of cells.

## Syntax

OFFSET(*reference,rows,cols,height,width*)

## Remarks

This function has these arguments:.

| **Argument** | **Description** |
| -------- | ----------- |
| *reference* | The location from which to base the offset |
| *rows* | Number of rows to which the upper left cell refers |
| cols | Number of columns to which the upper left cell refers |
| *height* | [Optional] Number of returned rows; if omitted, same as *reference* |
| width | [Optional] Number of returned columns; if omitted, same as *reference* |

The *cols* can be positive (right of the reference) or negative (left). If height or width is omitted, it is the same as the reference.

## Remarks

This is a volatile function.

## Data Types

Accepts a cell range for reference. Accepts numbers for rows, cols, height, and width. Returns a cell range.

## Examples

`OFFSET(D3,2,3,1,1)`
`OFFSET(D3:E5,2,3,1,1)`

## Version Available

This function is available in product version 2.5 or later.

## See Also

[HLOOKUP](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionHLOOKUP) \| [LOOKUP](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLOOKUP) \| [Lookup Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functslookup)