What Does Esc Key Do In Excel 2016 For Mac

UPDATE: I have received confirmation that in Excel 2016/2019/365 for Mac, there is currently no way to detect if the Command key is pressed (as of 4/30/2019). However, MS engineers are aware of this and may consider fixing it in later versions. Controls how Microsoft Excel handles Ctrl+Break (or Esc or Command+Period) user interruptions to the running procedure. Read/write XlEnableCancelKey. Expression A variable that represents an Application object. XlEnableCancelKey can be one of these constants: xlDisabled. Cancel key trapping is. Excel shortcut keys. Excel shortcut keys can greatly improve your speed when conducting analysis. But often, it can be hard to remember these hotkeys — especially if you regularly switch between the Mac and PC versions of Excel. To that end, we've compiled this handy list of all the Excel shortcuts you should know, for both Mac and PC. Escape key stopped working in Excel normally, I can hit the 'esc' key when I'm editing a cell and it cancels what's been typed in. Now, it is not working for some reason. For example, if I'm trying to get the text '+' input into a cell but I forget to type ' first, Excel thinks I'm making a formula and activates the dashed outline to help me.

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.

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 TipMac: 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.Key

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

What Does Esc Key Do In Excel 2016 For MacSee Next: 6 Cool Cell Selection Tips for Microsoft Excel Users
The above article may contain affiliate links which help support Guiding Tech. However, it does not affect our editorial integrity. The content remains unbiased and authentic.Also See#function keys #keyboard

Did You Know

You can make GIFs on Gboard.

More in Windows

What Does Esc Key Do In Excel 2016 For Mac Os

3 Best Fixes for Android MicroSD Card Not Showing up on PC

MacBook Pro (15-inch, 2016) and later and MacBook Pro (13-inch, 2016, Four Thunderbolt 3 Ports) and later feature the Touch Bar, which changes automatically based on the application that you're using to show you relevant, familiar tools and controls. On some models, the Esc button appears on the left side of the Touch Bar, in the same place the physical Esc key appears on traditional keyboards.


Sometimes tools in the Touch Bar temporarily cover the Esc button:

After you tap or the Done button, Esc reappears.

How to use another key as Esc

What Does Esc Key Do In Excel 2016 For Macbook Air

You can choose a physical key to act as Esc, temporarily or permanently:

  1. Choose Apple menu  > System Preferences.
  2. Select Keyboard.
  3. In Keyboard preferences, click Modifier Keys.
  4. Use one of the pop-up menus to choose another key to act as Esc.

For example, if you choose Escape to the right of the Control (^) Key label, pressing Control has the same results as pressing Esc: it closes menus that are open, and pressing Control-Option-Command makes the Force Quit Applications window appear.

You can return your keyboard to its original behavior by clicking Restore Defaults.

How to force apps to quit using Esc alternatives

You might not be able to use the Esc button in the Touch Bar if the app you're using becomes unresponsive.

If you need to use Esc to force an app to close, you can switch to another app and try Option-Command-Escape. You can also choose Apple menu > Force Quit.

If that doesn't work, or if your Touch Bar doesn't respond in any app, restart your Mac. Choose Apple menu > Restart or, if your Mac isn't responding, press and hold Touch ID (power button) until your Mac turns off.

Using Esc in Windows

When you use Boot Camp to run Windows 10 on your Mac, Esc is in the same place on the Touch Bar as it is when you're using macOS.

You can also access Esc through the Windows on-screen keyboard. From the Windows menu, select the Windows Ease of Access menu item. Then select On-Screen Keyboard.