10 commonly used shortcut keys in MS-Excel

 

   

1.        Ctrl + A:

This is used to select all the cells in a worksheet. 

2.        Ctrl + B:

This is used to bold the value of selected cell or range of cells in a worksheet.

3.        Ctrl + C:

This is used to copy the value of selected cell or range of cells in a worksheet.

4.        Ctrl + V:

This is used to paste the copied cell value in cell or range of cells in a worksheet.

5.        Ctrl + F:

This is used to find out the cell value in selected cell or range of cells in a worksheet.

6.        Ctrl + H:

      This is used to override the existing cell value in selected cell or range of cells in a worksheet.

7.        Ctrl + G:            

This is used to locate to any cell using cell reference or any cell that contains Formula, Data-Validation, Conditional Formatting etc. in a worksheet.

8.        Ctrl + I:

This is used to make the cell value Italic in visibility, of selected cell or range of cells in a worksheet.

9.        Ctrl + K:

This is used to insert the hyperlink in selected cell in a worksheet.

10.    Ctrl + L:

This is used to create the table of selected range of cells in a worksheet.

This will help you to make the calculations easily and effectively without getting an errors or rectification of errors. If you have any kind of challenge or you want to learn about any other Function/Option which is not covered or you want me to add more into the previously covered topic, please comment. I will be happy to take your queries or suggestions.