answersLogoWhite

0


Best Answer

A letter or letters to represent a column and a number to represent the row. The following are examples:

A5

C23

CF235

D8

IA4

H12300

Either (or both) of the letter or number can be preceded by a dollar sign ($) to make the reference absolute so that if the cell address is copied to another cell that part does not change - an example of this being useful is if a cell (or column or row) contains a conversion which needs to be applied to lots of different cells using a formula. Examples of absolute addresses are:

$A5 (this is a column address - if the reference is copied to another column, it will always point to column A)

A$5 (this is a row address - if the reference is copied to another row, it will always point to row 5)

$A$5 (this is a cell address - if the reference is copied to any other cell, it will always point to cell A5)

User Avatar

Wiki User

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

Wiki User

14y ago

Each cell in Excel has a unique address, like A1 or C345 or D48 or whatever. The letter refers to the column the cell is in and the row is referred to by the number.

This answer is:
User Avatar

User Avatar

Wiki User

6y ago

A cell address identifies a cell in a worksheet, using the column letter and row number as co-ordinates. Cell V67 is in column V, row 67 for example.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

A cell address directs to a certain cell by stating the column and row.

The cell address for the cell in fifth column and seventh row would be: E7

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

A cell address in a spreadsheet, such as Excel, identifies the location of the cell in the spreadsheet.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

A relative cell address would look something like C4, G15, or Z2345.

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

A cell address in Excel is the intersection of a row and column. The cell is identified by combining the column and row, as in A1. A1 means the cell is in column A and row 1.

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

A1 is the cell address of the cell in the first row and first column (top left-hand corner).

Type 123 in cell A1, type =A1 in B1, and 123 will appear in B1 on pressing enter.

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

A cell is a box on a worksheet into which data can be entered. A cell address identifies a particular cell. Each cell has a cell address.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is a cell address 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.


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


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 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.