F4 Function In Excel For Mac

Автор:

Microsoft Excel is huge in terms of its underlying features and functions. So are the keyboard shortcuts in it. The list can go on and on. What we will do is limit our scope and concentrate only on Function Keys today. We will try and learn the actions associated with F1 through F12, standalone and in combination with keys like Alt, Ctrl and Shift.

If you are using a PC or Windows based laptop, you can make an Excel cell reference absolute (or fixed) by pressing the F4 function key on the keyboard after the cell reference. The equivalent if you are using a Mac is to press ⌘T. The use of function keys such as the F4 in Excel as well as the Excel F2 can be very necessary. In this post, we shall look at the function key F4 and its use in Excel.

We all know the basic moves like how you can move around the sheet and select cells using the arrow keys or press Ctrl+A to select the entire worksheet but there are more complicated shortcut keys that you should know.

Must Read: If you wish to explore basic and general uses of function keys read out post on the best and default uses of function keys.

F1

Shortcut KeyActionF1Opens the Excel Help task pane.Ctrl+F1Hide/Unhide the taskbar.Alt+F1Create a chart from data in the current range.Alt+Shift+F1Create a new worksheet.Ctrl+Shift+F1Hide/Unhide ribbon and taskbar.

F2

Shortcut KeyActionF2Activates the active cell for editing.Ctrl+F2Open print options.Alt+F2Open file save as modal window.Shift+F2Insert/Edit comment on selected cells.Alt+Shift+F2Save the current workbook.

F3

Shortcut KeyActionF3Paste a defined name into a formula.Ctrl+F3Open name manager dialog box.Shift+F3Open function insert dialog box.Ctrl+Shift+F3Create names by using row and column labels.

F4

Shortcut KeyActionF4Repeat last action (for example, create a text box) or toggle among cell references.Ctrl+F4Close the current workbook.Alt+F4Gives option to save or discard current changes.Shift+F4Select cell next-right to current. Selection toggles only until the cell that contains data then goes to the next row.Ctrl+Shift+ F4Like Shift+F4. But movement is left and then to the above row.

F5

Shortcut KeyActionF5Open the Go to dialog box.Ctrl+F5Restore the window size of the open workbook.Shift+F5Open Find/Replace dialog box.

F6

Shortcut KeyActionF6Switch between the Help task pane and the application window. Switch to the next pane in a worksheet that has been split.Ctrl+F6Switch to the next workbook window when more than one workbook window is open.Shift+F6Switch to the previous pane in a worksheet that has been split.Ctrl+Shift+F6Switch to the previous workbook window when more than one workbook window is open.

F7

Shortcut KeyActionF7Perform spell check in the selected range.Ctrl+F7Activate move window cursor provided window is not maximized.Shift+F7Open thesaurus.

F8

Shortcut KeyActionF8Turn the extend mode on/off.Ctrl+F8Activate resize window cursor provided window is not maximized.Alt+F8Open Macro dialog box.Shift+F8Enable Add to Selection mode - select non-adjacent cells when enabled.

F9

Shortcut KeyActionF9Refreshes workbook. Performs calculations on formulas.Ctrl+F9Minimize workbook.Shift+F9Calculate the active worksheetCtrl+Alt+F9Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.Ctrl+Alt+Shift+ F9Recheck dependent formulas and then calculates all cells in all open workbooks.

F10

Shortcut KeyActionF10Select the menu bar and close an open menu and submenu at the same time.Ctrl+F10Maximize or restore the selected workbook window.Shift+F10Display the shortcut menu for the selected item.Alt+Shift+F10Display the menu or message for a smart tag.

F11

Shortcut KeyActionF11Create a chart of the data in the selected range.Ctrl+F11Create new worksheet with name like Macro1, Macro2…Alt+F11Switch between the visual basic editor and the active workbook.Shift+F11Create a new worksheet.Alt+Shift+F11Open Microsoft script editor.

F12

Shortcut KeyActionF12Open save as dialog box.Ctrl+F12Open the open menu.Shift+F12Save the current workbook.Ctrl+Shift+F12Open the print menu.
Cool Tip: Did you know that you can just press Esc to expand or collapse the formula bar and Delete to remove cell contents? Well, now you know.

Conclusion

So, did you find the list interesting? If you spend most of your day on Excel, I am betting you must have found it helpful. You may not be able to remember and master all of them but I am sure you will recollect the ones you feel will help you lower your efforts.

Note: These shortcuts have been tried and tested with Microsoft Excel 2013. However, most of them should be downward compatible.

Image Credit: N Hope

See Next: 6 Cool Cell Selection Tips for Microsoft Excel UsersAlso See#function keys #keyboard

Did You Know

Mac

Only 25% of people can text well without looking at their keyboards.

More in Windows

8 Ways to Fix Windows Search Bar Is Missing Issue

It is true that many of the Excel users find the use of keyboard shortcuts to be more efficient to them. Actually, keyboard shortcuts can be the best alternative to using a mouse, as the use of touch screen when working with Excel might not be the best option of people with visual impairment. The use of function keys such as the F4 in Excel as well as the Excel F2 can be very necessary. In this post, we shall look at the function key F4 and its use in Excel.

Using F4 in Excel to repeat an action

Have you ever worked on an Excel worksheet and you have had to repeat the same action over and over again? If yes, then you know how tedious, boring and tiresome it might be. Excel offers function keys to help us quickly repeat the last action. The F4 on Excel is the function key that can allow us to repeat the last action as many times as we want. So if you have been thinking about what is F4 in Excel, now you should know that it is simply a function key that can help us repeat the last action in Excel.

How to locate the F4 function key in Excel

Many might have wondered, “Where is the F4 key on Excel?” Well, this key is on the first row of the keyboard where we have the function keys. Note that function keys run from F1 to F12. The F4 key is found in between the Excel F3 function key and the Excel F5 function key.

How to use F4 in Excel

Using the F4 key in Excel is quite easy. Think of a situation where you have been working on an Excel worksheet and you want to repeat the last action multiple times. All you need to do is press and hold Fn and then press and release the F4 key. Alternatively, you can press and hold down the Ctrl key, then press and release the F4 key to repeat the last action. Note that you will have to press and release the F4 function while holding the Fn or Ctrl key as many times as you want the last action repeated.

ChemOffice Professional 17.0.0.206 Crack Plus Keygen FreeAn extra-ordinary intelligent program designed by the professionals of “ChemDraw Software” in which every user can Analyze the Data of “Chemical Reactions” with “ ChemDraw 17 Crack“. Chemdraw for mac free.

You can also use the F4 key to change a cell reference. When you select a cell or range in a given formula, you can use the F4 key to cycle through the various combinations to absolute and relative reference.

You can also use the F4 function key to lock a cell reference.

Are waiting for you to explore.What makes PiPop's music videos even more special is that we give fans the chance to contribute their song translations toward their idols. Beside that, you can find out hundred of janpanese anime songs. If you have a good capacity of Japanese and love Japanese music, check out PiPop's translating contribution function.For those fans who want to learn and improve Japanese, PiPop is a perfect choice if you're getting bored with the textbooks. Otome games free download. The Opening and Ending Song from Overlord, Attack on titan, Boku no Hero Academia, Tokyo Ghoul.

What to do when the F4 is not working in Excel

There are times when pressing the F4 function key does not yield the desired results. In such a case, it is good to remember that the problem is not with Excel, but rather with the BIOS settings of the computer. By default, the F4 function key, just like F2 function key and all the others are in a multimedia mode. You can thus change this if you want to avoid pressing the Fn + F4 every time you want to lock a cell.

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.