answersLogoWhite

0


Best Answer

The F4 key.

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: This key allows one to make the cell absolute?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the function of the F22 key in Excel?

There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.


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.


What allows you to select cells for use in a formula by using a mouse?

You can click and drag from one cell along a row, down a column, or to the opposite corner of a rectangle to select with a mouse. When doing a formula you can select cells in that way after you start typing a formula. So to add all the values in the cells from A2 to A15, you could type: =SUM( Then you could either type the cell range, or select the range with the mouse. The completed formula would be as follows no matter which way you do it: =SUM(A2:A15)


What is the purpose of key f2 on the keybord?

In Excel, the F2 key allows you to edit the contents of a 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 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.


How can you block the F2 key from renaming files in Excel?

In Excel, the F2 key allows you to edit a specific cell. It has nothing to do with renaming files.


How do you unlock F2 function key in Microsoft Excel?

In Excel, the F2 key allows you to edit within a cell. Select a cell and press F2 to begin editing the cell contents. If F2 does not work for you, check your keyboard, the F2 key may not be active. Many keyboards have multiple functions for keys, as indicated by something printed on the top and on the front of the key.


How do macromolecules get in and out of a cell?

They make a tiny little key and then distract the warder......


What Keeps a cell reference constant when copying a formula or function?

If you want to copy a formula from one cell to another (or fill down) without Excel changing the cell references automatically, you'll need to write the cell references with dollar signs included for absolute referencing. Eg: the reference '$D3' locks the reference to column 'D' but allows the row to change when the cell is copied. Eg: the reference 'D$3' locks the reference to row '3' but allows the column to change when the cell is copied. Eg: the reference '$D$3' locks the reference to column 'D' and row '3', so the cell reference cannot change at all when the cell is copied. While you are typing in a cell reference, pressing the 'F4' key will cycle through the combinations for you, so you don't need to type the dollar signs yourself.


What supports the cell and allows it to move and keep it's shape?

The awnser is Cytoskeleton I have an awnser key. I got u, don't panic.


What button will not select a cell in a document?

This question does not make sense. One answer is that the Shift Key will not select a cell in a document.