Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create One and Two Variable Data Tables in Excel
  • How to Create Area Chart in Excel
  • How to count table rows in Excel
  • How to Use Solver Tool in Excel
  • How to do a t-Test in Excel?

References

  • Vlookup Examples in Excel
  • How to create dynamic named range with OFFSET in Excel
  • How to get last row in text data in Excel
  • How to get last row in numeric data in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table

Data Validations

  • Excel Data validation require unique number
  • Excel Data validation specific characters only
  • Excel Data validation date in specific year
  • Excel Data validation allow weekday only
  • Excel Data validation whole percentage only

How to use Excel OFFSET function

by

This Excel tutorial explains how to use the OFFSET function with syntax and examples.

Excel OFFSET function Description

The Microsoft Excel OFFSET function returns a reference to a range that is offset a number of rows and columns from another range or cell.

OFFSET function is a built-in function in Excel that is categorized as a Lookup/Reference Function. The OFFSET function can be entered as part of a formula in a cell of a worksheet.

Explanation: Based on the example above, the following OFFSET function return:

=OFFSET(A1, 1, 2, 1, 1)
Result: reference to cell C2   (and thus would display $7.23)

=OFFSET(C3, -1, -2, 1, 1)
Result: reference to cell A2   (and thus would display 10567)

Syntax

The syntax for the OFFSET function in Microsoft Excel is:

OFFSET( range, rows, columns, [height], [width] )

Arguments

range
The starting range from which the offset will be applied.
rows
The number of rows to apply as the offset to the range. This can be a positive or negative number.
columns
The number of columns to apply as the offset to the range. This can be a positive or negative number.
height
Optional. It is the number of rows that you want the returned range to be. If this parameter is omitted, it is assumed to be the height of range.
width
Optional. It is the number of columns that you want the returned range to be. If this parameter is omitted, it is assumed to be the width of range.

Returns

The OFFSET function returns a reference.

Click link to see more example on how to use Offset in Excel.

 

Post navigation

Previous Post:

VLOOKUP without #N/A error in Excel

Next Post:

Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel XOR Function
  • OR function Examples in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IF with boolean logic in Excel
  • Not Equal To ‘<>‘ operator in Excel

Date Time

  • How to calculate quarter from date in Excel
  • How to calculate working days left in month in Excel
  • Sum through n months in Excel
  • How to calculate nth day of week in month in Excel
  • Convert Excel time to decimal hours in Excel

Grouping

  • Map inputs to arbitrary values in Excel
  • Running count group by n size in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel
  • Categorize text with keywords in Excel

General

  • Transpose: Switch ‘Rows to Columns’ or ‘Columns to Rows’ in Excel
  • Count cells that do not contain errors in Excel
  • Find, Select, Replace and Go To Special in Excel
  • How to calculate percentage discount in Excel
  • Cell References: Relative, Absolute and Mixed Referencing Examples
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning