Excel Shortcuts, Keyboard Shortcuts, Shortcuts
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.
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 the 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 the 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 the 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.
Click here to download the PDF version of these shortcuts.
We hope you find this article helpful!
This comment has been removed by the author.
ReplyDeleteHello, I simply wish to give a huge thumbs up for the good information you will have here on this post. CD International School always share good information with their students and that way is school is comes into the best school in Gurgaon.
ReplyDeleteit's really cool blog. Linking is very useful thing.you have really helped is can i run it safe
ReplyDeleteI would also motivate just about every person to save this web page for any favorite assistance to assist posted the appearance. Towing Dublin
ReplyDeleteI like viewing web sites which comprehend the price of delivering the excellent useful resource free of charge. I truly adored reading your posting. Thank you! Car Recovery Dublin
ReplyDeleteIt needs to have springy keys. It likewise ought to be programmable. One should likewise know the provisions of the guarantee and make a point to get one that offers help for a more drawn out period. A decent ergonomic keyboard should be flexible with either a USB or a PS2 association. mk270 keyword reviews
ReplyDeleteFive dollars from each buy goes to bosom malignant growth research. They have something like seven unique options in pink laptops in the Promise line alone, just as an assortment of different decisions. CPS Test Online
ReplyDeleteNice Article.
ReplyDeleteTraining for devops
Do Not Join Gano Excel Until You Read This Review Completely! If you are reading this Gano Excel review, then you are seriously thinking about getting on board with "Gano Excel". With so many new health and wellness companies moving in to the world of network marketing, it can be very hard to decide which one to invest your hard-earned money with. word translator
ReplyDeleteHowever, after intensive testing, we ruled that it was BK8, 1xBet and 22Bet which might be} among the greatest. However, the most effective website will really be the one that closest meets your demands. In your welcome e mail, click on the relevant hyperlink to confirm your account. This step takes only a matter of 1xbet seconds, with it being clear when it has been successful. Soccer, baseball, basketball and golf are among the closest adopted. Bets on such sports, nicely as|in addition to} others, can be found through online bookmakers.
ReplyDelete