Contextures

Excel CELL and INFO functions

Examples and videos show how to use the Excel information functions, CELL and INFO. Also see the ADDRESS Function examples.

Introduction

The CELL function can return information about cell formatting, contents and location.

The INFO function can show details such as Excel version, recalculation mode and number of worksheets in all open workbooks.

To return a cell address as text, based on a row and column number, go to the ADDRESS Function page.

Video: Use the CELL Function

Use the CELL function in Excel to get details about the cell format, location and contents. The CELL function can show details such as column width, worksheet name and number format.

Watch this short videos to see examples for using the CELL function.

Video: Use the INFO Function

Use the INFO function in Excel to get details about the current operating environment. The INFO function can show details such as Excel version, recalculation mode and number of worksheets in all open workbooks.

Watch this short videos to see examples for using the INFO function.

Download the Sample Files

  1. Download the CELL function sample file. The file is zipped, and is in xlsx file format
  2. Download the INFO function sample file. The file is zipped, and is in xlsx file format

Function Tutorials

ADDRESS Function

VLOOKUP Function

INDEX / MATCH Functions

COUNT / COUNTIF

INDIRECT Function

Don't Miss Our Excel Tips

Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.

Get weekly Excel tips from Debra

 

 

Get weekly Excel tips from Debra

 

 

Excel Tools Add-in

 

Free Pivot Table Tools

 

 

excel chart tools by peltier tech

 

 

 

Pivot Power Premium

 

Excel Data Entry Popup List

 

Excel UserForms for Data Entry

 

Last updated: October 25, 2018 10:34 AM
Contextures RSS Feed