The shortcut keys will speed up the work by avoiding mouse clicks. Remembering these shortcut keys may be difficult, but by regular practice we can develop the habit of using short cut keys.
Following are the 10 shortcut keys to speedup your work.
|
1
|
Ctrl+Space and Shift+Space
|
these are the short cut keys used for selection of cell. Ctrl+Space will select the entire column of selected cells. Shift+Space is used to select the rows of selected cells.
|
|
2
|
Ctrl+Shift+-
|
Ctrl+Shift+- is used to remove the borders in a table or in cells.
|
|
3
|
Ctrl+Shift+7
|
Ctrl+Shift+7 can be used to put the outline border for selected cells.
|
|
4
|
Ctrl+D and Ctrl+R
|
Ctrl+D is used to copy and paste the content of the above cell. Ctrl+R is used to copy and paste the contents of the cell which is left to the selected cell.
|
|
5
|
Ctrl+Shift+5
|
Ctrl+Shift+5 will change the format of the cell to percentage (%) format.
|
|
6
|
Ctrl+Shift+3
|
Ctrl+Shift+3 convert the format of the cell to date in dd-mmm-yy
|
|
7
|
Ctrl+; and Ctrl+Shift+;
|
Ctrl+; enters the system date in the selected cell, and Ctrl+Shift+; enters the system time in the selected cell.
|
|
8
|
Ctrl+9 and Ctrl+Shift+9
|
Ctrl+9 will hide the rows of selected cells and Ctrl+Shift+9 will unhide the rows in selected cells.
|
|
9
|
Ctrl+0 and Ctrl+Shift+0
|
Ctrl+0 will hide the columns of selected cells and Ctrl+Shift+0 will unhide the columns in selected cells.
|
|
10
|
Ctrl+[ and Ctrl+]
|
Ctrl+[ will trace precedents in excel formula and Ctrl+] will trace dependents in excel formula
|