1. Home
  2. Computing & Technology
  3. Spreadsheets

Entering Data in Excel

By Ted French, About.com

4 of 8

Cells and Cell References in Excel

The cell reference of the highlighted cellis B2

The cell reference of the highlighted cell is B2

© Ted French

Cells and cell references in Excel

Cell Facts

  • Data is stored in cells in an Excel spreadsheet.
  • Each small rectangle in a spreadsheet is a cell.
  • A cell is the intersection point of a column and a row.

Column and Row Facts

  • Columns run vertically in a spreadsheet and are identified by a letter.
  • Rows run horizontally and are identified by a number.
  • There are 65,536 rows, 256 columns, and over 16 million cells in a worksheet.

Cell Reference Facts

  • To keep track of all these cells, each cell has a cell reference or address.
  • A cell reference is a combination of the column letter and the row number.
  • The active cell reference is shown in the name box above column A.

Return to Index page

Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel 101
  5. Excel Cell References - Cell References in Excel Spreadsheets - Use Cell References in Excel

©2009 About.com, a part of The New York Times Company.

All rights reserved.