INFO

Find about the current operating environment in Excel
Returns information about the current operating environment

Rational

Find about the current operating environment

Description

The Excel INFO function return specifications about the current operating environment of a user. The information about the current operating environment, include operating system version, Excel version, number of active worksheets, and so on.

Syntax

=INFO(type_text)

Parameters

type_text – the required information type (see below).

Return Value

Information about the current operating environment

Key Notes

The INFO function finds specifications about the current operating environment like operating system version, Excel version, number of active worksheets, and so on.

Following are a list of information that can be retrieved using the INFO function:

Type_textReturns
“directory”Path of current directory or folder.
“numfile”A number of worksheets in the open workbooks.
“origin”First visible cell at the upper left
“osversion”Version of Operating system
“recalc”Current recalculation mode
“release”Microsoft Excel version, as text.
“system”Operating System

Keep Reading Similar Functions:

Find information about a cell in Excel

CELL

The CELL function returns with information of a cell about the formatting, location, or contents. The type of information is based on the info_type parameter.

Read More »

SHEET

The SHEET function returns a sequence number of an Excel worksheet in a workbook of a given reference, worksheet, range name or table name.

Read More »
Find count of worksheets in a workbook in Excel

SHEETS

The SHEETS function finds the total number of sheets in a workbook. In the case of no argument the function returns total count of active workbook.

Read More »