Excel Shortcut Keys
Which are the 5 basic shortcut keys?
The 5 basic shortcut keys are:
- Copy: Ctrl + C.
- Cut: Ctrl + X.
- Paste: Ctrl + V.
- Display and hide the desktop: Windows logo key + D.
- Switch between open apps: Alt + Tab.
Give some shortcuts for Number formatting
Some shortcut keys for Number Formatting are:
- Ctrl + Shift + ~ : To apply a general format
- Ctrl + Shift +! : To apply the number format
- Ctrl + Shift + @ : To apply the time format
- Ctrl + Shift + # : To apply the date format
- Ctrl + Shift + $ : To Apply Currency Format
- Ctrl + Shift + % : To apply Percentage Format
- Ctrl + Shift + ^ : To apply a scientific format
What are the 20 shortcut keys in Excel?
The 20 shortcut keys in Excel are:
1. To move to the next sheet – Ctrl + PageDown
2. To edit a cell – F2
3. Go to Formula Tab – ALT +M
4. Close Excel – CTRL +F4
5. Create New Workbook -CTRL + N
6. To add border – ALT + H + B
7. To move to the next Cell – Tab
8. Copy Cells- CTRL + C
9. Paste Cells- CTRL + V
10. Createv pivot table – ALT +N +V
11. Selecting Entire pivot table – CTRL +A
12. Creating custom view- ALT +W + F + C
13. Enter data and move left – Shift + Tab
14. Insert current date- CTRL +;
15. Activate or open selected Control- Space
16. Format cells – CTRL + 1
17. Drag to Worksheet- ALT + Drag
18. To apply the number format- CTRL + Shift + !
19. Turn end mode on- end
20. Move to the beginning of Row- Home
What does Ctrl +Y mean?
This keyboard Shortcut is used for performing the same action Again. This means CTRL +Y is to redo
Top 100+ Excel Shortcut Keys List (A to Z)
Did you know that using keyboard shortcuts can increase productivity and save you time? Although the term “shortcut” may seem intimidating, it’s important to consider the benefits if you use computers every day!
Here, we provide a list of all essential list of excel shortcut keys, Starting with Basic Excel Shortcuts to advanced Excel shortcut keys.
We have also compiled all the essential computer shortcut keys, which include shortcuts for popular software like Microsoft Word, Excel, PowerPoint, and Gmail, as well as special characters and shortcuts relevant to competitive exams.