Excel Shortcut Keys

As you all are aware shortcut keys are available in any computer application to make the task easier. There is no difference in excel, there are plenty of excel shortcut keys. If you know Excel shortcut keys, you will be much quicker in your work and the people who are looking at you will consider you as an expert in the subject. I have seen many experts, especially in Photo Studios who are mainly working with applications like Photoshop, they only use shortcut keys to get there task done. They rarely touch the mouse. Because of that they work much faster than the average people and it is pleasing to watch them working. This hub is a guide to most important Excel shortcut keys.



Excel shortcut keys to navigate through the worksheet.

NO
Description
Excel Shortcut Keys
1
To come back to the first cell (A1)
CTRL+HOME
2
To go to the last column of worksheet(To count the number of columns)
CTRL+Right Arrow
3
To go to the last row of the worksheet (To count the number of rows)
CTRL+Down Arrow
4
To come back to the first cell off the current row
HOME
5
To save the workbook
CTRL+S
6
To Close the workbook
CTRL+W
7
To open the print dialog box
CTRL+P
8
To open a new workbook
CTRL+N

Excel shortcut keys to edit and review the worksheet

No
Description
Excel Shortcut Keys
1
Spell check the selected area
F7
2
Select the entire worksheet
CTRL+A
3
Select the entire row
SHIFT+SPACE
4
Select the entire column
CTRL+TAB
5
Bold the text in selected cells
CTRL+B
6
Italic the text in selected cells
CTRL+I
7
Underline the text in selected cells
CTRL+U
8
Strikethrough the text in selected cells
CTRL+5
9
Copy the selected cells
CTRL+C
10
Cut the selected cells
CTRL+X
11
Paste the copied cells
CTRL+V
12
Undo the previous action
CTRL+Z
13
Move between the worksheets of the current workbook
CTRL+PageUp/CTRL+PageDown
14
Edit the current cell
F2
15
Goto a specific cell
F5
16
Fill the background of the current cell with the filling of the cell above
CTRL+D
17
Open find and replace dialog box
CTRL+F
18
Open goto dialog box
CTRL+G
19
Insert a link
CTRL+K
 
 
 

Excel shortcut keys to format data

No
Description
Excel Shortcut Keys
1
Format the number in comma format
CTRL+SHIFT+!
2
Format the number in currency format
CTRL+SHIFT+$
3
Format the number in percentage format
CTRL+SHIFT+%
4
Format the number in date format
CTRL+SHIFT+#
5
Format the number in time format
CTRL+SHIFT+@
6
Format the number in scientific format
CTRL+SHIFT+^
7
Insert the current time
CTRL+SHIFT+;
8
Insert the current date
CTRL+;
9
Open the Excel formula window
SHIDT+F3


I am sure many of you know and are using many of the above Excel shortcut keys. But there may be the random shortcut key that you didn't know until now.  I do hope that they will help you increase your productivity and speed. If you know any other useful Excel shortcut key please share it in the comments section.

Other Microsoft Excel related hubs

  • 50 reasons to upgrade to Excel 2007


More by this Author


Comments

No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working