In Microsoft Excel, a cell is the box where a row and a column meet, and it is the basic place for entering, storing, calculating, and displaying information. Each cell has an address, such as A1, and can contain a value, text, a date, or a formula.
What an Excel cell is
An Excel worksheet is a grid made of rows and columns. Rows run horizontally and are numbered 1, 2, 3, and so on; columns run vertically and are labeled A, B, C, continuing through combinations such as AA and AB. A cell is one position in that grid. The cell at the intersection of column B and row 4 is B4.
Cells are the building blocks of a worksheet. A table of expenses might use one cell for each date, another for each expense description, and another for each amount. A cell can be empty, but it still exists at its grid position and can be selected, formatted, referenced, or filled later. In current desktop versions of Excel, a worksheet has 1,048,576 rows and 16,384 columns, with the last column named XFD.
The selected cell is called the active cell. Excel marks it with a border, and its address normally appears in the Name Box near the formula bar. When you type, the entry goes into the active cell unless you are editing a different area, such as the formula bar.
How cell addresses work
An address identifies a cell by its column letter followed by its row number. For example, C7 means column C, row 7. The order matters: 7C is not a standard cell address. Excel displays the active cell address in the Name Box, and you can use that box to go directly to a location by typing an address and pressing Enter.
Cell addresses are also called references when they appear in formulas. A reference lets a formula use the value stored in another cell. For instance, a formula can refer to B2 rather than repeat the number currently in B2. If that number changes, Excel can recalculate the formula using the updated value.
Excel can also refer to a cell on another worksheet. A reference to a sheet named Sales and cell B2 is written with the sheet name, an exclamation mark, and the cell address; sheet names containing spaces are enclosed in single quotation marks. Workbook references can also point to another file, though those links may need updating if the other file is moved or renamed.
What a cell can contain
A cell holds one current entry at a time. Common entries include text labels, numeric values, dates, times, logical values such as TRUE or FALSE, and formulas. A cell can also be left empty. Although a formula may display a result that looks like a number or a date, the formula itself remains the cell’s underlying entry.
- Text: Names, notes, product codes, and labels such as Department or Total. Text that looks numeric, such as a postal code with a leading zero, may need to be stored as text if the zero must remain.
- Numbers: Quantities, prices, scores, and other values used in calculations. Excel may interpret an entry as a number even if it is displayed with currency or percentage formatting.
- Dates and times: Excel generally stores these as numeric values and displays them according to the chosen format. This allows dates and times to be used in calculations as well as shown in a readable style.
- Formulas: Expressions beginning with an equals sign, such as a calculation or a function. The cell normally displays the calculated result, while the formula bar shows the formula when that cell is selected.
Excel guesses how to interpret many entries. For example, typing 12/5 may be interpreted as a date, depending on regional settings and the cell format. If Excel turns an entry into something unexpected, check the formula bar and the number format rather than assuming the original text is still stored unchanged.
Entering and editing cell contents
To enter information, select a cell, type the value or formula, and press Enter. Pressing Tab usually commits the entry and moves the selection one cell to the right. You can also click the formula bar and type there; this is useful for editing a long formula that is difficult to see inside the cell.
To change an existing entry, select its cell and start typing to replace the contents, or edit it without replacing everything. On Windows, F2 edits the active cell; double-clicking a cell also places the insertion point in its contents. On a Mac, Command+U is commonly used to edit the active cell, and the function-key behavior can depend on the keyboard settings. You can also click in the formula bar on either platform.
To remove a cell’s contents without removing its formatting, select it and press Delete on Windows. On a Mac keyboard, the equivalent forward-delete key may be labeled Delete or require Fn+Delete, depending on the keyboard. The Home tab’s Clear menu provides options such as Clear Contents and Clear Formats. Deleting a cell through the worksheet’s Delete Cells command is different: Excel asks whether to shift surrounding cells, which can change the layout and affect references.
For a large sheet, the Name Box is a quick way to select a cell or range: type C100, for example, and press Enter. You can also select a range by entering its endpoints, such as A2:A20. This is more precise than scrolling to a distant row, especially in worksheets with thousands of records.
Cells in formulas and calculations
A formula can combine cell references, arithmetic operators, and functions. Suppose a small order list has a quantity in B2 and a unit price in C2. With 3 in B2 and 12.50 in C2, the cell D2 can calculate the line total using =B2*C2. The result is 37.5, which could be displayed as 37.50 by applying a two-decimal number format. This example assumes the quantity and unit price are in those exact cells.
When a formula is copied to another cell, ordinary references are relative: Excel adjusts them to match the new position. Copying the formula from D2 to D3 changes B2 and C2 to B3 and C3. This behavior is useful for repeating calculations down a list. If a reference must stay fixed when copied, add dollar signs to the column, row, or both. For example, $F$1 is an absolute reference to that same cell when a formula is copied.
Formulas can also use functions to summarize ranges. If sales amounts are in B2 through B4, the formula =SUM(B2:B4) adds those three cells. The assumed layout is amounts in B2:B4; if they are 10, 15, and 5, the result is 30. The colon means the range includes the cells from the first endpoint through the second. If a cell in the range is changed, Excel recalculates the result under normal automatic calculation settings.
Formatting changes appearance, not the underlying value
Formatting controls how a cell looks: number of decimal places, currency symbols, date style, font, fill color, borders, alignment, and more. It usually does not change the stored value. For example, a value of 0.25 can be displayed as 25% with percentage formatting, while the underlying numeric value remains 0.25. A currency format can add a symbol and decimal places without turning a number into text.
To change a number format, select the cell and use the Number Format controls on the Home tab, or open the Format Cells dialog with Ctrl+1 on Windows. On a Mac, Command+1 opens Format Cells. Choose a format that matches the meaning of the value: dates should be dates, percentages should be percentages, and identifiers such as account codes may need text treatment to preserve leading zeros.
Formatting can make a sheet easier to read, but it can also disguise differences. Two cells may look the same while holding different values, such as 1.2 and 1.20, or a number and text that resembles a number. When a calculation behaves unexpectedly, inspect the formula bar and the cell’s format. Do not rely only on what is visible in the grid.
Cells, ranges, and tables
A range is a group of one or more cells. A2:A10 describes a vertical range in column A; A2:C10 describes a rectangular block across columns A through C and rows 2 through 10. Ranges are used in formulas, charts, sorting, copying, and formatting. Selecting a range lets you apply a change to several cells at once.
An Excel table is a structured collection of cells with headers and built-in sorting and filtering. To make one, select the data and choose Home > Format as Table, then confirm whether the data has headers. A table is still made of ordinary worksheet cells, but it adds useful behavior: formulas can fill down a calculated column, and formulas can refer to named columns rather than only addresses.
Cells can also be merged, but merging combines the display area of multiple cells and retains only the content from the upper-left cell. It may make headings look centered across columns, but merged cells can complicate sorting, filtering, copying, and selecting ranges. Center Across Selection is an alternative for some heading layouts because it changes alignment without merging the cells.
Common cell problems and what to check
If a formula appears as text instead of calculating, check whether the cell is formatted as Text, whether the formula begins with an apostrophe, or whether Show Formulas is turned on. Changing a Text-formatted cell to General may not immediately convert an existing entry; re-entering the formula can be necessary. Show Formulas can be toggled from the Formulas tab, and its Windows shortcut is Ctrl+grave accent; keyboard layouts may place that key differently.
If a number displays as a series of hash marks, the column may simply be too narrow to show the formatted value. Widen the column or choose a shorter number format. Hash marks are not, by themselves, evidence that the value has been deleted. A formula error such as #DIV/0! has a different cause: it indicates division by zero or by a blank cell being treated as zero.
If a total seems wrong, inspect the referenced cells and the formula itself. Check for numbers stored as text, an incomplete range, hidden rows that were included in a regular SUM, or a formula copied with a reference that shifted unexpectedly. Also verify that the calculation mode is Automatic under Formulas > Calculation Options if values are not updating as expected.
Finally, distinguish an empty cell from a cell containing a formula that returns an empty text string. Both can look blank, but formulas, counts, and tests for blanks may treat them differently. Selecting the cell and checking the formula bar is a quick way to see whether it is truly empty.
Frequently Asked Questions
What is a cell in Excel in simple terms?
A cell is one box in the worksheet grid, located where a particular row and column meet. It is where you enter or display a piece of information, such as a label, number, date, or formula.
How do I find a cell’s address?
Select the cell and look at the Name Box near the formula bar. It displays an address such as D8. You can also type an address into the Name Box and press Enter to go directly to that cell.
What is the difference between a cell and a range?
A cell is one grid position, such as B3. A range is a selection of one or more cells, such as B3:B12. Ranges are commonly used as inputs to formulas and as the area for sorting, formatting, or charting.
Can a cell contain both text and a formula?
A cell has one current entry, so it cannot hold a separate text value and a separate formula at the same time. A formula can, however, combine text with a calculated result, and a cell can display text produced by a formula.
Does changing a cell’s format change its value?
Usually, no. Formatting changes how the value is displayed, such as showing 0.25 as 25%. To change the underlying value, edit the cell’s contents or use a formula; changing the number format alone is not a calculation.
Related
- Excel Named Range Scope Greyed Out? Causes and Fixes
- Excel Named Range Rules: Names, Scope, and Limits
- Excel Named Range Scope: Workbook vs. Worksheet Names
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Custom Header in Microsoft Word DocumentsTo add a custom header in Microsoft Word, open the document, choose Insert > Header > Edit Header,…
- Conditional Formatting in Word: What Works and What Doesn’tMicrosoft Word does not have Excel-style conditional formatting that automatically changes a cell’s color or font according to…
- Insert an Electronic Signature in WordTo insert an electronic signature in Word, add a picture of your handwritten signature, draw one with the…
- Excel Table Color Not Changing? Common Causes and FixesIf an Excel table’s color is not changing, select a cell inside the table, open Table Design, and…
- Outlook Email Signature: How to Create and Set It UpTo create an email signature in Outlook, open the signature settings for your version, write and format your…
- Excel Column Headings on Each Page: How to Repeat ThemTo print a worksheet’s header row on every page in Excel for Microsoft 365 on Windows, choose Page…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.