Excel 2010: INFO Function

Excel  INFO function is used for showing different kind of information in the spreadsheet. This function encapsulates different commands that shows; Path of directory, Active Worksheets, Origin of first cell, OS version, Recalculation mode, Current Excel Version, and Operating Environment. On writing this function it will automatically shows the list from which you can choose the specific argument to place in, according to the situation.

Launch Excel 2010 spreadsheet in which you want to add different information from INFO function. For instance, we will be using INFO function to show each information it encapsulates. The Information field content in the table can be found out instantly from INFO function.

The syntax of INFO functions is;


You can write the following text as argument (enclosed in double quotation) to find out the corresponding information;DIRECTORY, NUMFILE, ORIGIN, OSVERSION, RECALC, RELEASE, SYSTEM.

The easiest way of showing respective info is writing function and then selecting type from the list, as shown in the screenshot below.

list Excel 2010: INFO Function

We will be finding out the current path of folder and show it in the first row of INFO field which will show the full path.

directory 1

Now we will be filling in the INFO field for corresponding information being present in Information field. It currently shows 8 active Worksheets, the origin of top left cell as absolute reference, The OS version, Recalculation Mode as Automatic, Excel Version as 14.0, and Operating Environment as pcdos, as shown in the screenshot below.


You can also check out previously reviewed Excel function; Logical Functions, DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *