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.