0
It can change the reference type of the cell in a formula as it is being typed. It changes it from relative to absolute, mixed with a row locked, mixed with a column locked and back to relative. If you were typing A1 you would get the follow sequence:
=A1
=A$1
=$A1
=$A$1
=A1
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
In Excel 2007 what is used to quit Excel?
Press and hold Alt and then F4.
How do you repeat a same command in Microsoft Excel?
Pressing the F4 key will repeat the last command.
What is the hot key to close Microsoft Excel?
Alt - F4 is the main one, though you can also use Alt - F - X.
If two Microsoft Excel sheets are opened together then how can I close one of the windows of the Excel sheet with the keyboard i.e. without using the mouse?
Depending on if you have them open in separate windows of Excel.If they are in the same window: * Ctrl + F4 = Closes the active workbook. If they're in separate windows: * Alt + Tab = Changes your active window * Ctrl +F4 = Closes the active workbook. OR * Alt + F4 = Closes Excel; closes the program. * Ctrl + W = Also closes the active workbook (It doesn't matter if you have extra sheets in Microsoft Excel, unless if someone tells you it does matter.)
What is the function key used in Excel to repeat the last action when inserting columns and rows?
Nope . It is F4
How do you disable extended selection made in excel?
To disable extended selection mode in Excel 2007 you just need to press f4 function key once. <a href="http://www.sanangelolive.com">san angelo</a>
What does this formula do equals D2-F4 plus E8D1 in Microsoft Excel?
The formula does the following, it takes value in cell D2 subtracts it from the value in cell F4 and then adds the values in cell E8 and D1.
Excel 2007 Create the formula in G4 to display the text Yes if the number of Atfault claims is greater than 1 and the current rating is greater than 2?
Assuming the At fault claims are in E4 and Rating is in F4 then your formula in G4 would be: =If(And(E4>1,F4>2),"Yes","No")
What key combination is used to close the Microsoft Word document?
Press Alt-F4 or press Alt-F-X to exit Word.
How do you change the active cell from f4 to f3 in excel?
Click on cell F3 or press the up arrow.
What does control f4 do just wondering...?
In Microsoft Word, using the command of 'control' and 'f4' will close your current document. Don't hit this command if you do not want to close your document.
What are the different ways on how to close the Microsoft Word?
just press alt+f4 or press esc.
