Exceljet

Quick, clean, and to the point

Excel INFO Function

Excel INFO function
Summary 

The Excel INFO function returns information about the current environment, including platform, Excel version, number of worksheets in a workbook, and so on. To use the INFO function, supply the type of information you want as text. There are seven types of information available, summarized in the table below.

Purpose 
Get information about current environment
Return value 
The information requested
Syntax 
=INFO (type_text)
Arguments 
  • type_text - The information type to return as text.
Usage notes 

The INFO function can retrieve information about the current environment, including OS, OS version, Excel version, and so on. To use the INFO function, supply the type of information you want as text. There are seven types of information you can request:

Type Information
directory Path of the current directory or folder
numfile Number of active worksheets in open workbooks
origin First visible cell at upper left
osversion Operating system version
recalc Recalculation mode
release Excel version
system Operating system name

Note: INFO is a volatile function and will update each time a change is made to the worksheet.