answersLogoWhite

0

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

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