What does offset function mean?

Offset is a function in Excel. The function of this function is to use the specified reference as the reference system and obtain a new reference through the given offset. The reference returned can be a cell or a range of cells. , and can specify the number of rows or columns to return.

Offset is a function in Excel. In Excel, the function of the OFFSET function is to use the specified reference as the reference system and obtain a new value by giving a given offset. citation. The reference returned can be a cell or a range of cells. And you can specify the number of rows or columns to return. Reference serves as the reference region of the offset reference system. Reference must be a reference to a cell or a connected range of cells; otherwise, the OFFSET function returns the #VALUE! error value.

In Excel, the Offset property is applied to the following two objects

Apply to the Offset property of the Range object.

Returns a Range object that represents an area outside a specified area. Read only.

expression.Offset(RowOffset, ColumnOffset)

expression required. This expression returns a Range object.

RowOffset Variant type, optional. The number of rows by which the region is offset (positive, negative, or 0 (zero)). A positive value indicates a downward offset, a negative value indicates an upward offset, and the default value is 0.

ColumnOffset Variant type, optional. The number of columns by which the range is offset (positive, negative, or 0 (zero)). A positive value means an offset to the right, a negative value means an offset to the left, and the default value is 0.

Apply to the Offset property of the TickLabels object.

Return or set the distance between labels at each level and the distance between the first-level label and the coordinate axis. Its default distance is 100%, which represents the default distance between the axis label and the axis. The value can be an integer percentage from 0 to 1000, representing the font size relative to the axis labels. Long type, readable and writable.

expression.Offset

expression Required. This expression returns a TickLabels object.

Property Example

Example of application to Range object.

This example activates the cell where the active cell on Sheet1 is shifted three columns to the right and three rows down.

Worksheets("Sheet1").Activate
ActiveCell.Offset(rowOffset:=3, columnOffset:=3).Activate

This example assumes that Sheet1 contains a table with a header row. This example first selects the table, but does not select the header row. Before running this example, the active cell must be in the table.

Set tbl = ActiveCell.CurrentRegion
tbl.Offset(1, 0).Resize(tbl.Rows.Count- 1, tbl.Columns.Count).Select

Example applied to TickLabels object.

If the offset is less than 500, this example sets the distance between the labels on the value axis in Chart1 to twice the current distance.

WithCharts("Chart1").Axes(xlValue).TickLabels
If.Offset < 500 then
.Offset = .Offset * 2
End If

End With

The above is the detailed content of What does offset function mean?. For more information, please follow other related articles on the PHP Chinese website!