1. What Does Esc Key Do In Excel 2016 For Macbook Air
  2. What Does Esc Key Do In Excel 2016 For Macs
  3. What Does Esc Key Do In Excel 2016 For Mac Os
  4. What Does Esc Key Do In Excel 2016 For Macbook Pro

In many applications, the Esc key is a keyboard shortcut for canceling the current operation. If you see a Cancel button on the screen, chances are pressing Esc will be the same as clicking that Cancel button. Similarly, Esc is often a single-key equivalent to pressing the Command. Excel Microsoft Excel keyboard shortcuts you need to master Do you find using a mouse to manage your Excel worksheet a bit of an annoyance? Would you rather command it from your keyboard?

A computer keyboard with the Esc key in the top-left corner
Excel
IBM 83-key keyboard (1981), with Esc in the top-left corner of the alphanumeric section

On computerkeyboards, the Esc keyEsc (named Escape key in the international standard series ISO/IEC 9995) is a key used to generate the escape character (which can be represented as ASCII code 27 in decimal, Unicode U+001B, or Ctrl+[). The escape character, when sent from the keyboard to a computer, often is interpreted by software as 'stop', and when sent from the computer to an external device (including many printers since the 1980s, computer terminals and Linux consoles, for example) marks the beginning of an escape sequence to specify operating modes or characteristics generally.

It is now generally placed at the top left corner of the keyboard, a convention dating at least to the original IBM PC keyboard, though the key itself originated decades earlier with teletypewriters.

Symbol[edit]

ISO keyboard symbol for 'Escape'

The keyboard symbol for the ESC key (which may be used when the usual Latin lettering 'Esc' is not preferred for labelling the key) is standardized in ISO/IEC 9995-7 as symbol 29, and in ISO 7000 'Graphical symbols for use on equipment' as symbol ISO-7000-2029. This symbol is encoded in Unicode as U+238B broken circle with northwest arrow (⎋). Arma 3 star wars opposition mod.

Origins[edit]

The name of the equivalent key on some early Teletype Model 33 keyboards was labeled Alt Mode.., the alternative mode of operation causing the escapement to treat the following one character in a special way. Much later printers and computer terminals that would use escape sequences often would take more than one following byte as part of a special sequence.

The VT05 CRT did not have an ESC key; the VT50, which came 4 years later, did.[1]

Uses[edit]

Adobe photoshop cs3 key generator. As most computer users are no longer concerned with the details of controlling their computer's peripherals, the task for which the escape sequences were originally designed, the escape key was appropriated by application programmers, most often to mean Stop. This use continues today in Microsoft Windows's method of escape as a shortcut in dialog boxes for No, Quit, Exit, Cancel, or Abort, as well as a common shortcut key for the Stop button in many web browsers.[2][3][4]

On machines running Microsoft Windows, prior to the implementation of the Windows key on keyboards, the typical practice for invoking the 'start' button was to hold down the Control key and press escape. This key combination still works as of Windows 10.[5]

Microsoft Windows makes use of 'Esc' for many key shortcuts.[6] Many of these shortcuts have been present since Windows 3.0, through Windows XP, Windows Vista, Windows 7, Windows 8, and Windows 10.

In macOS, 'Esc' usually closes or cancels a dialog box or sheet. The ⌘ Command+⌥ Option+⎋ Esc combination opens the Force Quit dialog box, allowing users to end non-responsive applications. Another use for the Esc key, in combination with the Command key, is switching to Front Row, if installed.

In most computer games, the escape key is used as a pause button and/or as a way to bring up the in-game menu, usually containing ways to exit the program.

ADM-3A keyboard layout used in vi development, with escape in what is now the tab position

In the vi family of text editors, escape is used to switch modes. This usage is due to escape being conveniently placed in what is now the tab position on the ADM-3A terminal keyboard used to develop vi, though it is now inconveniently placed. This is similar to how the extensive modifier keys in Emacs were easily used on the original keyboard (the space-cadet keyboard), being placed together, but these keys have now been spread around the keyboard, becoming more difficult to use.

Escape sequences on KSR terminals[edit]

Old keyboard Send/Receive (KSR) printers, and visual display units (VDUs), would normally be controlled by escape sequences sent by the computer to the peripheral device, but there were situations where these devices could be used 'off-line' with the keyboard effectively connected to the output device, and so the need could arise to type escape sequences 'by hand' to control the peripheral. Although such devices are long out of use, standard processing[7] of ANSI Escape sequences very similar to the 1970s VT100, is implemented in both ANSI.SYS and other more modern pseudo-terminal interfaces used in Unix-like environments, one example being Linux consoles, meaning newer, higher-level abstractions haven't changed the fact that typing the escape key followed by something like the six characters [32;1m affects subsequently text in output, in this case turning it green.

References[edit]

  1. ^No ESC key: see photo 'VT05'.
  2. ^'Archived copy'. Archived from the original on 2006-09-19. Retrieved 2009-02-07.CS1 maint: archived copy as title (link)
  3. ^'Archived copy'. Archived from the original on 2009-02-18. Retrieved 2009-02-07.CS1 maint: archived copy as title (link)
  4. ^'Cheat Sheet for Mozilla FireFox (Key Board Short Cuts)'. scribd.com. Retrieved 4 December 2016.
  5. ^'Ctrl+Esc, U, Enter: Shutdown Windows (XP and earlier)'. Retrieved 26 April 2012.
  6. ^'Keyboard shortcuts in Windows'. support.microsoft.com.
  7. ^'About Unicode and Character Sets', Joel Spolsky, Joel on Software
IBM PC keyboard (Windows, ANSI US layout)
EscF1F2F3F4F5F6F7F8F9F10F11F12PrtScn/
SysRq
Scroll
Lock
Pause/
Break
InsertHomePgUpNum
Lock
DeleteEndPgDn789+
456
123Enter
0
Ins
.
Del
Retrieved from 'https://en.wikipedia.org/w/index.php?title=Esc_key&oldid=985991451'

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.

Reliaslearning

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.

What Does Esc Key Do In Excel 2016 For Macbook Air

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

What Does Esc Key Do In Excel 2016 For Macs

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

What Does Esc Key Do In Excel 2016 For Mac
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.

What Does Esc Key Do In Excel 2016 For Mac Os

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:

What Does Esc Key Do In Excel 2016 For Macbook Pro

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 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

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