Contextures

Excel CELL and INFO functions

Examples and videos show how to use the Excel information functions, CELL and INFO

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.

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

Sum Functions

VLOOKUP Function

INDEX / MATCH Functions

COUNT / COUNTIF

INDIRECT Function

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search Contextures

Search Contextures Sites

Search Contextures Sites

 

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: November 4, 2016 7:18 PM
Contextures RSS Feed