MOST USEFUL SHORT CUT KEYS IN MICROSOFT EXCEL AND THEIR USES

We all like to do work in various ways. We all need short-cut in our lives. Some times it may be useful. Sometimes it is very dangerous for us. But short-cut key in Computer gives us success and reduces our valuable time in any work.What are their uses? Are they useful?  So we are now going to discuss about the short-cut keys on keyboard. We apply it in Microsoft excel.

 1. CREATE A FORMULA TO SUM ALL OF THE ABOVE CELLS:

ALT+ =

2. CURRENT DATE:

Ctrl+;

3. CURRENT TIME:

Ctrl+Shift+;

4. SELECT ENTIRE ROWS:

Shift+Space

5. SELECT ENTIRE COLUMNS:

Ctrl+Space

6. HIDE ROWS:

Ctrl+9

7. HIDE COLUMNS:

Ctrl+0

8. DELETE THE SELECTED COLUMN OR ROW:

Ctrl+-

9. NEW LINE INSIDE  A CELL:

Alt+Enter

10. SWITCH BETWEEN SHOWING EXCEL FORMULA OR THEIR VALUE IN CELLS:

Ctrl+'

11. SAVE AS ACTIVE FILE:

F12

12. CREATE CHART FROM SELECT DATA:

F11

13. INSERT NEW WORKSHEET:

Shift+F11

14. MOVE FORWARD BETWEEN WORKSHEETS IN THE SAME DOCUMENTS:

Ctrl+PageDown

15. MOVE BACK BETWEEN WORKSHEETS IN THE SAME DOCUMENTS:

Ctrl+PageDown

16. FORMAT NUMBERS IN COMMA FORMAT:

Ctrl+Shift+1

17. FORMAT NUMBERS IN DATE FORMAT:

Ctrl+Shift+3

18. FORMAT NUMBER IN CURRENCY FORMAT($):

Ctrl+Shift+4

19. FORMAT NUMBER IN PERCENTAGE FORMAT(%):

Ctrl+Shift+5

20. MOVE TO CELL A1:

Ctrl+ Home

For more contents... stay tuned