Information Functions

Who, What, Where

If you need to know if automatic calculation is on or off or the number of worksheets that are active, Excel can display the INFO.



System Information:

Current directory

=INFO("directory")

Available bytes of memory

=INFO("memavail")

Memory in use

=INFO("memused")

Total bytes of memory

=INFO("totmem")

Number of active worksheets

=INFO("numfile")

Cell currently in the top left of the window

=INFO("origin")

Operating system

=INFO("osversion")

Recalculation mode

=INFO("recalc")

Excel version

=INFO("release")

Name of system. (PC or Mac)

=INFO("system")

See all Topics