answersLogoWhite

0

what do you mean by better? =a1 =$a1 =$a$1 and =a$1 all give the same result

what is affected is what happens when you drag them across or down. also when used in conditional formatting fixed and relative can be important

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Is A16 an absolute address in Excel?

No. A16 is a relative address. To be an absolute address it would be $A$16.


In spreadsheet does Microsoft Excel keep track of relative or absolute location?

Both. It depends on the address you use. A1 is a relative address. $A$1 is an absolute address.


What is an absolute address in spreadsheet?

An address that does not change in a formula when you move the formula to another cell. Relative Address = A1 Absolute Address = $A$1


What is the difference between absolute and relative memory address?

what is the difference between relative and absolute location? It could be the relationship that lets absolute memory relate to anything whiles relative memory is specific. When you remember something and its absolute then it means you can remember by any means so you have trained the brain to remember it by any means while relative memory is related by place or dimension. There is also such a thing as partial memory!


What is offset address?

An offset address is a relative address rather than an absolute address. You use offsets to refer to memory relative to an absolute address. For instance, array indices are implemented using offsets from the start address of the array, such that element 0 is at offset 0 and element 5 is at offset 5.


What is the absolute and relative of Switzerland?

Absolute and relative what?


Are peninsula's relative or absolute?

are peninsulas relative or absolute


Absolute and relative describe this?

Absolute and relative are really absolute value and other such.


What is the absolute and relative location of rome?

what is the relative and absolute location of rome


What is an absolute cell address in Excel?

An absolute cell address is a cell address that does not change when you move a formula from one cell to another. A relative address will change in the relation to the number of cells you move from the original cell that held the formula. You display absolute cell addresses by adding $ to the address:A1 is a relative address.$A$1 is an absolute address.


Is a street sign an absolute location?

No, a street sign is not an absolute location. It is a relative location marker used to provide guidance and information about the surrounding area.


What are inserted into the cell reference to make a cell reference absolute?

=B16 would be a relative reference =$B$16 would be an absolute reference. you can also highlight the cell reference and press F4 to add the "$" signs around the reference.