Easy shortcut keys for MS Excel 2010

MS Excel is the Spread sheet application used for storing data in an organized manner designed by Microsoft; these are a very important part of every business activities. Most of the companies decisions depends on the data maintained on these excel spreadsheets. Since, it’s a widely and regularly used application; there will be desperate need for some shortcuts to make work easy and slick. As an alternative to using mouse, you can also use keyboard to operate on excel 2010 spreadsheets. These shortcut keys provide easy and faster navigation on the excel spreadsheet. Literally, there are hundreds of shortcuts exists and effective usage of these will make the work simpler and much faster as compared to use of mouse.

Shortcut keys are commonly accessed through ALT, CTRL, SHIFT keys etc. There is a standard called de facto standard, which has set some rules or standards to use these shortcuts. According to this, a shortcut key must be in the format as; modifier key, a plus symbol followed by a single character. For example, “Ctrl + U” (underline the specific word or text selected) indicates you to press Control key and press U holding the control key. Some of the most commonly used shortcuts are “Ctrl + A” to select all the contents on the spreadsheets, “Ctrl + C” copies the selected content to the clip board, “Ctrl + V” is used to paste the copied contents, “Ctrl + X” to cut the selected data from the excel 2010 etc. These are the few common shortcuts; some of the other short cut keys that can be used are as listed in the table below:

Table 1: List of frequently used short cuts for Excel 2010

Press To Perform this action….
F1 Universal help for all Windows based applications
F2 Edit the active cell and positions the cursor at the end of the cell contents
F4 Repeats the last action performed
F5 Move to a specific place on a Spread sheet
F7 To check the spelling of the word in the cell
Shift+F3 Inserts cells, rows and columns
Alt+Shift+F1 Inserts a new worksheet  (Same as SHIFT + F)
SHIFT + F10 Displays the shortcut menu
CTRL + F1 Minimize or Restore the Ribbon on the worksheet
CTRL + F3 Name a particular cell in a worksheet
CTRL + F4 Close the Window i.e. spreadsheet
CTRL + F10 Maximize the window
CTRL + F12 Open a file
CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed.
CTRL+Y Repeats the last command or action, if possible.
Shift + Delete Cut selected item.
Ctrl + Insert Copy selected item
Shift + Insert Paste
Ctrl + P Print the current page or document.
Home Goes to beginning of current line.
Ctrl + Home Goes to beginning of document.
CTRL + Page Up Switches between worksheet tabs, from left-to-right.
CTRL+ Page Down Switches between worksheet tabs, from right-to-left.
CTRL+ SHIFT+ Plus (+) Displays the Insert dialog box to insert blank cells.
CTRL + Minus (-) Displays the Delete dialog box to delete the selected cells.
Ctrl + F Find a specific text or a word in the spreadsheets
CTRL+W Close  (Same as Alt + F4)
Alt + F File menu options in current worksheet
Alt + E Edit options in current worksheet

These are the few commonly used shortcuts in excel 2010. Until you are used to these shortcuts you, feel difficulty in remembering these. But, as you keep using these shortcuts every day, you can get a hold on them.

Apart from these advantages, usage of these sometimes lands you in some distressing situations. As mentioned in the above table (i.e. Table 1) there are some short cuts like “Ctrl + X”, “Shift + Delete”, “Ctrl + Minus (-)” and others, which are used to cut some cells, delete the row or a column. While using these or other similar shortcuts you need to be very cautious and make sure you are deleting the correct row or cell, else you will lose your vital data from the excel sheets. Also, in case of using “CTRL+Y” which repeats the previous action, and you have used “DELETE” option or “Ctrl + X” previously and forgot, you will lose your data.

Hence, whenever you use such shortcuts be cautious as there are chances of losing your data. If in case you lose your vital data you can make use of data recovery tool like Remo Recover Windows, which is capable of regaining lost or deleted Excel file within minutes.

Easy shortcut keys for MS Excel 2010 was last modified: April 24th, 2013 by Tony Landry
24 comments on “Easy shortcut keys for MS Excel 2010
  1. Hair Chalk says:

    I haven’t checked in here for some time as I thought it was getting boring, but the last several posts are great quality so I guess I will add you back to my daily bloglist. You deserve it my friend :)

  2. Joe says:

    I think every business uses Microsoft Excel spreadsheets in one way or another. I use it every single day for various uses ranging from, keeping track of certain budgets or tabs to keeping contacts or access codes to all my website memberships. I love it because it is such a versatile program that you can customize it to function however you need it to.

  3. Edward says:

    I appreciate there being a cheat sheet of sorts filled with Excel short cuts. When you know just a few of these shortcuts, it can save you a lot of time over the long haul and also save you lots of frustration. I can’t tell you how many times my momentum used to get stopped because I had to go into the help menu or look up a search engine to find out simple little functions. Thankfully I am now more proficient.

  4. Ann says:

    This is a pretty good short cut cheat sheet. But it left out my favorite Excel short cut, and it happens to be my favorite only because I use it constantly every day. It may not be a function that most people use, but it certainly makes my work life much easier. The magic happens when you press: “CNTRL + SHIFT + ; ” (semi colon). When you press those keys in a cell, it places the current time into the cell where your cursor is on.

  5. Michael says:

    Excel is something that I use a lot so this blog came in handy today. Do you know if there are shortcut keys for when you want to insert a formula? Thank you for putting this together you did a great job and I look forward to seeing your next post. Keep up the good work you will reach many people with this kind of post.

  6. Karen says:

    It only makes sense to start speeding up the way you use Office Excel by setting it up to reflect your personal needs. I do this by opening Options from the Tools menu, File ribbon or Office button, then work your way through the options on offer. Set up how many worksheets you prefer new workbooks to contain from the General section, and choose a default format and location new files are saved to from the Save section.

  7. Amy says:

    This is great I want to use these as much as I can because short cuts actually do cut down the time that you spend making formulas and things like spreadsheets. Thank you for posting this I look forward to using this in my excel class in about a month. I never thought I would be teaching one but this kind of stuff will help, please keep posting.

  8. Rodney says:

    I love short cut keys they are the bomb when you are cruising through a spreadsheet and you are transferring data etc. thank you for doing this post I haven’t seen a lot of these shortcuts before but this list is a great one. I will save this and return to your blog for more information in the future. Keep up the good work.

  9. Kristina says:

    In this busy era, I think that keyboard shortcuts are heaven-sent tools for both myself as well as for most professionals. These shortcuts help teachers, professors, students, professionals, and just about anyone who uses computers on a daily basis. In a typical office environment, especially if you go through a temp agency, knowing these shortcuts can mean your getting a job over another candidate who might not possess these speedy shortcuts. And temp agencies do test for speed.

  10. Christina says:

    Excel formulas are great for working out “What if scenarios that compare calculations based on changing data. Once the formula is entered, you need only change the amounts to be calculated. You don’t have to keep entering “plus this” or “minus that like you do with a regular calculator. I also like using this software for keeping track of my earnings and spending. If you work the formulas right, it can be quite powerful.

  11. Christina says:

    I use excel quite often and the more I learn about it the more I like it and will continue to use it. I think excel is far easier to use then access ever was however there are people that feel the opposite of me. You have put together a lot of information here and I will save it for future use of excel in the near future. Keep up the good work.

  12. Kristina says:

    In the movies, when you see someone typing in the computer, or using it somehow, did you notice that the actors never use the mouse? This is even more evident in CSI. You maybe think that that is just film, and maybe it is, abut it is also true that it is much efficient, practical and healthy to use the keyboard instead of the mouse. And these short cuts are a good list of the most useful ones.

  13. Robert says:

    Excel is a foundational skill required in most business jobs. Take a look at monster.com and enter Excel as a search criteria. You will find the number of jobs that actively list Excel as a required job skill is very large. On one day in which 5,414 new jobs were posted, 2,157 had Excel listed as a requirement. That’s 40% of the jobs listed, second only to the number requiring Word.

  14. Roderick says:

    If you sit in front of a computer screen all day creating reports in Microsoft Excel, you know the power of this software package. But if you aren’t using macros yet, you don’t know the half of it. Sure, knowing the short cuts is important and it is a part of what makes you efficient and fast with this spread sheet program. But Macros further increase your speed because it automates common and repetitive keystrokes that you use in Excel.

  15. Michele says:

    Your efficient use of Excel can turn a three hour payroll calculating chore or a five hour reporting task into a five minute breeze. You save a lot of time. That time adds up to extra time for your more enjoyable endeavors in life such as vacations! In addition, your bosses and employees will notice that you are efficient and can produce professional looking reports that impress. Employers are like dry sponges ready to soak up any job candidate that can make their entity more efficient with Excel skills!

  16. Dana says:

    I’m decent in excel but nowhere as good as I’d like to be. I don’t even know what i need to learn besides brushing up on macro’s. pivot tables and certainly shortcuts like the ones here, but besides that i don’t know what to work on. i would really prefer something with exercises at the end to cement in the knowledge. I will try navigating through some of the links on this site just in case there are any other tutorials.

  17. Martha says:

    In PPC Management, Excel is a must-have tool. Building keyword lists, writing ad copy, analyzing data and preparing reports – all these tasks mostly done using Excel. Most of our optimization time we spend cranking Excel spreadsheets and log in AdWords or adCenter web-UI only to get status updates or make some minor changes. Don’t get me wrong: same tasks can be performed in the web-UI, but Excel allows us to streamline the process and get a better use of our time.

  18. Joseph says:

    I took a class on Excel and everything that you could do with it and I have to say they didn’t teach us about all of these short cuts like this. I did learn about formulas and spread sheets and data calculation and things like that, but this would have helped a lot I think. I wonder if they skip this stuff simply because they want you to learn the long form first?

  19. Neil says:

    Most Excel files are small enough not to affect performance, but size isn’t the only thing that can slow things down. Fortunately, you don’t have to know all about multithreads and dual processors to eliminate bad performance. The tips on this page seem easy to implement, so even the most casual users can improve performance when a workbook slows down. Better yet, apply this advice when designing sheets to help avoid sluggish performance altogether.

  20. Robert says:

    Excel is something that I use all the time and having these shortcuts has made it even more efficient as far as time and everything goes. You can do so much with Excel it is a wonder that they didn’t publish these shortcuts a long time ago. And who the heck sets around and comes up with these in the first place, where do you get that job?

  21. Cristobal says:

    I have started using these short cuts in my everyday life of being an office manager and I have to say this has made my life a lot easier. At first however it was frustrating getting to learn these things and what was going to happen, like macros. But after you get it down it is a lot easier than doing this stuff the long way. Thank you for the tips.

  22. Debra says:

    I think you can increase your speed by using tables. Starting with Excel 2007 you can keep all the related data in a table. For example call center data in our recent dashboard is kept in a table. Tables can be used in formulas with structural references, can be used as a source for pivot tables etc. And since tables grow & shrink as you add / remove data, none of your formulas need to be dynamic.

  23. Essie says:

    I have been using these shortcuts for some time now and I have to say I like them, it makes my job as an accountant with spread sheets and things a lot easier. You have done great work on this post and the time that you must have put into this shows that you really know your stuff and want to help others. Great job keep it up because I will return for more.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>