INFO Function
Returns information about the current operating environment.
Category
Information
Available in
All versions, Microsoft 365
Returns
Text or a number about the Excel environment
Overview
INFO reports facts about Excel itself rather than about a cell: the version number, the operating system, how many worksheets are open, or whether calculation is automatic.
It's mostly used in shared templates — for example, warning people when calculation has been switched to manual.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| type_text | Yes | What you want to know, in quotes: "directory", "numfile", "origin", "osversion", "recalc", "release" or "system". |
Examples
Example 1 — What each type_text returns
Typical results in Excel for Windows. Your answers depend on your computer and version.
| A | B | |
|---|---|---|
| 1 | type_text | Example result |
| 2 | directory | C:\Users\Amara\Documents\ |
| 3 | numfile | 3 (worksheets in all open workbooks) |
| 4 | origin | $A:$A$1 (top-left visible cell) |
| 5 | osversion | Windows (64-bit) NT 10.00 |
| 6 | recalc | Automatic |
| 7 | release | 16.0 |
| 8 | system | pcdos (Windows) or mac |
Example 2 — Warn when calculation is manual
Put this near the top of a model so nobody trusts stale numbers.
Common mistakes
- Not every type works everywhere. Excel for the web and some Mac versions return #N/A or #VALUE! for some types, such as "directory".
Notes
- In our practice Sandbox, "directory" returns #N/A because the practice spreadsheet isn't saved in a folder.
- Related functions: CELL, SHEETS.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.