Advertisements
Advertisements
Question
When editing a cell in Excel, which key or combination of keys is pressed to toggle between relative, absolute and mixed cell references?
Solution
The easiest way to change cell references from relative to absolute or mixed is to press the F4 key on the keyboard. To change existing cell references, Excel must be in edit mode, which you enter by double-clicking on a cell with the mouse pointer or by pressing the F2 key on the keyboard.
APPEARS IN
RELATED QUESTIONS
Which key combination collapses the ribbon?
What category of functions is used in this formula: =PMT (C10/12, C8, C9,1)
When Extend Selection is active, what is the keyboard shortcut for selecting all data up to and including the last row?
Which formulae would result in TRUE if C4 is less than 10 and D4 is less than 100?
Which of the following arguments in a financial function represents the total number of payments?
Give the meaning of the MODE Junction in Excel with an example.
