Information
All versions
◉ 36 views
Volatile
=INFO()
Returns information about the current operating environment.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016Excel for iPadExcel for iPhoneExcel for Android tabletsExcel for Android phones
=INFO(type_text)
Hover argument names in the table for details.
Output typeMixed
Popularity5 / 100
VolatileYes
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =INFO() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
type_text |
Text | Required | Text that specifies what type of information you want returned. "directory" = Path of the current directory or folder specified in the Excel option, At startup, open all files in (Select File > Options > Advanced > General).; "numfile" = Number of worksheets in the open workbooks.; "origin" = Returns the absolute cell reference of the top and leftmost cell visible in the window, based on the current scrolling position, as text prepended with "$A:". This value is intended for for Lotus 1-2-3 release 3.x compatibility. The actual value returned depends on the current reference style setting. Using D9 as an example, the return value would be:A1 reference style "$A:$D$9".R1C1 reference style "$A:R9C4"; "osversion" = Current operating system version, as text.; "recalc" = Current recalculation mode; returns "Automatic" or "Manual".; "release" = Version of Microsoft Excel, as text.; "system" = Name of the operating environment: Macintosh = "mac" Windows = "pcdos". |
▣ Examples
Number of worksheets in open workbooks
=INFO("numfile")
Result:
a number indicating how many sheets are in the currently open workbooks
Recalculation mode for the workbook.
=INFO("recalc")
Result:
"Automatic" or "Manual" depending on the current state of your calculation options.
✦ Tips
- In previous versions of Microsoft Excel, the "memavail", "memused", and "totmem" type_text values, returned memory information. These type_text values are no longer supported and now return a #N/A error value.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!