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.
CTRL+SHIFT+@ 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+1Displays the Format Cells discussion compartment.
CTRL+2Applies or disposes of strong arranging.
CTRL+3Applies or disposes of italic arranging.
CTRL+4Applies or disposes of underlining.
CTRL+5Applies or evacuates strikethrough.
CTRL+6Alternates among concealing articles, showing devices, and indicating placeholders for devices.
CTRL+eightDisplays or shrouds the framework images.
CTRL+nineHides the chose lines.
CTRL+0Hides 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+BApplies or disposes of eager designing.
CTRL+CCopies the selected range related cells.
CTRL+Csaw through some other CTRL+C shows the Clipboard.
CTRL+DUses the Fill Down summon to repeat the substance and organization of the highest versatile of a chose go into the cells under.
CTRL+FDisplays 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+Fopens the Format Cells discourse box with the Font tab chose.
CTRL+GDisplays the Go To discourse compartment.
F5Likewise shows this exchange box.
CTRL+H Displays the Find and Replace exchange compartment, with the Replace tab chose.
CTRL+IApplies or takes out italic arranging.
CTRL+KDisplays 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+NCreates 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+Ochooses all cells that involve remarks.
CTRL+P Displays the Print exchange field.
CTRL+SHIFT+POpens 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+SSaves the  report with its present record name, territory, and archive format etc.
CTRL+TDisplays the Create Table discourse compartment.
CTRL+UApplies or disposes of underlining.
CTRL+SHIFT+USwitches amongst expanding and crumbling of the recipe bar.
CTRL+VInserts 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+YRepeats the last order or movement, if conceivable.
CTRL+ZUses 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

 

F1Displays the Microsoft Office Excel Help errand sheet.
CTRL+F1Shows or conceals the strip.
ALT+F1Makes an outline of the information in the present range.
ALT+SHIFT+F1Embeds another worksheet.
F2Edits 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+F2Includes or alters a cell remark.
CTRL+F2Shows the Print Preview window.
F3Displays the Paste Name exchange box.
SHIFT+F3Shows the Insert Function discourse box.
F4Repeats the last charge or activity, if conceivable.
CTRL+F4Shuts the chose exercise manual window.
F5Displays the Go To exchange box.
CTRL+F5Reestablishes the window size of the chose exercise manual window.
F6Switches 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+F6Can be used to switch between the worksheet, Zoom the controls, assignment of sheet, and lace.
CTRL+F6Changes to the following exercise manual window when in excess of one exercise manual window is open.
F7Displays the Spelling discourse box to check spelling in the dynamic worksheet or chose run.
CTRL+F7Plays 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.
F8Turns broaden mode on or off. In expand mode, Extended Selection shows up in the status line, and the bolt keys broaden the choice.
SHIFT+F8Empowers you to include a nonadjacent cell or range to a choice of cells by utilizing the bolt keys.
CTRL+F8Plays out the Size charge (on the Control menu for the exercise manual window) when an exercise manual isn’t expanded.
ALT+F8Shows the Macro exchange box to make, run, alter, or erase a full scale.
F9Calculates all worksheets in every open exercise manual.
SHIFT+F9Ascertains the dynamic worksheet.
CTRL+ALT+F9Ascertains all worksheets in every single open exercise manual, paying little heed to whether they have changed since the last estimation.
CTRL+ALT+SHIFT+F9Rchecks subordinate recipes, and after that ascertains all cells in every single open exercise manual, including cells not set apart as waiting be computed.
CTRL+F9Limits an exercise manual window to a symbol.
F10Turns key tips on or off.
SHIFT+F10Shows the easy route menu for a chose thing.
ALT+SHIFT+F10Shows 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+F10Amplifies or reestablishes the chose exercise manual window.
F11Creates a graph of the information in the present range.
SHIFT+F11Embeds another worksheet.
ALT+F11Opens the Microsoft Visual Basic Editor, in which you can make a large scale by utilizing Visual Basic for Applications (VBA).
F12Displays the Save As exchange box.

Frequently Useful Excel shortcut keys

 

AERO KEYSMove one cell up, down, left, or right in a worksheet.
CTRL+ARROW KEYMoves 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 KEYExpands the choice of cells by one cell.
CTRL+SHIFT+ARROW KEYStretches 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 ARROWChooses 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 ARROWChooses 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 ARROWOpens 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.
ENDMoves 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+ENDMoves 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+ENDStretches 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+ENDChooses all content in the equation ban from the cursor position to the end—this does not influence the tallness of the equation bar.
ENTERCompletes 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+ENTERBegins another line in a similar cell.
CTRL+ENTERFills the chose cell extend with the present passage.
SHIFT+ENTERFinishes a cell section and chooses the cell above.
ESCCancels 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.
HOMEMoves 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+HOMEMoves to the start of a worksheet.
CTRL+SHIFT+HOMEStretches out the choice of cells to the start of the worksheet.
PAGE DOWNMoves one screen down in a worksheet.
ALT+PAGE DOWNMoves one screen to one side in a worksheet.
CTRL+PAGE DOWNmoves to the following sheet in an exercise manual.
CTRL+SHIFT+PAGE DOWNchooses the present and next sheet in an exercise manual.
PAGE UPMoves one screen up in a worksheet.
ALT+PAGE UPMoves one screen to one side in a worksheet.
CTRL+PAGE UPMoves to the past sheet in an exercise manual.
CTRL+SHIFT+PAGE UPChooses the present and past sheet in an exercise manual.
SPACEBARIn a discourse box, plays out the activity for the chose catch, or chooses or clears a check box.
CTRL+SPACEBARChooses a whole segment in a worksheet.
SHIFT+SPACEBARChooses a whole line in a worksheet.
CTRL+SHIFT+SPACEBARChooses 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+SPACEBARShows the Control menu for the Microsoft Office Excel window.
TABMoves 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+TABMoves to the past cell in a worksheet or the past choice in a discourse box.
CTRL+TABChanges to the following tab in discourse box.
CTRL+SHIFT+TABChanges to the past tab in an exchange box.

Important Excel shortcut keys

Paste SpecialAlt+H+V+S
Select Entire RowShift+Spacebar
Select Entire columnCtrl+Spacebar
Delete Entire Row or ColumnCtrlMinus
Delete Entire RowCtrlMinus
CopyCtrl+C
PasteCtrl+V
Paste as valuesAlt+H+V+S+V+Enter
Paste as FormatsAlt+H+V+S+T+Enter
Paste as FormulasAlt+H+V+S+F+Enter
SortingAlt+A+S+S
Remove duplicatesAlt+A+M
Text To ColumnsAlt+A+E
Select All worksheetsPress Ctrl+Shift+Pageup or PageDown
Merge CellsAlt+H+M+C
Unmerge CellsAlt+H+M+C
Autofit Column widthAlt+O+C+A
Autofill columnCtrl+D
Autofill RowCtrl+R
For the above all functions need to select the dataCTRL+A or Select only requried rows or Columns

 

 

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!

  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

Please enter your comment!
Please enter your name here