answersLogoWhite

0

Most commonly, you address cells by their column and row intersection. For example, the cell with the address B4 is in the second (B) column and 4 rows down from the top of the sheet.

You can also address a cell by R1C1 format. In R1C1 cell B4 would be 4,2. A third way to address a cell is by giving that cell (or even a range of cells) a name.

Cell addresses can be Absolute, Relative or Mixed. The address $B$4 refers to only (absolute) cell B4 even when you drag or copy the formula that contains that address. There is a quick tutorial on this topic at http://cbt.brainstorminc.com/microsoft/help.php?file=excel9.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Why do they call a column a cell in Microsoft Excel?

A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.


A 1 in Microsoft Excel is?

A 1 in Microsoft Excel is a value. A1 is a cell in column A and row 1.


How do you time stamp a cell in Microsoft Excel?

You do not. Excel does not record the change date of an individual cell.


What is the home cell of Microsoft Excel?

A1


What is the name of the cell formed by the intersection of row 5 and column b of Microsoft Excel?

5B


How is an Excel spreadsheet structured?

Microsoft Excel is all about data and spreadsheets. Each cell in a spreadsheet has a unique cell address consisting of its column letter and row number. Each cell must have its own unique address so that you can refer to it when you create a formula.


Can a person complete calculations in Microsoft Excel 2003?

Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.


What is the column and row location of a cell in Microsoft Excel 2007?

Cell Reference


How can recognize cell in excel?

By looking on the cell address


How does a cell form in Microsoft Excel?

It is formed where a column and row intersect on a worksheet. This is what gives the cell its address, the column and row references. Where column C and row 7 intersect forms cell C7 for example.


What is the first cell address in an excel sheet?

A1 is the address of the first cell.


What affects the data in the cell on Microsoft Excel?

Formatting can change the look of a cell and its contents.