Skip to content


Excel Function – ADDRESS()

  • ilyar126 

Description To calculate the address of a cell in an worksheet. You can use this function to refer cells in other worksheets as well. Syntax ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]) row_num: specifies the row number col_num: specifies the column number [abs_num]: optional, which row or column to be fixed (absolute) with $ or relative [a1]: optional, it specifies A1 or R1C1 reference style if set to False or left blank.… Read More »Excel Function – ADDRESS()