Boost Your Computer Awareness: 25 Shortcuts for Microsoft Excel

Dear Reader, Here is your 25 important shortcuts for Microsoft Excel.

Shortcut Keys Using Ctrl key:

1. Ctrl + A – Select all contents of the worksheet.
2. Ctrl + B – Bold highlighted selection.
3. Ctrl + I – Italic highlighted selection.
4. Ctrl + U – Underline highlighted selection.
5. Ctrl + P – Displays the print dialog box to begin printing.
6. Ctrl + Z – Undo last action.
7. Ctrl + K – Insert link.
8. Ctrl + 5 – Strikethrough highlighted selection.
9. Ctrl + F3 – Open Excel Name Manager.
10. Ctrl + F9 – Minimise current workbook.
11. Ctrl + F10 – Maximise currently selected workbook.
12. Ctrl + ‘ – Insert the value of the above cell into cell currently selected.
13. Ctrl + Space – Select entire column.
14. Ctrl + Shift + = – Insert a new column or row.
15. Ctrl + Home – Move to cell A1.
16. Ctrl + Tab – Move between two or more open Excel files.

Shortcut Keys Using Function key:

17. F2 – Edit the selected cell.
18. F5 – Go to a specific cell.
19. F7 – Spell check selected text and/or document.
20. F11 – Create chart from selected data.

Shortcut Keys Using Shift Key:

21. Shift + F3 – Open the Excel formula window.
22. Shift + F5 – Bring up search box.
23. Shift + Space – Select entire row.

Shortcut Keys Using Alt key:

24. Alt + = – Create a formula to sum all of the above cells.
25. Alt +Shift + F1 – Insert new worksheet.

You can type your doubts in the comments section below. You can also suggest improvements to the above tutorial