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.
Tony Landry is a Web Content Editor at Remo Software. He loves to write, edit, and manage content for users trying to troubleshoot and fix problems on Windows, Outlook, storage drives and Cloud storage networks.
He has published more than 200 articles in Remo Software blog. He actively engages in research and problem-solving techniques to consistently generate great web content. Fixing various hardware problems on computer and storage devices along with a great knack for fixing Outlook errors, Tony is also the fun-time IT guy for all his work friends. He lives in the San Francisco Bay Area and enjoys cycling.