- 1). Select a blank cell in which to enter the offset formula. Type "=OFFSET" into the cell (without the quotes). Add parentheses. You will type the offset path inside of the parentheses.
- 2). Type the reference cell that contains the number to be offset. Add a comma after the referenced cell number, for example:
=OFFSET (A12,) - 3). Type the number of rows to move the offset number. Type a positive number to indicate rows down or a negative number to indicate rows up. Add a comma after the number. Here is an example of moving the number in cell A12 five rows down:
=OFFSET (A12,5,) - 4). Type the number of columns to move the offset number. Type a positive number to indicate move to the right or a negative number to indicate move to the left. Here is an example of moving the number in cell A12 two columns to the right:
=OFFSET (A12,5,2) - 5). Type in a positive number to indicate the number of rows of data to return. This step is optional and will not affect the offset function if skipped. Example:
=OFFSET (A12,5,2,1) - 6). Type in a positive number to indicate the number of columns of data to return. This step is optional and will not affect the offset function if skipped. Example:
=OFFSET (A12,5,2,1,1) - 7). Hit the Enter key. The cell value will be offset to the path indicated in the formula.
- 8). Update this data by hitting the F9 key when data has been changed within the spreadsheet.
previous post
next post