FYI | LIB25-10 | 100 Excel Shortcuts: Boost Your Productivity with These Microsoft Excel Shortcuts!

  Boost Your Productivity with These Microsoft Excel Shortcuts!  

If you use Microsoft Excel, remembering these shortcut keys can make your work faster and easier!

Make yourself 2x more productive in Excel

100 shortcuts ranked from Basic, Intermediate, Advanced, and Underrated

If you think you know well Excel, I bet you will still learn something new in the Advanced table (items 51 to 75).

What do we cover?

A list of essential Excel shortcuts for professionals.

Here is a preview:

🟠 Basic

1. How to copy text?

Ctrl + C

2. How to cut text?

Ctrl + X

3. How to paste?

Ctrl + V

4. How to undo?

Ctrl + Z

5. How to redo?

Shift + F11

(get the answers 6-25 in the Cheat Sheet below)

⚪ Intermediate

26. How to autosum?

Alt + =

27. How to fill down?

Ctrl + D

28. How to fill right?

Ctrl + R

29. How to do flash fill?

Ctrl + E

30. How to insert hyperlink?

Ctrl + K

(get the answers 31-50 in the Cheat Sheet below)

⚫ Advanced

51. How to show / hide ribbon?

Ctrl + F1

52. How to create custom view?

Alt + W + C

53. How to paste special (values only)?

Ctrl + Alt + V > V

54. How to change font format?

Ctrl + Shift + F

55. How to goal seek?

Alt + A + W + G

(get the answers 56-75 in the Cheat Sheet below)

🔵 Underrated

76. How to move to the next open workbook window?

Ctrl + F6

77. How to move to the previous open workbook window?

Ctrl + Shift + F6

78. How to insert current date and time?

Ctrl + Shift + :

79. How to paste values & formatting only?

Ctrl + Alt + V > T

80. How to apply or remove cell wrap?

Alt + H + W

(get the answers 81-100 in the Cheat Sheet below)

Source |   https://lnkd.in/d3GSwhqz

 

Regards!

 

Librarian                                                                                                                               

Rizvi Institute of Management