Best 80+ Shortcut Keys for Microsoft Excel.

 


  1. Ctrl+N: Create a new workbook
  2. Ctrl+O: Open an existing workbook
  3. Ctrl+S: Save a workbook
  4. F12: Open the Save As dialog box
  5. Ctrl+W: Close a workbook
  6. Ctrl+F4: Close Excel
  7. F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
  8. Shift+F11: Insert a new worksheet
  9. Ctrl+Z: Undo an action
  10. Ctrl+Y: Redo an action
  11. Ctrl+F2: Switch to Print Preview
  12. F1: Open the Help pane
  13. Alt+Q: Go to the “Tell me what you want to do” box
  14. F7: Check spelling
  15. F9: Calculate all worksheets in all open workbooks
  16. Shift+F9: Calculate active worksheets
  17. Alt or F10: Turn key tips on or off
  18. Ctrl+F1: Show or hide the ribbon
  19. Ctrl+Shift+U: Expand or collapse the formula bar
  20. Ctrl+F9: Minimize the workbook window
  21. F11: Create a bar chart based on selected data (on a separate sheet)
  22. Alt+F1: Create an embedded bar chart based on select data (same sheet)
  23. Ctrl+F: Search in a spreadsheet, or use Find and Replace
  24. Alt+F: Open the File tab menu
  25. Alt+H: Go to the Home tab
  26. Alt+N: Open the Insert tab
  27. Alt+P: Go to the Page Layout tab
  28. Alt+M: Go to the Formulas tab
  29. Alt+A: Go to the Data tab
  30. Alt+R: Go to the Review tab
  31. Alt+W: Go to the View tab
  32. Alt+X: Go to the Add-ins tab
  33. Alt+Y: Go to the Help tab
  34. Ctrl+Tab: Switch between open workbooks
  35. Shift+F3: Insert a function
  36. Alt+F8: Create, run, edit, or delete a macro
  37. Alt+F11: Open the Microsoft Visual Basic For Applications Editor
  38. Left/Right Arrow: Move one cell to the left or right
  39. Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row
  40. Up/Down Arrow: Move one cell up or down
  41. Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column
  42. Tab: Go to the next cell
  43. Shift+Tab: Go to the previous cell
  44. Ctrl+End: Go to the most bottom right used cell
  45. F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name.
  46. Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
  47. Ctrl+Home: Move to the beginning of a worksheet
  48. Page Up/Down: Move one screen up or down in a worksheet
  49. Alt+Page Up/Down: Move one screen to the right or left in a worksheet
  50. Ctrl+Page Up/Down: Move to the previous or next worksheet
  51. Shift+Left/Right Arrow: Extend the cell selection to the left or right
  52. Shift+Space: Select the entire row
  53. Ctrl+Space: Select the entire column
  54. Ctrl+Shift+Space: Select the entire worksheet
  55. F2: Edit a cell
  56. Shift+F2: Add or edit a cell comment
  57. Ctrl+X: Cut contents of a cell, selected data, or selected cell range
  58. Ctrl+C or Ctrl+Insert: Copy contents of a cell, selected data, or selected cell range
  59. Ctrl+V or Shift+Insert: Paste contents of a cell, selected data, or selected cell range
  60. Ctrl+Alt+V: Open the Paste Special dialog box
  61. Delete: Remove the contents of a cell, selected data, or selected cell range
  62. Alt+Enter: Insert a hard return within a cell (while editing a cell)
  63. F3: Paste a cell name (if cells are named in the worksheet)
  64. Alt+H+D+C: Delete column
  65. Esc: Cancel an entry in a cell or the formula bar
  66. Enter: Complete an entry in a cell or the formula bar
  67. Formatting Cells
  68. Ready to format some cells? These keyboard shortcuts make it easier!
  69. Ctrl+B: Add or remove bold to the contents of a cell, selected data, or selected cell range
  70. Ctrl+I: Add or remove italics to the contents of a cell, selected data, or selected cell range
  71. Ctrl+U: Add or remove underline to the contents of a cell, selected data, or selected cell range
  72. Alt+H+H: Select a fill color
  73. Alt+H+B: Add a border
  74. Ctrl+Shift+&: Apply outline border
  75. Ctrl+Shift+_ (Underline): Remove outline border
  76. Ctrl+9: Hide the selected rows
  77. Ctrl+0: Hide the selected columns
  78. Ctrl+1: Open the Format Cells dialog box
  79. Ctrl+5: Apply or remove strikethrough
  80. Ctrl+Shift+$: Apply currency format
  81. Ctrl+Shift+%: Apply percent format

Comments

Post a Comment

Popular Posts

Top Secret Codes For Android.

Image
If you use any android phone you are already aware of all the options supported by this platform, but there are some tricks that maybe you don’t know. Then this article will help you with android secret codes. We can say that there are hidden functions because every end user doesn’t know more about this codes. Developer, Technical Person and Experts Person know how to use this codes. Some of these codes are universal and work on almost any Android headset and Others are only supported by specific manufacturers. The codes contain numeric sequences or symbols that let you access the system settings for a variety of purposes. It is very important to know that some of the codes are a bit extreme. Some of them wipe your entire smartphone and factory reset it, so be cautious while inputting them. Read the description and then go on a code entering spree. let’s start with great Android secret codes. Secret codes android *#*#4636#*#* Display information about Phone, Battery, and Usa...
Read more

How to Download and Install GTA V (GRAND THEFT AUTO 5) in ANDROID/Mobiles?

Image
          GRAND THEFT AUTO 5.                     Grand Theft Auto V (also known as Grand Theft Auto Five, GTA 5 or GTA V) is a video game developed by Rockstar North . It is the fifteenth instalment in the Grand Theft Auto series and the successor of Grand Theft Auto IV . The original edition was released on September 17th, 2013 for the Xbox 360 and PlayStation 3. The Xbox One and PlayStation 4 versions were released on November 18th, 2014, and was later released on April 14th, 2015 for the PC. The original edition was announced on October 25th, 2011; the game's first trailer was released on November 2nd, 2011, at 4:00 PM GMT. The game was initially slated for a Spring 2013 release and there were even posters printed saying this but was delayed until September 17th the same year. Then, on July 15th, 2013, Rockstar announced the Japanese release date for the game: October 10th, 2013, almost a month after...
Read more

Android VS iOS.

Image
Android : Android  is a mobile operating system developed by Google, based on a modified version of the Linux kernel and other open source software and designed primarily for touchscreen mobile devices such as smartphones and tablets. In addition, Google has further developed Android TV for televisions, Android Auto for cars, and Wear OS for wrist watches, each with a specialized user interface. Variants of Android are also used on game consoles, digital cameras, PCs and other electronics. Initially developed by Android Inc., which Google bought in 2005, Android was unveiled in 2007, with the first commercial Android device launched in September 2008. The operating system has since gone through multiple major releases, with the current version being 8.1 "Oreo", released in December 2017. The core Android source code is known as Android Open Source P...
Read more

How to install whatsapp in PC/Laptop.

Image
Whatsapp is the most famous messaging application right now in the smartphone world with nearly 1 billion active users worldwide. Almost every OS has Whatsapp application in their store like iOS, Android, Windows, Symbian. Whatsapp reduced the usage of regular SMS among people. The best thing about Whatsapp is it not only allows you to convey the messages but also it allows you to share images, videos, files, etc.You don’t have to worry about the message delivery like in the Normal SMS. Whatsapp will deliver your messages instantly if the opponent has Active data or WiFi. With regular updates, it’s getting better and better, read the New Hide Last Seen update here. Good News is we can use Whatsapp Messenger application now even in our PC or Laptop. It will be very useful when we have issues with our smartphone.So in this article, we are going see How to install and use Whatsapp on PC or Laptop with step by step instructions. Step 1: Download Thin BlueStacks App Player ...
Read more

Cheats and Guides - GTA 5.

Image
          GTA 5 Cheats PS4 and PS3 GTA 5 Cheats           Note - Xbox One/Xbox 360 GTA 5 cheats are below this list. Scroll down to find them all.            Weapon Cheats for GTA 5 PS4 and PS3 Choose your weapon:  ∆ - RT - LEFT - LB - A - RIGHT - Y - DOWN - X - LB - LB - LB             Speed-ups Fast Run:  ∆ - Left - Right - Right - L2 - L1 - [] Fast Swim:  Left - Left - L1 - Right - Right - R2 - Left - L2 - Right             Ammo Booster GTA 5 Cheats Explosive Melee:  Right - Left - X - ∆ - R1 - O - O - O - L2 Explosive Rounds:  Right - [] - X - Left - R1 - R2 - Left - Right - Right - L1 - L1 - L1 Flame Rounds:  L1 - R1 - [] - R1 - Left - R2 - R1 - Left - [] - Right - L1 - L1 Player Tweaks GTA 5 Cheats: Invincibility:  Right - X - Right - Left - Right - R1 - Right - Left, X - ∆ Restore H...
Read more

Best Upcoming Hindi Movie 2019 - Ek Ladki Ko Dekha Toh Aisa Laga..

Image
  Ek Ladki Ko Dekha Toh Aisa Laga.   ( How I Felt When I Saw That Girl ) is an upcoming Indian Hindi-language coming-of-age film directed by Shelly Chopra Dhar. The tagline as shown on the released film trailer and poster is 'The most unexpected romance of the year'. It stars Sonam Kapoor, Anil Kapoor, Juhi Chawla, and Rajkummar Rao, and also features Akshay Oberoi, Regina Cassandra, Brijendra Kala and Madhumalti Kapoor in supporting roles. Produced by Vinod Chopra Films and distributed by Fox Star Studios, the film will release on 1 February 2019. Directed By:       Shelly Chopra Dhar. Produced By:     Vidhu Vinod Chopra. Written By :        Gazal Dhaliwal,  Shelly Chopra Dhar. Starring:             Sonam Kapoor,                            Anil...
Read more