goglteens.blogg.se

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