answersLogoWhite

0

As you are typing in a cell reference, press the F4 key.

As you are typing in a cell reference, press the F4 key.

As you are typing in a cell reference, press the F4 key.

As you are typing in a cell reference, press the F4 key.

As you are typing in a cell reference, press the F4 key.

As you are typing in a cell reference, press the F4 key.

As you are typing in a cell reference, press the F4 key.

As you are typing in a cell reference, press the F4 key.

As you are typing in a cell reference, press the F4 key.

As you are typing in a cell reference, press the F4 key.

As you are typing in a cell reference, press the F4 key.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

This key allows one to make the cell absolute?

The F4 key.


What function key will change a cell reference formula value to an absolute value in Excel 2010?

The F4 key can be used as you are typing in the cell reference in order to change it to a different reference type.


Why use F4 in a spreadsheet?

While typing in a formula the F4 key can be used to change a cell reference to being relative, absolute and mixed. This makes it slightly quicker to do.


Use this function key to add dollar symbols in front of row or column numbers to make the addresses absolute references?

The F4 key, when you are typing in the reference to the cell.


Which keyboard key when pressed rotates through relative mixed and absolute cell references in an Excel worksheet?

The F4 key does that, if you press it while typing in the cell reference.


What is the function key used in Excel to repeat the last action when inserting columns and rows?

Nope . It is F4


What is the shortcut in putting dollar sign in an excel formula?

For making mixed and absolute cells in formulas, press the F4 key while typing the cell reference to add dollar signs. Pressing F4 several times will cycle through the various forms of mixed, absolute and relative referencing.


Hotkey redo Excel?

You can use the Ctrl - Y key combination, or you can use the F4 key.You can use the Ctrl - Y key combination, or you can use the F4 key.You can use the Ctrl - Y key combination, or you can use the F4 key.You can use the Ctrl - Y key combination, or you can use the F4 key.You can use the Ctrl - Y key combination, or you can use the F4 key.You can use the Ctrl - Y key combination, or you can use the F4 key.You can use the Ctrl - Y key combination, or you can use the F4 key.You can use the Ctrl - Y key combination, or you can use the F4 key.You can use the Ctrl - Y key combination, or you can use the F4 key.You can use the Ctrl - Y key combination, or you can use the F4 key.You can use the Ctrl - Y key combination, or you can use the F4 key.


Which key do you press to convert a related cell reference to an absolute cell reference?

As you are typing in the actual cell reference, press the F4 key and it will change it between the 4 available settings. So if your cell is C10, when you press F4 immediately after typing it, it will become: $C$10 then C$10 then $C10 and then back to C10. When you have it the way you want it, continue typing your formula or just press return if the formula is finished.


In Excel what does F4 do after you insert command on the shortcut menu?

The F4 key repeats commands, so it would repeat the insert command you have done.


What is the equivalent to F4 on a Mac?

command (apple key) W closes the current window command (apple key) Q quits the current application


What does the F4 key do to an argument in a Excel formula?

It will change the reference type from relative to absolute and also mixed references. This will be apparent by it putting dollar symbols before the row and/or column reference.