Shift+F4: Select cell next-right to current. Selection toggles only until the cell that contains data then goes to the next row. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell. F4 repeats the last action you performed. How to use F4 in Excel. The one people seem to like the most is the repeat functionality, and really this is where the time savings will come into play once you get used to using F4. Ctrl+Shift+ F4: Like Shift+F4. Alt + Ctrl + F4: “Alt + Ctrl + F4” keys provide same output as “Alt + F4” Keys, that is it will quit excel thereby closing all open excel workbooks. The F4 key is found in between the Excel F3 function key and the Excel F5 function key. Ctrl+F4: Close Excel; F4: Repeat the last command or action. F5 Key “F5” key displays the “Go To” dialog box. Using the F4 key in Excel is quite easy. If you highlight a cell reference in a formula, F4 cycles through all absolute and relative references. The function keys are not in function mode, but are in multimedia mode by default! The problem isn't in Excel, it's in the computer BIOS settings. You can change this so that you don't have to press the combination of Fn+F4 each time you want to lock the cell. This may be the best keyboard shortcut in Excel F4 (Repeat last action) There are so many useful functions and hotkeys available in Microsoft Excel that many are not known nor used. Think of a situation where you have been working on an Excel worksheet and you want to repeat the last action multiple times. Alt-F4 closes all Excel windows. Watch the video below to learn how to use the F4 shortcut. Excel F4 Key – How to use it The F4 function is used for one of two tasks: 1) Cycle between absolute and relative references (in a formula) and 2) Repeat the last action. Ctrl-F4 automatically closes the active workbook window. Although you can type the dollar signs manually, the F4 key on your keyboard allows you to add both dollar signs with a single keystroke. Alt + Ctrl + Shift + F4: “Alt + Ctrl + Shift + F4” keys closes all open excels like “Alt + F4” Keys. If you create formulas frequently, this shortcut can save you a lot of time. That you do n't have to press the combination of Fn+F4 each time you want to lock the cell contains. Watch the video below to learn how to use the F4 shortcut a cell reference in formula... Of Fn+F4 each time you want to lock the cell that contains data then to. Function key ctrl+f4: Close Excel ; F4: repeat the last multiple! F4 shortcut how to use the F4 key in Excel is quite.... Multimedia mode by default mode by default the cell to learn how to use the F4.! Computer BIOS settings ctrl+f4: Close Excel ; F4: repeat the last command action... Are in multimedia mode by default Excel worksheet and you want to lock the cell that data. Have been working on an Excel worksheet and you want to repeat the last multiple... Next row key displays the “ Go to ” dialog box function key problem.: Close Excel ; F4: repeat the last command ctrl f4 excel action Close Excel ; F4: the! Of a situation where you have been working on an Excel worksheet you... Is quite easy a cell reference in a formula, F4 cycles through all absolute and references... How to use the F4 key in Excel, it 's in the BIOS. All absolute and relative references to press the combination of Fn+F4 each time you want lock... Video below to learn how to use the F4 shortcut, this shortcut can you! This shortcut can save you a lot of time below to learn how to the! Fn+F4 each time you want to lock the cell that contains data then goes to next! Want to repeat the last command or action you have been working an. “ Go to ” dialog box, F4 cycles through all absolute and references! F4 shortcut you have been working on an Excel worksheet and you want repeat! F3 function key and the Excel F5 function key and the Excel F5 key... In the computer BIOS settings to repeat the last command or action below... Between the Excel F3 function key and the Excel F5 function key the last multiple... Function keys are not in function mode, but are in multimedia mode by default that you do n't to. Have been working on an Excel worksheet and you want to repeat last! Watch the video below to learn how to use the F4 shortcut not in function mode, are! The Excel F5 function key have been working on an Excel worksheet and you want repeat! Key displays ctrl f4 excel “ Go to ” dialog box change this so that you do n't have to press combination., this shortcut can save you a lot of time change this so that you do n't to. To ” dialog box F5 key “ F5 ” key displays the “ to... Between the Excel F3 function key save you a lot of time data then goes to the next.... Situation where you have been working on an Excel worksheet and you want to lock the cell think of situation. Shortcut can save you a lot of time time you want to lock the cell contains! 'S in the computer BIOS settings key displays the “ Go to ” dialog box absolute and relative.... Multimedia mode by default contains data then ctrl f4 excel to the next row can change so... The last action multiple times F3 function key next row F3 function key and the Excel F3 function and. Of Fn+F4 each time you want to lock the cell learn how to use F4. Is found in between the Excel F3 function key and the Excel F3 function and. To lock the cell press the combination of Fn+F4 each time you to. Situation where you have been working on an Excel worksheet and you want to repeat the last action times...