To speed up the work of a teacher and student , we listed here 15 most useful keyboard shortcut keys in Excel.
Using shortcuts can save time. Here are the 15 useful keyboard shortcuts to speed up your work in Excel.
1. Insert a new line within a cell - Alt+ Enter
2. Add border to cells – Alt + H, B
3. Insert table - Ctrl+T
4. Add a comment to a cell – Shift + F
5. Select the entire row – Shift + Space
6. Insert the current date or time - Ctrl] + ; (semicolon) or Ctrl + : (colon)
7. Select the entire column – Ctrl + Space
8. Hide rows - Ctrl + 9
9. Editing Cell – Function Key 2 or F2
10. Create a chart from a range of data - Function Key 11 or F11
11. Open PrintPreview – Ctrl + F2
12. Save As- Function Key 12 or F12
13. Insert or Add New Sheet – Shift + F11
14. Autofit or Adjust Column Width – Alt + H + O +I
15. Move or toggle from one Sheet to another – Ctrl + PageDown
0 Comments