Cell in Excel: Meaning, References, and How It Works

How-to basics · Updated November 22, 2026

A cell in Microsoft Excel is one box in a worksheet, formed where a row and a column meet. It is the basic place to enter or display a value, text, or formula; for example, the box at column B and row 3 is cell B3.

What a cell is

An Excel worksheet is a grid of columns and rows. Columns are labeled with letters, beginning with A, while rows are labeled with numbers, beginning with 1. Each crossing of one column and one row identifies a single cell. A worksheet is therefore made up of individual cells, even when many of them are empty.

Cells are the building blocks of a spreadsheet. A budget might use one cell for a category name, another for a planned amount, and another for the actual amount. A list of contacts could put each person’s name, phone number, and email address in separate cells. Organizing information this way makes it easier to sort, calculate, format, and analyze.

Excel for Microsoft 365 on Windows allows up to 1,048,576 rows and 16,384 columns on a worksheet; the final column is XFD. A cell can be part of a small personal list or a very large data table, but the grid’s maximum does not mean every workbook can efficiently use billions of populated cells. Memory, file size, and calculation workload still matter.

How cell addresses work

A cell address, also called a cell reference, combines the column letter and row number. The letter comes first: A1 means column A, row 1; D12 means column D, row 12. The address identifies a cell on the current worksheet unless a formula specifies another sheet or workbook.

When you select a cell, its address normally appears in the Name Box to the left of the formula bar. You can click that box, type an address such as C25, and press Enter to move directly to that cell. The formula bar shows the selected cell’s contents, which can be useful when the cell is too narrow to display everything.

A range is a group of cells, usually described by its top-left and bottom-right addresses separated by a colon. For example, A1:A5 means five cells down column A, while A1:C5 means a rectangular block three columns wide and five rows tall. A single address such as B3 refers to one cell; a range describes multiple cells. Excel also uses named ranges, which let a user assign a readable name to a cell or range.

What a cell can contain

A cell can contain a number, text, a date or time, a formula, or an error value. Excel often recognizes entries automatically. For instance, typing a date in a familiar date format may cause Excel to store it as a date serial value and display it as a calendar date. A value that looks like a number can instead be treated as text, especially if it has a leading apostrophe or is entered into a cell formatted as Text.

Common contents include:

  • Numbers: amounts, counts, measurements, or percentages.
  • Text: labels, names, product codes, or notes.
  • Dates and times: entries Excel can use in date calculations when recognized as dates.
  • Formulas: instructions beginning with an equals sign that calculate a result.
  • Errors: indicators such as #DIV/0! or #N/A that report a calculation or lookup issue.

A cell’s displayed appearance is not always the same as its underlying content. A cell might show $25.00 while holding the number 25 with a currency number format. A date can likewise be displayed in different styles without changing the stored date value. Clicking the cell and checking the formula bar can help distinguish the underlying entry from its presentation.

How formulas use cells

Formulas use cell references to calculate with values elsewhere in a worksheet. They begin with an equals sign and can contain operators, references, constants, and functions. This makes a spreadsheet responsive: when a referenced value changes, Excel can recalculate the formula result.

With a unit price of 12.50 in B2 and a quantity of 4 in C2, enter this formula in D2 to calculate the line total: =B2*C2. The result is 50.00. The formula refers to the two input cells rather than repeating the values inside the calculation, so changing the price or quantity can update the total.

Functions perform common operations on cells or ranges. With the values 10, 15, 20, 5, and 10 in B2:B6, enter this formula in B7 to add them: =SUM(B2:B6). The result is 60. The colon indicates that the function uses the entire range from B2 through B6.

Formulas can also use text, comparisons, and functions that test conditions or find information. A formula may show a result in its cell while its full calculation remains visible in the formula bar. If Excel displays the formula itself instead of its result, the cell may be formatted as Text, or the worksheet may be displaying formulas. Changing the entry to a suitable format and re-entering it, or toggling Show Formulas from the Formulas tab, can help diagnose the issue.

Relative and fixed cell references

By default, Excel uses relative references in many formulas. If a formula in D2 refers to B2, copying it one row down usually adjusts the reference to B3. That behavior is useful when applying the same calculation to many records. For example, a line-total formula can be copied down a sales list so each row uses its own price and quantity cells.

When a reference must remain fixed as a formula is copied, use dollar signs to make it absolute. In a formula, $A$1 fixes both the column and row. A$1 fixes row 1 but allows the column to change; $A1 fixes column A but allows the row to change. Mixed references are useful for tables of calculations where formulas move in one direction but should keep one row or column constant.

Excel also supports references to other worksheets. An example reference such as Sheet2!A1 means cell A1 on a worksheet named Sheet2. If a sheet name contains spaces, Excel surrounds it with single quotation marks, as in ‘Quarter Summary’!A1. When building a formula, clicking a cell on another sheet can insert the reference instead of requiring you to type it manually.

Cell formatting and display

Formatting changes how a cell looks, not necessarily the value it contains. The Home tab includes common controls for number formats, font, alignment, borders, and fill color. For example, applying a percentage format can display 0.25 as 25%, while a currency format can display 25 as a monetary amount. The underlying numeric value remains available for calculations.

Formatting can clarify a worksheet when used consistently. Headings can be bold, totals can have a top border, and dates can use a readable date format. However, formatting alone does not make a value into a different kind of data. If a number is stored as text, applying a number format may not make it behave like a numeric value in calculations. In that case, convert the content to a number as well as adjusting its display.

Text that is longer than a cell’s width may appear to spill into an empty neighboring cell, or be visually cut off when the neighboring cell has content. The full entry is still in the cell. You can widen the column, wrap text, or use an appropriate alignment setting to make it visible. Merging cells is another option for some headings, but merged cells can complicate sorting, filtering, and selecting ranges; Center Across Selection is often a more flexible alternative for a centered heading.

Selecting and editing cells

Click a cell to make it active. A border marks the active cell, and typing replaces its existing content; press Enter to commit the entry. To edit without replacing everything, double-click the cell or select it and edit in the formula bar. Pressing F2 on Windows also edits the active cell. On many Mac keyboards, F2 may require the Fn key, depending on keyboard settings.

To select a range, drag across cells or select the first cell, hold Shift, and select the last. You can also type a range address in the Name Box. To select nonadjacent cells, hold Ctrl while clicking on Windows; on Mac, use Command while clicking. The precise selection behavior can vary with the app and keyboard settings, but these are common desktop shortcuts.

Copying and filling are useful for repeating values, formats, or formulas. The fill handle is the small square at the lower-right corner of a selected cell or range. Dragging it can extend a sequence or copy a formula, with relative references adjusting as described above. When the result is unexpected, inspect the copied formula and its references rather than assuming Excel changed the source value.

Common cell problems and misconceptions

A frequent source of confusion is that a cell’s visible contents do not tell the whole story. A cell can look blank but contain spaces, a formula that returns an empty string, or formatting that makes its content hard to see. Conversely, a cell can appear to contain a value that is actually displayed from a formula. The formula bar and the Home tab’s number format controls help reveal these differences.

Another common issue is a number stored as text. This can interfere with arithmetic, sorting, or comparisons. Excel may show a warning indicator for some entries. Depending on the data, possible fixes include using Convert to Number from the warning menu, changing the cell format and re-entering the value, or using a suitable conversion method. Check identifiers such as postal codes carefully: they may look numeric but should remain text so leading zeros are preserved.

Errors such as #DIV/0! usually signal a problem in a formula or its inputs, not a damaged cell. #DIV/0! occurs when a formula divides by zero or by an empty cell treated as zero. #N/A often means a requested value is unavailable, particularly in a lookup. Read the formula, check the referenced cells, and confirm that the input data has the expected type and spelling before changing the calculation.

Frequently Asked Questions

What is a cell in Excel in simple terms?
A cell is one box in an Excel worksheet where a row and column intersect. It can hold a value, text, a formula, or another entry.

How do I find a cell’s address?
Select the cell and read its address in the Name Box, located beside the formula bar. The column letter followed by the row number forms the address, such as E7.

What is the difference between a cell and a range?
A cell is one location, such as A1. A range is one or more cells, such as A1:A10 or A1:C10, and is often used as the input to a formula or formatting action.

Can a cell contain both text and a formula?
A cell holds one entry at a time. A formula can combine text and values in its result, but the cell’s entry is still the formula; it does not separately store a second independent text entry.

Why does Excel show a formula instead of its answer?
The cell may be formatted as Text, or Show Formulas may be turned on for the worksheet. Check the cell format and the Formulas tab, then correct the setting and re-enter the formula if necessary.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.