Ctrl + F10 ➪ Maximize or restore the workbook window. ⇒ FAQs: What is a minimize shortcut key? What does the function of CTRL F9 excel? Note: Please remember that Windows+D minimizes all the active windows. Ctrl + F9 ➪ Minimize the individual open workbook to an icon. ⇒ FAQs: What is an Excel strikethrough shortcut? Ctrl+ 5 ➪ Apply or remove strikethroughĮquivalent to Home ⇨ Font ⇨ Font Settings ⇨ Strikethrough. Ctrl+4 / Ctrl+U ➪ Apply or remove an UnderlineĮquivalent to Home ⇨ Font ⇨ U (Underline). Ctrl+3 / Ctrl+I ➪ Apply or remove the Italic formatting. Ctrl+2 / Ctrl+B ➪ Apply or remove the Bold formatting. ⇒ FAQs: What does the function of CTRL 1 excel? Ctrl+ 1 ➪ Displays the Format Cells dialog box for the selected cell or rangeĮquivalent to Home ⇨ Number ⇨ Number Format settingsĮquivalent to Home ⇨ Alignment ⇨ Alignment settings. ⇒ FAQs: What is the undo keyboard shortcut? What is the undo shortcut in Excel? What does the function of CTRL Z excel? (B) TYPE 2: EXCEL CTRL SHORTCUTS WITH NUMERIC KEYS Note: Both undo and redo allow Excel users to choose from among the last 16 actions. Ctrl+Z / Alt+Backspace ➪ Undo the last command or action. ⇒ FAQs: What is the redo keyboard shortcut? What is the redo shortcut in excel? What does the function of CTRL Y excel? Note: Only activate after undoing an action. ⇒ FAQs: What is the shortcut key to close a window? Otherwise, for unsaved workbooks, by default open the Save As option in each case. If the files are saved, close them at a time. 
If we go with the Alt+F4, it allows us to close all the workbooks at a time. The benefit is that the user can choose the option which files want to save or not. Note: If there are a number of workbooks open for working purposes, it is always good practice to close them one by one by pressing Ctrl+W.
Ctrl+W ➪ Close only the current workbook. ⇒ FAQs: What is a shortcut key for select all? What is the ‘select all' keyboard shortcut? In a blank worksheet, it selects the entire worksheet. One-time press to select the entire range of active cells in a dataset, second-time press to select the entire worksheet. Ctrl+A / Ctrl+Shift+* (Asterisk) ➪ Select All. There are six types of Excel CTRL shortcuts as follows: (A) TYPE 1: EXCEL CTRL SHORTCUTS WITH ALPHABET KEYS MAJOR TYPES OF EXCEL CTRL SHORTCUTS / CTRL KEYBOARD SHORTCUTS The main motto of using Excel Ctrl shortcuts is to customize the Excel activity rapidly other than using a mouse input device. Similarly, we can move one worksheet (tab) to another worksheet (tab) by using Excel Ctrl shortcuts Ctrl+Page Down (move to the right side) and Ctrl+Page Up (Move to the left side). We can insert a row or column ( Ctrl++) or delete ( Ctrl+-) easily. ➢ Ctrl shortcut keys quickly perform to manage a range of cells in a worksheet or between worksheets.įor example, we can easily cut ( Ctrl+X), copy ( Ctrl+C), paste ( Ctrl+V) of a range of cells. Similarly, Excel shortcut Ctrl+N allows creating a New Workbook command. Otherwise, we should follow the following steps: File ⇨ New ⇨ Blank Workbook. Otherwise, we should follow the following steps: File ⇨ Save. ➢ Ctrl keyboard shortcuts allow us to perform many commonly used commands very easily.įor example, Ctrl+S is the keyboard shortcut for the Save command, which means users hold down the CTRL key, then press the S key to save the workbook. WHAT ARE THE BENEFITS OF EXCEL CTRL SHORTCUTS? (F) TYPE 6: EXCEL CTRL SHORTCUTS WITH SHIFT KEY & SYMBOL KEYS. (E) TYPE 5: EXCEL CTRL SHORTCUTS WITH NAVIGATION KEYS. (D) TYPE 4: EXCEL CTRL SHORTCUTS WITH FUNCTION KEYS. (C) TYPE 3: EXCEL CTRL SHORTCUTS WITH PUNCTUATION KEYS. (B) TYPE 2: EXCEL CTRL SHORTCUTS WITH NUMERIC KEYS. 
(A) TYPE 1: EXCEL CTRL SHORTCUTS WITH ALPHABET KEYS. MAJOR TYPES OF EXCEL CTRL SHORTCUTS / CTRL KEYBOARD SHORTCUTS
0 kommentar(er)
