Ravindra BagaleCourses & study guides Track your progress

Excel CELL Function

By · Last updated:

Chala mitrano — today CELL. Ask Excel about a cell’s address, row, format, or file path.

Fictional sample data for learning. Format probes for Nashik print packs and Austin audit sheets. Uncertain: some info_type results vary by Excel build/locale.

Purpose

Return information about a cell — address, format, filename, color, and more — based on info_type.

Return value

Text or number depending on info_type.

Syntax

CELL(info_type, [reference])

Arguments

ArgumentRequired?Description
info_typeRequiredWhat to return: "address", "col", "color", "contents", "filename", "format", "parentheses", "prefix", "protect", "row", "type", "width".
referenceOptionalCell to inspect; if omitted, may use last changed cell — always pass a reference in class.

Version

Excel. CELL info_type codes vary slightly in LibreOffice/Sheets — verify on your build.

How to use — Why → What → How

Why: Audits need ‘where is this?’ without scrolling. CELL("address") and CELL("filename") answer fast. Format probes for Nashik print packs and Austin audit sheets. Uncertain: some info_type results vary by Excel build/locale.

What: Always pass reference explicitly. info_type is a text code; results for format/color can be locale- or build-specific — treat classroom format demos as illustrative. Info functions are the seatbelts of messy imports: they tell you what kind of value you have before you compute. Prefer the narrow test (ISNA, ISBLANK) when you need precision; use ISERROR or TYPE when you need a broad gate. Always verify blanks versus empty strings versus zeros — they look alike on screen and fail differently in formulas. For CELL and INFO, treat format/environment codes as build-specific and document ‘verify on your Excel’ in class notes.

How — numbered steps:

  1. Type =CELL("address",A2).
  2. Try "row" and "col".
  3. Avoid omitting reference in shared models.

Ravindra Bagale's Tip

Friends, after CELL, find one column or range in a real workbook this week where this lesson saves time.

Ravindra Bagale's Tip

Friends, sleep on CELL; rebuild example 1 tomorrow without looking.

Ravindra Bagale's Tip

Friends, say the business question in plain words before =CELL.

Ravindra Bagale's Tip

Friends, check a known case with a calculator before you trust a long CELL chain.

Ravindra Bagale's Tip

Friends, after you finish CELL, open yesterday’s real workbook and find one place this function would have saved ten minutes.

Ravindra Bagale's Tip

Friends, treat blank, zero, and empty text as three different animals when you use CELL.

Download practice file: practice-cell.xlsx (includes sheet About this data, practice sheets, and Answers).

Worked examples

1) Address

Nashik.

X
10
Formula: =CELL("address",A2)

Result: $A$2

What it means: Absolute address text.

2) Row

Row.

X
10
Formula: =CELL("row",A2)

Result: 2

What it means: Row number.

3) Col

Col.

X
10
Formula: =CELL("col",A2)

Result: 1

What it means: Column number.

4) Austin filename

Path.

X
1
Formula: =CELL("filename",A2)

Result: (path)

What it means: Full path+sheet if saved — illustrative.

5) Type code

b/l/v.

X
hi
Formula: =CELL("type",A2)

Result: l

What it means: l=label/text (classroom).

6) Contents

Value.

X
42
Formula: =CELL("contents",A2)

Result: 42

What it means: Same as the value.

About this data. Small demo rows for learning. Real sheets are longer; the same formula pattern scales when columns are clean.

Common errors and fixes

Omit reference — Volatile last-cell behaviour. Fix: Always pass A2 etc.
format/color — Build-specific. Fix: Verify locally.
Unsaved file — filename may be blank. Fix: Save first.

Notes and tips

  • Revisit the CELL errors table after the quiz.
  • Build example 1 from memory on a blank sheet.
  • Check number vs text if a result looks wrong.
  • Teach one tip in Marathi or Hindi this week.
  • Keep currency symbols consistent inside one report column (practice mixes ₹ $ £ €).
  • Drill: return address and row for A2 from memory.
  • CELL vs INFO: cell-level metadata versus environment-level metadata.
  • Fictional sample data only — names and amounts are for learning.
  • Print the CELL revision card for one week of real worksheets.
  • Ask juniors to predict before they press Enter.
  • Track your top mistake with this function monthly.
  • Format probes for Nashik print packs and Austin audit sheets. Uncertain: some info_type results vary by Excel build/locale.
  • Interview tip: explain the business question before the formula.
  • Classroom drill: invent three brand-new formulas from your city without the page open.
  • If a result looks wrong, check blanks vs zeros before rewriting.
  • When Excel versions differ, note the LibreOffice / Sheets fallback in a cell comment.
  • Prefer clear ranges over whole-column refs on huge sheets if speed matters.
  • Document units (₹, kg, days) in the header so totals stay honest.
  • Distinguish blank, "", 0, and text "0" before you trust any IS* result.
  • Prefer IFNA for lookup misses and IFERROR for broad display substitutes.
  • TYPE codes: 1 number, 2 text, 4 logical, 16 error, 64 array — card them.
  • ERROR.TYPE: 2=#DIV/0!, 7=#N/A — card the rest for audits.
  • Always pass a reference to CELL; omitting it is volatile and confusing in shared books.
  • INFO and some CELL format codes vary by host — flag uncertain in lesson notes.
  • SHEETS includes hidden sheets; unhide before trusting a QA count.
  • Fictional sample data only — never paste real customer sheets into class files.
  • Teach one junior blank-vs-zero in Marathi or Hindi this week.
  • Print the revision card and stick it near the monitor for one week of real worksheets.

In real work

Drill: return address and row for A2 from memory. Format probes for Nashik print packs and Austin audit sheets. Uncertain: some info_type results vary by Excel build/locale. Classroom drill: write three brand-new CELL formulas on a blank sheet using names from your own city — if you can invent them without the page open, you own the skill. Then break one formula on purpose and watch the error; recovering from that break is half of interview readiness. Always verify with a known case before trusting a long chain. Keep a personal notebook of the one mistake you make most often with this function; review it monthly. The IS* family returns booleans you can nest in IF; IFERROR/IFNA are the modern display wrappers when you only need a substitute value. TYPE collapses several tests into codes 1/2/4/16/64. N coerces logicals for SUMPRODUCT-era maths but does not parse digit-text — that is VALUE. NA() forces chart gaps; ERROR.TYPE triage codes let support count #DIV/0! separately from #N/A. SHEET/SHEETS index and count tabs including hidden ones — QA asserts love SHEETS()=n gates.

How it compares

CELL vs INFO: cell-level metadata versus environment-level metadata.

Interview corner

address?
$A$2 text.
Omit ref?
Avoid.
filename?
Needs saved file.

INFO, FORMULATEXT, SHEET

Practice tasks (10)

  1. Task 1. Address of A2.
    Addr.
  2. Task 2. Row of A2.
    Row.
  3. Task 3. Col of A2.
    Col.
  4. Task 4. Type of text.
    l.
  5. Task 5. Filename probe.
    Path.
  6. Task 6. Interview.
    Talk.
  7. Task 7. Teach.
    Teach.
  8. Task 8. Always pass ref.
    Habit.
  9. Task 9. Fill.
    Fill.
  10. Task 10. Tease INFO.
    Related.

Quick quiz

Q1. CELL("row",A2)?
Q2. CELL("col",A2)?
Q3. Address style?
Q4. Omit reference?
Q5. filename needs?

Answers: Q1=2, Q2=1, Q3=$A$2 text, Q4=Risky, Q5=Saved workbook (check after you try).

Revision card

Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.

Revision card: CELL
CELL revision card