How to Use the Excel Offset Function
When you work on an Excel worksheet, you will often need to use functions that reference data ranges regardless of the data within them. The OFFSET command will return the value data of a cell based on its placement compared to other cells. The OFFSET command works by counting a certain number of rows, then columns, away from the start point.
Other People Are Reading
Instructions
-
-
1
Launch Excel from the Start menu.
-
2
Open an Excel worksheet that contains a table of data.
-
-
3
Select a cell that does not contain any data.
-
4
Type the following into the cell:
=OFFSET(A1,2,3,1,1)
There are five parts to the syntax of an OFFSET function. "A1" refers to the starting range. The "2" refers to the number of rows away from the range. The "3" refers to the number of columns away from the range. The first and second "1" both refer to the height and width of the returned range.
-
5
Press "Enter." The OFFSET will return the figure that is in D3 (two rows down and three columns across from A1). Adjust the values of the OFFSET function as needed for your Excel data.
-
1
