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+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 Shift + F3 − Opens the Excel formula window. For example, C6.į7 − Spell checks the selected text or document.į11 − Creates chart from the selected data.Ĭtrl + Shift + − Enters the current time.Īlt + Shift + F1 − Inserts New Worksheet.Īlt + Enter − While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.į5 − Goes to a specific cell.
Below is the list of all the major shortcut keys in Microsoft Excel.Ĭtrl + A − Selects all contents of the worksheet.Ĭtrl + I − Italicizes the highlighted selection.Ĭtrl + U − Underlines the highlighted selection.Ĭtrl + 1 − Changes the format of selected cells.Ĭtrl + 5 − Strikethrough the highlighted selection.Ĭtrl + P − Brings up the print dialog box to begin printing.Ĭtrl + F9 − Minimizes the current window.Ĭtrl + F10 − Maximize currently selected window.Ĭtrl + F6 − Switches between open workbooks or windows.Ĭtrl + Page up − Moves between Excel work sheets in the same Excel document.Ĭtrl + Page down − Moves between Excel work sheets in the same Excel document.Ĭtrl + Tab − Moves between Two or more open Excel files.Īlt + = − Creates a formula to sum all of the above cellsĬtrl + ' − Inserts the value of the above cell into cell currently selected.Ĭtrl + Shift + ! − Formats the number in comma format.Ĭtrl + Shift + $ − Formats the number in currency format.Ĭtrl + Shift + # − Formats the number in date format.Ĭtrl + Shift + % − Formats the number in percentage format.Ĭtrl + Shift + ^ − Formats the number in scientific format.Ĭtrl + Shift + − Formats the number in time format.Ĭtrl + Arrow key − Moves to the next section of text.Ĭtrl + Space − Selects the entire column.Ĭtrl + - − Deletes the selected column or row.Ĭtrl + Shift + = − Inserts a new column or row.Ĭtrl + ~ − Switches between showing Excel formulas or their values in cells.į3 − After a name has been created F3 will paste names.į4 − Repeat last action.
EXCEL KEYBOARD SHORTCUT CALCULATE SHEET WINDOWS
If you are familiar with windows operating system, you should be aware of most of them. MS Excel offers many keyboard short-cuts.