How to Insert Current Date, Time, and AutoSum with keyboard shortcuts in Excel (Khmer)

Hello everyone! Today I show you fast keyboard shortcuts and formulas to insert current date, current time, and AutoSum numbers in Excel step by step with easy video guide in Khmer language.

These 3 tricks will save you so much time when doing daily data entry and monthly report!

Method 1: Insert Current Date (Shortcut vs Formula)

1. Static Date (Keyboard Shortcut - Recommended for Log & Invoice)

If you want to freeze current date so it never changes tomorrow:

• Press Ctrl + ; (Control + Semicolon)
• Result: Inserts today date like 13/09/2026 instantly!

2. Dynamic Date (Formula)

If you want date to update automatically every day:

• Type formula: =TODAY()
• Result: Shows today date and updates every day when you open file.

Method 2: Insert Current Time (Shortcut vs Formula)

1. Static Time (Keyboard Shortcut)

If you want to stamp current exact time (e.g. check-in / check-out time):

• Press Ctrl + Shift + ; (Control + Shift + Semicolon)
• Result: Inserts current time like 02:30 PM.

2. Dynamic Date & Time (Formula)

To show current date and time together live:

• Type formula: =NOW()
• Result: Displays both date and time (e.g. 13/09/2026 14:30).

Method 3: AutoSum Numbers Instantly (Alt + =)

Stop typing =SUM(A1:A10) manually! You can calculate sum in 1 second using keyboard shortcut:

Step by Step:

1. Click empty cell below or next to your numbers.
2. Press Alt + = (Hold Alt key and press = sign).
3. Excel will automatically highlight numbers and write =SUM(...) for you.
4. Press Enter!

💡 AutoSum on Ribbon: You can also select numbers ➔ go to Home tab ➔ click AutoSum (Σ) button on top right!

📹 Watch Khmer Video Tutorial

Watch video step by step below to see how to use shortcuts for date, time, and AutoSum in Excel:

💡 Quick Tip:

• Insert Date & Time Together: Press Ctrl + ; ➔ press Spacebar ➔ press Ctrl + Shift + ;!
• Shortcut vs Formula Difference: Shortcuts (Ctrl + ; or Ctrl + Shift + ;) insert fixed values that never change. Formulas (=TODAY() or =NOW()) change automatically whenever worksheet recalculates!
• AutoSum Multiple Columns at Once: Highlight whole table including total row and total column ➔ press Alt + = to AutoSum all columns and rows at same time!

📚 Related Resources

• How to Calculate Working Hours in Excel
• How to Use Track Change and Comment in Excel
• How to Set Header and Footer in Excel
• Top 15 Basic Excel Formulas Every Beginner Should Know