Excel Shortcuts

Excel Shortcut Keys

Control Combination Excel Shortcut keys

 

CTRL+SHIFT+( Unhides any concealed columns inside the determination.
CTRL+SHIFT+) Unhides any concealed sections in the decision.
CTRL+SHIFT+& Applies the characterize fringe to the chose cells.
CTRL+SHIFT_ Removes the layout outskirt from the picked cells.
CTRL+SHIFT+~ Applies the General assortment design.
CTRL+SHIFT+$  Applies the Currency design with two decimal spots (horrendous numbers in enclosures).
CTRL+SHIFT+%  Applies the Percentage organize and not utilizing a decimal areas.
CTRL+SHIFT+^ Applies the Exponential territory format with decimal spots.
CTRL+SHIFT+#  Applies the Date arrange with the day, month, and a year.
[email protected]  Applies the Time arrange with the hour and minute, and AM or PM.
CTRL+SHIFT+! Applies the Number arrangement with two decimal areas, hundreds separator, and short flag (- ) for negative esteems.
CTRL+SHIFT+* Selects the cutting edge zone over the dynamic portable (the certainties put encased by clear lines and clear segments). In a PivotTable, it chooses the total PivotTable report.
CTRL+SHIFT+: Enters the present day time.
CTRL+SHIFT+” Copies the charge from the versatile over the dynamic portable into the versatile or the Formula Bar.
CTRL+SHIFT+Plus (+)  Displays the Insert discussion field to embed clear cells.
CTRL+Minus (- ) Displays the Delete exchange holder to erase the picked cells.
CTRL+; Enters the cutting edge date.
CTRL+` Alternates between showing versatile esteems and demonstrating equations inside the worksheet.
CTRL+’ Copies a recipe from the versatile over the energetic portable into the cell or the Formula Bar.
CTRL+1 Displays the Format Cells discussion compartment.
CTRL+2 Applies or disposes of strong arranging.
CTRL+3 Applies or disposes of italic arranging.
CTRL+4 Applies or disposes of underlining.
CTRL+5 Applies or evacuates strikethrough.
CTRL+6 Alternates among concealing articles, showing devices, and indicating placeholders for devices.
CTRL+eight Displays or shrouds the framework images.
CTRL+nine Hides the chose lines.
CTRL+0 Hides the chose segments.
CTRL+A  Selects the entire worksheet. On the off chance that the worksheet contains measurements, CTRL+A chooses the contemporary territory. Squeezing CTRL+A a second time chooses the bleeding edge area and its rundown columns. Squeezing CTRL+A a third time chooses the entire worksheet.  At the point when the addition factor is to one side of a capacity bring in a definition, demonstrates the Function Arguments exchange compartment.
CTRL+SHIFT+A  Embeds the contention names and enclosures when the inclusion factor is to one side of an element name in a framework.
CTRL+B Applies or disposes of eager designing.
CTRL+C Copies the selected range related cells.
CTRL+C saw through some other CTRL+C shows the Clipboard.
CTRL+D Uses the Fill Down summon to repeat the substance and organization of the highest versatile of a chose go into the cells under.
CTRL+F Displays the Find and Replace exchange box, with the Find tab chose.
SHIFT+F5  Additionally demonstrates this tab, even as SHIFT+F4 rehashes the rest of the Find activity.
CTRL+SHIFT+F opens the Format Cells discourse box with the Font tab chose.
CTRL+G Displays the Go To discourse compartment.
F5 Likewise shows this exchange box.
CTRL+H  Displays the Find and Replace exchange compartment, with the Replace tab chose.
CTRL+I Applies or takes out italic arranging.
CTRL+K Displays the Insert Hyperlink discussion box for fresh out of the box new connections or the Edit Hyperlink discussion field for settled on show joins.
CTRL+N Creates a fresh out of the plastic new, clear exercise manual.
CTRL+O  Displays the Open discussion box to open or discover a document.
CTRL+SHIFT+O chooses all cells that involve remarks.
CTRL+P  Displays the Print exchange field.
CTRL+SHIFT+P Opens the Format Cells discussion box with the Font tab settled on.
CTRL+R  Uses the Fill Right summon to repeat the substance and organization of the furthest left cell of a chose run into the cells to the correct.
CTRL+S Saves the  report with its present record name, territory, and archive format etc.
CTRL+T Displays the Create Table discourse compartment.
CTRL+U Applies or disposes of underlining.
CTRL+SHIFT+U Switches amongst expanding and crumbling of the recipe bar.
CTRL+V Inserts the substance of the Clipboard on the inclusion point and replaces any decision. Accessible simply after you have decrease or duplicated a thing, literary substance, or cell substance.
CTRL+W  Closes the picked exercise manual window.
CTRL+X  Cuts the picked cells.
CTRL+Y Repeats the last order or movement, if conceivable.
CTRL+Z Uses the Undo order to inverse the end charge or to erase the last access which you wrote.
CTRL+SHIFT+Z  makes utilization of the Undo or Redo summon to inverse or repair the end mechanized rectification when AutoCorrect Smart Tags are shown

Function keys in Excel Shortcut keys

 

F1 Displays the Microsoft Office Excel Help errand sheet.
CTRL+F1 Shows or conceals the strip.
ALT+F1 Makes an outline of the information in the present range.
ALT+SHIFT+F1 Embeds another worksheet.
F2 Edits the dynamic cell and positions the addition point toward the finish of the cell substance. It likewise moves the addition point into the Formula Bar when altering in a phone is killed.
SHIFT+F2 Includes or alters a cell remark.
CTRL+F2 Shows the Print Preview window.
F3 Displays the Paste Name exchange box.
SHIFT+F3 Shows the Insert Function discourse box.
F4 Repeats the last charge or activity, if conceivable.
CTRL+F4 Shuts the chose exercise manual window.
F5 Displays the Go To exchange box.
CTRL+F5 Reestablishes the window size of the chose exercise manual window.
F6 Switches between the worksheet, strip, assignment sheet, and Zoom controls. In a worksheet that has been part (View menu, Manage This Window, Freeze Panes, Split Window order), F6 incorporates the split sheets when exchanging amongst sheets and the lace region.
SHIFT+F6 Can be used to switch between the worksheet, Zoom the controls, assignment of sheet, and lace.
CTRL+F6 Changes to the following exercise manual window when in excess of one exercise manual window is open.
F7 Displays the Spelling discourse box to check spelling in the dynamic worksheet or chose run.
CTRL+F7 Plays out the Move summon on the exercise manual window when it isn’t augmented. Utilize the bolt keys to move the window, and when completed press ENTER, or ESC to wipe out.
F8 Turns broaden mode on or off. In expand mode, Extended Selection shows up in the status line, and the bolt keys broaden the choice.
SHIFT+F8 Empowers you to include a nonadjacent cell or range to a choice of cells by utilizing the bolt keys.
CTRL+F8 Plays out the Size charge (on the Control menu for the exercise manual window) when an exercise manual isn’t expanded.
ALT+F8 Shows the Macro exchange box to make, run, alter, or erase a full scale.
F9 Calculates all worksheets in every open exercise manual.
SHIFT+F9 Ascertains the dynamic worksheet.
CTRL+ALT+F9 Ascertains all worksheets in every single open exercise manual, paying little heed to whether they have changed since the last estimation.
CTRL+ALT+SHIFT+F9 Rchecks subordinate recipes, and after that ascertains all cells in every single open exercise manual, including cells not set apart as waiting be computed.
CTRL+F9 Limits an exercise manual window to a symbol.
F10 Turns key tips on or off.
SHIFT+F10 Shows the easy route menu for a chose thing.
ALT+SHIFT+F10 Shows the menu or message for a savvy tag. In the event that in excess of one shrewd tag is available, it changes to the following keen tag and shows its menu or message.
CTRL+F10 Amplifies or reestablishes the chose exercise manual window.
F11 Creates a graph of the information in the present range.
SHIFT+F11 Embeds another worksheet.
ALT+F11 Opens the Microsoft Visual Basic Editor, in which you can make a large scale by utilizing Visual Basic for Applications (VBA).
F12 Displays the Save As exchange box.

Frequently Useful Excel shortcut keys

 

AERO KEYS Move one cell up, down, left, or right in a worksheet.
CTRL+ARROW KEY Moves to the edge of the present information locale (information district: A scope of cells that contains information and that is limited by discharge cells or datasheet fringes.) in a worksheet.
SHIFT+ARROW KEY Expands the choice of cells by one cell.
CTRL+SHIFT+ARROW KEY Stretches out the choice of cells to the last nonblank cell in an indistinguishable segment or line from the dynamic cell, or if the following cell is clear, stretches out the determination to the following nonblank cell.
LEFT ARROW or RIGHT ARROW Chooses the tab to one side or right when the lace is chosen. At the point when a submenu is open or chose, these bolt keys switch between the fundamental menu and the submenu. At the point when a strip tab is chosen, these keys explore the tab catches.
DOWN ARROW or UP ARROW Chooses the following or past charge when a menu or submenu is open. At the point when a strip tab is chosen, these keys explore up or down the tab gathering. In a discourse box, bolt enters move between alternatives in an open drop-down rundown, or between choices in a gathering of choices.
DOWN ARROW or ALT+DOWN ARROW Opens a chose drop-down rundown. Delete one character to one side in the Formula Bar. Additionally clears the substance of the dynamic cell. In cell altering mode, it erases the character to one side of the addition point. Erase Removes the cell substance (information and recipes) from chose cells without influencing cell arrangements or remarks. In cell altering mode, it erases the character to one side of the inclusion point.
END Moves to the cell in the at the end, if SCROLL LOCK is turned on. Additionally chooses the keep going summon on the menu when a menu or submenu is unmistakable.
CTRL+END Moves to the keep going cell on a worksheet, in the most reduced utilized line of the furthest right utilized segment. On the off chance that the cursor is in the recipe bar, CTRL+END moves the cursor to the finish of the content.
CTRL+SHIFT+END Stretches out the choice of cells to the keep going utilized cell on the worksheet (bring down right corner). On the off chance that the cursor is in the recipe bar,
CTRL+SHIFT+END Chooses all content in the equation ban from the cursor position to the end—this does not influence the tallness of the equation bar.
ENTER Completes a cell passage from the cell or the Formula Bar, and chooses the cell beneath (as a matter of course). In an information shape, it moves to the principal field in the following record. Opens a chose menu (press F10 to enact the menu bar) or plays out the activity for a chose summon. In an exchange box, it plays out the activity for the default summon catch in the discourse box (the catch with the strong layout, frequently the OK catch).
ALT+ENTER Begins another line in a similar cell.
CTRL+ENTER Fills the chose cell extend with the present passage.
SHIFT+ENTER Finishes a cell section and chooses the cell above.
ESC Cancels a section in the cell or Formula Bar. Shuts an open menu or submenu, exchange box, or message window. It likewise closes full screen mode when this mode has been connected, and comes back to ordinary screen mode to show the Ribbon and status bar once more.
HOME Moves to the start of a column in a worksheet. Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on. Selects the primary order on the menu when a menu or submenu is unmistakable.
CTRL+HOME Moves to the start of a worksheet.
CTRL+SHIFT+HOME Stretches out the choice of cells to the start of the worksheet.
PAGE DOWN Moves one screen down in a worksheet.
ALT+PAGE DOWN Moves one screen to one side in a worksheet.
CTRL+PAGE DOWN moves to the following sheet in an exercise manual.
CTRL+SHIFT+PAGE DOWN chooses the present and next sheet in an exercise manual.
PAGE UP Moves one screen up in a worksheet.
ALT+PAGE UP Moves one screen to one side in a worksheet.
CTRL+PAGE UP Moves to the past sheet in an exercise manual.
CTRL+SHIFT+PAGE UP Chooses the present and past sheet in an exercise manual.
SPACEBAR In a discourse box, plays out the activity for the chose catch, or chooses or clears a check box.
CTRL+SPACEBAR Chooses a whole segment in a worksheet.
SHIFT+SPACEBAR Chooses a whole line in a worksheet.
CTRL+SHIFT+SPACEBAR Chooses the whole worksheet. In the event that the worksheet contains information, CTRL+SHIFT+SPACEBAR chooses the present locale. Squeezing CTRL+SHIFT+SPACEBAR a moment time chooses the present locale and its outline lines. Squeezing CTRL+SHIFT+SPACEBAR a third time chooses the whole worksheet. At the point when a question is chosen, CTRL+SHIFT+SPACEBAR chooses all items on a worksheet.
ALT+SPACEBAR Shows the Control menu for the Microsoft Office Excel window.
TAB Moves one cell to one side in a worksheet. Moves between opened cells in an ensured worksheet. Moves to the following choice or alternative gathering in an exchange box.
SHIFT+TAB Moves to the past cell in a worksheet or the past choice in a discourse box.
CTRL+TAB Changes to the following tab in discourse box.
CTRL+SHIFT+TAB Changes to the past tab in an exchange box.

Important Excel shortcut keys

Paste Special Alt+H+V+S
Select Entire Row Shift+Spacebar
Select Entire column Ctrl+Spacebar
Delete Entire Row or Column CtrlMinus
Delete Entire Row CtrlMinus
Copy Ctrl+C
Paste Ctrl+V
Paste as values Alt+H+V+S+V+Enter
Paste as Formats Alt+H+V+S+T+Enter
Paste as Formulas Alt+H+V+S+F+Enter
Sorting Alt+A+S+S
Remove duplicates Alt+A+M
Text To Columns Alt+A+E
Select All worksheets Press Ctrl+Shift+Pageup or PageDown
Merge Cells Alt+H+M+C
Unmerge Cells Alt+H+M+C
Autofit Column width Alt+O+C+A
Autofill column Ctrl+D
Autofill Row Ctrl+R
For the above all functions need to select the data CTRL+A or Select only requried rows or Columns

Download important excel shortcut keys in excel workbook

 

74 COMMENTS

  1. Good info and right to the point. I am not sure if this is actually the best place to ask but do you folks have any idea where to get some professional writers? Thx 🙂

    • Thanks 🙂 .
      Yes, I do have some folks who writes by own and charges 500 words 5$. But you will get genuine content based on your criteria

  2. This is very nice blog to teach excel to people and clear cut explanation on every topic with examples. Thank you very much for your smart work about Excel formulas

  3. Excel is ocean as you said in your articles and you took good move to teach excel formula in easy manner by creating excellent articles in your blog. Thank you very much for providing excel formulas over here in this article.

  4. You have some hidden talent to explain in your article, that’s why we are able to understand very easily excel formulas from your blog. Thank you

  5. Whats up! I am about to begin my own blog and was wondering if you know where the best place to purchase a blog url is? I’m not even sure if that’s what its known as? (I’m new to this) I’m referring to “%BLOGURL%”. Exactly how do I go about getting one of these for the website I am making? Cheers

    • Well, you can just use some free theme and start writing your own blog. If it is necessary I can build one for you and give you. If you have interesting stuff.

  6. Heya. Sorry to trouble you but I ran across your blog and discovered you’re using the exact same template as me. The only issue is on my site, I’m unable to get the layout looking like yours. Would you mind e-mailing me at: %EMAIL% so I can get this figured out. By the way I’ve bookmarked your web site: %BLOGURL% and will certainly be visiting often. Thanks!

    • Thanks for visiting my website. If you require, i will try to change your layout. Please reach out me by commenting to this.

  7. Hello there I am so delighted I found your blog, I really found you by accident, while I was browsing on Yahoo for something else, Anyhow I am here now and would just like to say kudos for a fantastic post and a all round interesting blog (I also love the theme/design), I don’t have time to look over it all at the minute but I have book-marked it and also included your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the fantastic work.

  8. Howdy! I understand this is sort of off-topic however I needed to ask. Does operating a well-established blog like yours require a massive amount work? I’m completely new to writing a blog but I do write in my diary on a daily basis. I’d like to start a blog so I can easily share my experience and feelings online. Please let me know if you have any kind of recommendations or tips for brand new aspiring blog owners. Thank you!

    • Just start one blog and write your dairy content to blog which might help visitors to learn lot of things when you have good knowledge.

  9. Hi Blogger, Thank your for your useful information!!!. I am learning each concept on daily basis from your blog. However I became expert in excel after my starting of learning from your blog. Please provide more articles quickly as i am very eager to learn more things from your blog.

  10. I have observed that in your Excel-formula.com blog, videos are clear and crystal clear on excel formulas and VBA programming concepts. There are occasions when it may be extremely hard to explain few topics in excel. But still you have explained in a meaningful manner. Hope you provide more videos and articles in future.

Leave a Reply to Vlookup Rocker Cancel reply

Please enter your comment!
Please enter your name here