answersLogoWhite

0


Best Answer

K23 is a relative reference. For example:

=K23*10

User Avatar

Wiki User

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

Wiki User

9y ago

$K$23. The $ indicates that the next element is "absolute", and should not be modified as a relative location when you drag or copy cells.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you write K23 as a absolute reference?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you write cell K23 as a mixed reference with the row varying?

The following will lock the column but not the row, so it is a mixed reference: $K23


A cell reference with a fixed position in the worksheet that does not automatically change based on its location?

An absolute reference. When the formula is copied, the absolute reference will not change.An absolute reference. When the formula is copied, the absolute reference will not change.An absolute reference. When the formula is copied, the absolute reference will not change.An absolute reference. When the formula is copied, the absolute reference will not change.An absolute reference. When the formula is copied, the absolute reference will not change.An absolute reference. When the formula is copied, the absolute reference will not change.An absolute reference. When the formula is copied, the absolute reference will not change.An absolute reference. When the formula is copied, the absolute reference will not change.An absolute reference. When the formula is copied, the absolute reference will not change.An absolute reference. When the formula is copied, the absolute reference will not change.An absolute reference. When the formula is copied, the absolute reference will not change.


What formula displays A2 times E5 E5 being an absolute cell reference?

Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.


What is f61 an absolute reference?

$f$61 is an absolute reference.


F61 is a relative reference or absolute?

F61 is a relative reference in Excel. $F$61 is an absolute reference.


A10 is an example of absolute reference?

No. A10 is a relative reference. $A$10 would be an absolute reference. As a relative reference, it will change when a formula is copied. An absolute reference will not changed in a formula when it is copied.


Is a1 an example fo an absolute reference?

No. a1 is a relative reference. $a$1 is an absolute reference.


Does Copying a formula with an absolute reference does not change the cell reference?

An absolute cell reference will not change when it is copied.


What is an example of an absolute cell reference?

Relative cell reference: A2 Absolute cell reference: $A$2


What is it called when a cell reference that refers to cells by their fixed position in a worksheet and which remain the same when the formula is copied is referred to as an?

An absolute reference. An absolute cell reference.


Is c6 an absolute or a rellative cell reference?

C6 is a relative reference. $C$6 would be an absolute reference. As a relative reference, it will change when a formula is copied. An absolute reference will not changed in a formula when it is copied.


Is B17 is a relative reference and B17 is an absolute reference.?

B17 is a relative reference. $B$17 is an absolute reference. See the related question below.