answersLogoWhite

0


Best Answer

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

14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

13y ago

A system used by Excel and many other spreadsheet programs that allows users that have large spreadsheets to locate cells easily. Letters line the top of the spreadsheet and label horizontal content. Numbers allign the left side of your spreadsheet and label vertical content. This makes it easier for you to locate your content, simply by entering your "Cell Address" in the white bar at the top of the spreadsheet.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

A cell address identifies the intersection of a column and a row (e.g. A1).

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

Its column and row intersection number forms the address of the cell. So the cell where column B meets row 10 is cell B10 for example.

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

A cell address is a column designator and a row designator. Columns are designated by the alphabetic characters and a row is a number. There cell A3 would be the third row in column A.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

It can be called a cell address or a cell reference.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the address of cell in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
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


What is the first cell address in an excel sheet?

A1 is the address of the first cell.


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 affects the data in the cell on Microsoft Excel?

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