PrabasTech

Excel Shortcuts to Make Quick Data Entry

Excel Shortcuts to Make Quick Data Entry

This Excel tutorial explains some of the important shortcuts that we can use in our daily Excel related activities:
இந்த எக்செல் பயிற்சி சில அன்றாட எக்செல் தொடர்பான செயல்பாடுகளில் பயன்படுத்தக்கூடிய சில முக்கியமான எளிமையான வழிகளை விளக்குகிறது:
  1. Excel Option – Shortcut to Move selection to the right while enter (click here)
  2. Shift Enter – Shortcut to Move selection to upward while enter (click here)
  3. Shift Tab – Shortcut to Move selection to left while enter (click here)
  4. Alt + Enter – Shortcut to Create second line in the same cell (click here)
  5. Select + Ctrl + Enter – Shortcut to Enter same data in multiple cells (click here)
  6. Ctrl + Semicolon – Shortcut to Enter current date in a cell (click here)
  7. Ctrl + Shift + Semicolon – Shortcut to Enter current time in a cell (click here)
  8. Ctrl + D – Shortcut to Fill Down (click here)
  9. Ctrl + R – Shortcut to Fill Right (click here)
  10. Ctrl + E – Shortcut to Flash Fill (click here)

Practice file does not required for this tutorial, so it is not included. 

இந்த டுட்டோரியலிற்கு பயிற்சி டாக்குமெண்ட் ஏதும் தேவையில்லை.

If you watch and understand the entire tutorial along with the practice file, it is a great time saver in such scenarios. 

I hope you understood and practiced the entire concept. Thanks for your time for reading this article.

Want to receive weekly insights  tips & tricks

then register here

Chat
1
Join
PrabasTech Welcome you.
Would you like to join a course?