50 Best Keyboard Shortcuts in Excel You Should Know in 2023 (2023)

FAQs

What are the 50 shortcut keys? ›

The F1 through F12 FUNCTION keys have special alternate commands. These keys are called enhanced function keys.

The function keys or F-keys on a computer keyboard, labeled F1 through F12, are keys that have a special function defined by the operating system, or by a currently running program. They may be combined with the Alt or Ctrl keys.

Ctrl + ⇧ Shift + Z , or Ctrl + Y. Same as undo, when undo is exhausted, it redoes. Move the cursor after one or more undos, and further undos will be redos.

What is Ctrl K used for? ›

Control-K is a common computer command. It is generated by pressing the K key while holding down the Ctrl key on most computer keyboards. In hypertext environments that use the control key to control the active program, control-K is often used to add, edit, or modify a hyperlink to a Web page.

Remove paragraph formatting. Ctrl+Q. Apply single spacing to the paragraph.

Ctrl+J Aligns the selected text or line to justify the screen. Ctrl+K Insert a hyperlink. Ctrl+L Aligns the line or selected text to the left of the screen.

A 101-key keyboard (U.S. layout) from IBM that superseded the PC/XT and AT keyboards. Introduced in 1985 as the Model M and standard on IBM's PS/2 computer, the Enhanced keyboard was used for more than a decade and continues to be used in its Windows keyboard variant.

The X9 Performance 102-Key Full Size Wireless RF Keyboard for Windows is a 2.4 GHz wireless RF keyboard specially designed for Windows. Its 102-key layout features a 20% reduction in keyboard size for a shorter travel distance, which results in faster number typing.

80% | 87-key Keyboard | Tenkeyless Keyboard (TKL)

The 80% layout of the keyboard is also called the Tenkeyless (TKL) keyboard because the numeric keypad was removed.

Ctrl + Shift + P. Play selected item.

There are 12 keys on the keyboard from F1 to F12. All keys are having different functions to perform. If you are using Laptop then you have to press Fn key along with other keys from F1 to F12 for use.

F1 – Opens the Help screen for almost every program. F2 – Allows you to rename a selected file or folder. F3 – Opens a search feature for an application that is active at the moment. F4 – Alt + F4 closes the active window.

What is F5 used for? ›

F5. Multi-Cloud Security and Application Delivery. Get consistent application services across cloud environments. Jump start your web application security initiative with no financial risk.

F9 is shorthand for "Fine," which is sometimes used in chat communication. 2. The F9 key is a function key found at the top of almost all computer keyboards. The key is often used to open Mission Control on an Apple computer.

Open the Insert hyperlink dialog box. Ctrl+K. Check spelling in the active worksheet or selected range.

The shortcut to format a cell as a date is CTRL + SHIFT + 3, and to format it as time, the shortcut is CTRL + SHIFT + 2. If these shortcuts don't work on your keyboard, press CTRL + 1 while on the cell, and choose a format you would like to have.

There are several dedicated keyboard shortcuts to hide and unhide rows and columns. Ctrl+9 to Hide Rows. Ctrl+0 (zero) to Hide Columns.

F8. Function key used to enter the Windows startup menu, commonly used to access Windows Safe Mode. Used by some computers to access the Windows recovery system, but may require a Windows installation CD.

Describes the new function keys (F9, F10, F11) allow you to control, and navigate your computer easily, thus boosting your productivity. F9 key to easily access to the commonly-used notification & action settings. F10 or F11 to quickly respond to the VoIP calls even without a mouse.

F9 Calculates all worksheets in all open workbooks. Shift+F9 calculates the active worksheet. Ctrl+Alt+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

Alt + F5 : Restore. Alt + F4 : Close.

Ctrl + e is used for many programs for example in ms word or PowerPoint, it is used to change the alignment of a line or centered the text. In a google sheet, Ctrl+ e collapses an expanded array formula. In firefox, internet explorer, opera, chrome Control + E opens the search bar, the address bar, or Omnibox.

What does Ctrl Alt P do? ›

In Microsoft Word, pressing Alt + P opens the Page Layout tab in the Ribbon. After using this shortcut, you can press an additional key to select an option in the Page Layout tab.

The 12 notes are C, C-Sharp (D-Flat), D, D-sharp (E-Flat), E, F, F-Sharp (G-Flat), G, G-Sharp (A-Flat), A, A-Sharp (B-Flat), and B. Many beginners think that a sharp or flat means a black key. All black keys are either a sharp or flat, but not all sharps and flats are black keys.

Answer: A keyboard contains 26 alphabet keys. Used to enter words and phrases. You can write both uppercase and lowercase letters.

Alternatively referred to as the circumflex, the caret is the symbol ( ^ ) above the 6 key on a standard United States qwerty keyboard. In mathematics, the caret represents an exponent, such as a square, cube, or another exponential power.

Ctrl + F: Open find box. Ctrl + I: Italic highlighted selection. Ctrl + K: Insert link (Shortcut Keys and their Functions). Ctrl + U: Underline highlighted selection.

A 104-key keyboard (U.S. layout) that is the de facto standard keyboard included with new desktop PCs. Introduced in 1995, the Windows keyboard superseded the 101-key Enhanced keyboard and added three keys specialized for Windows.

The third most popular is... the "backspace" key. The second most popular is... the letter "e". The number one most popular is... the space bar.

What is Alt + F4? Alt + F4 is a keyboard shortcut that completely closes the application you're currently using on your computer. Alt + F4 differs slightly from Ctrl + F4, which closes the current tab or window of the program you're currently using.

Are there 24 function keys? ›

Today's traditional PC keyboards have 12 function keys, F1 through F12 . Some specialized PC keyboards have 24 function keys, F1 through F24 . Many Apple desktop computer keyboards with a number pad have 19 function keys, F1 through F19 .

The function keys or F-keys on a computer keyboard, labeled F1 through F12, are keys that have a special function defined by the operating system, or by a currently running program. They may be combined with the Alt or Ctrl keys.

A 101-key keyboard (U.S. layout) from IBM that superseded the PC/XT and AT keyboards. Introduced in 1985 as the Model M and standard on IBM's PS/2 computer, the Enhanced keyboard was used for more than a decade and continues to be used in its Windows keyboard variant.

Most keyboards come with 66, 72, or 88 keys. For a beginner, 66 keys are sufficient for learning to play, and you can play most music on a 72-key instrument. For anyone interested in playing classical piano, however, a full 88 keys are recommended, especially if you plan on one day playing a traditional piano.

What is a 40% keyboard? 40% keyboards are a niche keyboard, its keyboard layout does away with the number row, arrow cluster, and often punctuation keys. People who prefer 40% keyboards have optimized their use of space and movement, a 40% keyboard can type and game very efficiently once you get used to its nuances.

Ctrl + P: Open the print window. Ctrl + F: Open find box. Ctrl + I: Italic highlighted selection. Ctrl + K: Insert link (Shortcut Keys and their Functions).

Ctrl+N: Create a new file. Ctrl+O: Open an existing file. Ctrl+S: Save the current file. Ctrl+Z: Undo the previous action.