Home › OFFSET

OFFSET in every language

Lookup and referenceLegacyLast verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishOFFSETOFFSET(reference, rows, cols, [height], [width])——
GermanBEREICH.VERSCHIEBENBEREICH.VERSCHIEBEN(Bezug; Zeilen; Spalten; [Höhe]; [Breite])VERSCHIEBUNGBEREICH.VERSCHIEBEN
FrenchDECALERDECALER(réf; lignes; colonnes; [hauteur]; [largeur])DECALERDECALER
SpanishDESREFDESREF(ref; filas; columnas; [alto]; [ancho])DESREFDESREF
Portuguese (Brazil)DESLOCDESLOC(ref; lins; cols; [altura]; [largura])DESLOCDESLOC
DutchVERSCHUIVINGVERSCHUIVING(verw; rijen; kolommen; [hoogte]; [breedte])VERSCHUIVINGVERSCHUIVING
ItalianSCARTOSCARTO(rif; righe; colonne; [altezza]; [largh])SCARTOSCARTO

Names and arguments from Microsoft Support; the LibreOffice and Google Sheets columns are those products' own localized names. Array-constant separators and localized error values are not yet covered.

Translate a formula with OFFSET