Excel Shortcut Keys to Enter data
You may need to reenter the data again and again whenever you need to perform the Calculations to make your work easy and fast below are some shortcut keys that can be used to enter the data.
Shortcuts |
Description |
---|---|
Enter |
Enter data and move down |
Shift + Enter |
Enter data and move up |
Tab |
Enter data and move right |
Shift +Tab |
Enter data and move left |
Ctrl + Enter |
Enter data and stay in the same cell |
Enter |
Enter the same data in multiple cells |
Ctrl + ; |
Insert current date |
Ctrl + Shift + : |
Insert current Time |
Ctrl + D |
Fill down from the cell Above |
Ctrl + R |
Fill right from the cell on the left |
Ctrl + ‘ |
Copy the formula from the cell above(the formula is an exact copy) |
Ctrl +Shift + “ |
Copy value from the cell above |
Ctrl + K |
Insert hyperlink |
Alt + Arrow down |
Display AutoComplete list |
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.
Contact Us