SSC | IBPS | SBI | BANK JOBS | INSURANCE JOBS | RRB | PSU | GOVERNMENT JOBS

Excel Shortcuts, Keyboard Shortcuts, Shortcuts


Excel Shortcuts; Keyboard Shortcuts, Careerneeti Logo

Knowing shortcut keys for the computer or any tool is very helpful to increase the performance and efficiency. In this article, we are going to mention some shortcut keys for Windows and Microsoft Excel. Microsoft Excel is one of the most useful and most used tools in any office. These shortcuts might get asked in some of the competitive exams also like Ibps Clerk, Ibps PO, SBI PO, SSC, etc.


Windows Shortcut Keys| Keyboard Shortcuts

  • Windows Key + R: Opens the Run window.
  • Windows Key + E: Opens Explorer.
  • Alt + Tab: Switch between open programs.
  • Windows Key + Up Arrow: Maximize the current window.
  • Ctrl + Shift + Esc: Open Task Manager.
  • Windows Key + Break: Opens system properties.
  • Windows Key + F: Opens search for files and folders.
  • Windows Key + D: Hide/display the desktop.
  • Alt + Esc: Switch between programs in the order they were opened.
  • Alt + Letter: Select menu item by underlined letter.
  • Ctrl + Esc: Open Start menu.
  • Ctrl + F4: Close active document (does not work with some applications).
  • Alt + F4: Quit active application or close the current window.
  • Alt + Spacebar: Open menu for active program.
  • Ctrl + Left or Right Arrow: Move cursor forward or back one word.
  • Ctrl + Up or Down Arrow: Move cursor forward or the back one paragraph.
  • F1: Open Help menu for the active application.
  • Windows Key + M: Minimize all windows.
  • Shift + Windows Key + M: Restore windows that were minimized with the previous keystroke.
  • Windows + F1: Open Windows Help and Support.
  • Windows + Tab: Open Task view.
  • Windows + Break: Open the System Properties dialog box.
  • Hold Right SHIFT key for eight seconds: Switch FilterKeys on and off.
  • Left Alt + Left Shift + Print Screen: Switch High Contrast on and off.
  • Left Alt + Left Shift + Num Lock: Switch Mouse keys on and off.
  • Press Shift five times: Switch Sticky keys on and off.
  • Hold Num Lock for five seconds: Switch Toggle keys on and off.

Excel Shortcuts:

  • F2: Edit the active cell.
  • F5: Displays the Go To box.
  • F7: Open the Spelling dialogue box to check a selected range.
  • F11: Create a chart of data in the current range in a separate sheet.
  • Alt + Shift + F1: Insert a new worksheet.
  • Shift + F3: Opens Insert Function dialogue box.
  • Shift + F5: Opens the Find and Replace dialogue box.
  • Ctrl + Shift + Colon (:): Enter the current time.
  • Ctrl + Semicolon (;): Enter the current date.
  • Ctrl + A: Select all content in the worksheet.
  • Ctrl + B: Bold highlighted selection.
  • Ctrl + I: Italicize highlighted selection.
  • Ctrl + K: Open the Insert Hyperlink dialogue box.
  • Ctrl + U: Underline highlighted selection.
  • Ctrl + 5: Apply strikethrough formatting.
  • Ctrl + P: Brings up the print dialog box.
  • Ctrl + Z: Undo.
  • Ctrl + F9: Minimize a workbook window to an icon.
  • Ctrl + F10: Maximize a selected workbook window.
  • Ctrl + F6: Switch to the next workbook window when multiple are open.
  • Ctrl + Page Up: Move to the previous sheet in a workbook.
  • Ctrl + Page Down: Move to next sheet in a workbook.
  • Ctrl + Tab: Switch to next tab in dialogue box.
  • Ctrl + Apostrophe ('): Insert the value of the above cell into the cell currently selected.
  • Ctrl + Shift + !: Apply the Number format.
  • Ctrl + Shift + $: Apply the Currency format.
  • Ctrl + Shift + #: Apply the Date format.
  • Ctrl + Shift + %: Apply the Percentage format.
  • Ctrl + Shift + ^: Apply the Exponential format.
  • Ctrl + Shift + @: Apply the Time format.
  • Ctrl + Arrow Key: Move to the edge of the current data region in a worksheet.
  • Ctrl + Space: Select an entire column in a worksheet.
  • Shift + Space: Select an entire row in a worksheet.

Take a printout of these shortcuts and paste/pin in front of your working area or study/computer area, this is the best way to remember these shortcuts. We will publish a set of shortcuts for MS-Word and Internet Explorer in another our another post.

Click here to download the PDF version of these shortcuts.

We hope you find this article helpful!
Share:

No comments:

Post a Comment