Excel Shortcut Command

Excel Shortcut Command

• CTRL+A — Selects the entire worksheet.
• CTRL+B — Applies or removes bold formatting.
• CTRL+C — Copies the selected cells.
• CTRL+D — Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
• CTRL+F — Displays the Find dialog box.
• CTRL+G — Displays the Go To dialog box.
• CTRL+H — Displays the Find and Replace dialog box.
• CTRL+I — Applies or removes italic formatting.
  
• CTRL+K — Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
• CTRL+L — Displays the Create List dialog box.
• CTRL+N — Creates a new blank file.
• CTRL+O — Displays the Open dialog box to open or find a file.
• CTRL+P — Displays the Print dialog box.
• CTRL+R — Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
• CTRL+S — Saves the active file with its current file name, location, and file format.
• CTRL+U — Applies or removes underlining.
• CTRL+V — Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.
• CTRL+W — Closes the selected workbook window.
• CTRL+X — Cuts the selected cells.
• CTRL+Y — Repeats the last command or action, if possible.
• CTRL+Z — Uses the Undo command to reverse the last command or to delete the last entry you typed.
• CTRL+1 — Displays the Format Cells dialog box.
• CTRL+2 — Applies or removes bold formatting.
• CTRL+3 — Applies or removes italic formatting.
• CTRL+4 — Applies or removes underlining.
• CTRL+5 — Applies or removes strikethrough.
• CTRL+6 — Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
• CTRL+7 — Displays or hides the Standard toolbar.
• CTRL+8 — Displays or hides the outline symbols.
• CTRL+9 — Hides the selected rows.
• CTRL+0 — Hides the selected columns.
• CTRL+( — Unhides any hidden rows within the selection.
• CTRL+) — Unhides any hidden columns within the selection.
• CTRL+& — Applies the outline border to the selected cells.
• CTRL+_ — Removes the outline border from the selected cells.
• CTRL+~ — Applies the General number format.
• CTRL+$ — Applies the Currency format with two decimal places (negative numbers in parentheses).
• CTRL+% — Applies the Percentage format with no decimal places.
• CTRL+^ — Applies the Exponential number format with two decimal places.
• CTRL+# — Applies the Date format with the day, month, and year.
• CTRL+@ — Applies the Time format with the hour and minute, and AM or PM.
• CTRL+! — Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
• CTRL+* — Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
• CTRL+ — — Enters the current time.
• CTRL+; — Enters the current date.
• CTRL+‘ — Alternates between displaying cell values and displaying formulas in the worksheet.
• CTRL+’ — Copies a formula from the cell above the active cell into the cell or the Formula Bar.
• CTRL+” — Copies the value from the cell above the active cell into the cell or the Formula Bar.
• CTRL++ — Displays the Insert dialog box to insert blank cells.
• CTRL + ; — Enter the current date.
• CTRL + - — Delete the slected column or row.
• F1 — Help
• F2 — Edit
• F3 — Paste Name
• F4 — Repeat last action
• F4 — While typing a formula, switch between absolute/relative refs
• F5 — Goto
• F6 — Next Pane
• F7 — Spell check
• F8 — Extend mode
• F9 — Recalculate all workbooks
• F10 — Activate Menubar
• F11 — New Chart
• F12 — Save As
• CTRL + Page up — Move between Excel work sheets in the same Excel document.
• CTRL + Page down — Move between Excel work sheets in the same Excel document.
• CTRL + Tab — Move between Two or more open Excel files.
• CTRL + Arrow key — Move to next section of text.
• CTRL + Space — Select entire column.
• CTRL + Home — Move to cell A1.
• CTRL + Shift + = — Insert a new column or row.
• CTRL + Shift + ; — Enter the current time.
• CTRL + Shift + ! — Format number in comma format.
• CTRL + Shift + $ — Format number in currency format.
• CTRL + Shift + # — Format number in date format.
• CTRL + Shift + % — Format number in percentage format.
• CTRL + Shift + ^ — Format number in scientific format.
• CTRL + Shift + @ — Format number in time format.
• CTRL+Shift+F3 — Create name by using names of row and column labels
• CTRL+Shift+F6 — Previous Window
• CTRL+Shift+F12 — Print
• Alt + = — Create a formula to sum all of the above cells
• Alt + 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.
• Alt + Shift + F1 — Insert New Worksheet.
• Shift+F1 — What’s This?
• Shift+F2 — Edit cell comment
• Shift+F3 — Paste function into formula
• Shift+F4 — Find Next
• Shift+F5 — Find
• Shift+F6 — Previous Pane
• Shift+F8 — Add to selection
• Shift+F9 — Calculate active worksheet
• Shift+F10 — Display shortcut menu
• Shift+F11 — New worksheet
• Shift+F12 — Save
• Shift + Space — Select entire row.
• Alt+F1 — Insert Chart
• Alt+F2 — Save As
• Alt+F4 — Exit
• Alt+F8 — Macro dialog box
• Alt+F11 — Visual Basic Editor
• Alt+Shift+F1 — New worksheet
• Alt+Shift+F2 — Save
• CTRL+Alt+F9 — Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
• CTRL+Alt+Shift+F9 — Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

.............