SOME USEFUL SHORTCUT KEYS FOR MS WORD AND EXCEL

9 USEFUL shortcut keys for excel

1. Inserting the total ….. "alt" + =

2. Inserting the correct time….. "Ctrl" + "shift" + ";"

3. Inserting the correct date….. "Ctrl" + ";"

4. Highlighting a column…. "Ctrl" + "space bar"

5. Highlighting a row….. "shift" + "space bar"

6. Removing a column…. "Ctrl" + "0"

7. Removing a row… "Ctrl" + "9"

8. A new line in a cell…. "Alt" + "enter"

9. Show/hide formula…. "Ctrl" + "~"

14 useful keyboard shortcuts in word

1. Change font size: “Ctrl” + “[“ for increasing font, or  ”]” for reducing font

2. Change letter case: “Ctrl” + “shift” + “A”

3. Change to bold: “Ctrl” + “B”

4. Change to italic: “Ctrl” + “I”

5. Underline text: “Ctrl” + “U”

6. Change text alignment: “Ctrl” + “E”, “Ctrl” + “R” , Ctrl+L, Ctrl+J

7. Copy/paste formatting…. "Ctrl" + "shift" + "C", "Ctrl" + "shift" + "V"

8. Remove formatting…. "Ctrl" + "shift" + "N"

9. Insert time…. "Ctrl" + "shift" + 'T"

10. Insert date…. "Alt" + "shift" + "D"

11. Print document… "Ctrl"  + "P"

12. Insert hyperlink… "Ctrl" + "K"

13. Insert page break…. "Ctrl" + "enter"

14. Highlight vertically…. 'Alt' then move the mouse