SheetName function

SHEETNAME() Description

The SHEETNAME() function returns the sheet name by serial number.

Main Features Functions SHEETNAME

Syntax:

=SHEETNAME(Seq)

Parameters:

• Seq: The sequential number of the sheet in the current workbook. If 0 (zero) is specified, the function returns a list of all sheets. If the parameter is missing, the name of the current sheet is returned.

Example Usage

The SHEETNAME() function is easy to use. You just need to specify the sheet number and Excel (Calc) will automatically return its name:

=SHEETNAME(Seq)

We will have the following result:

This example uses the following values:

• Seq: A5 - Sheet number (2) .

Download extension

You can use the function SHEETNAME() by installing the extension YLC Utilities .

After that, this function will be available in all files that will be opened in Excel (LibreOffice Calc) .