Shortcut for inserting the current date:

In Microsoft Excel, pressing Ctrl + ; inserts the current date into the selected cell. This shortcut is very useful for quickly entering the date without typing it manually. The date inserted is static, meaning it does not change when the worksheet recalculates or when you open the file later.

Here’s a quick overview of the other options:

• 
  

  Ctrl + : (colon) is not a valid shortcut in Excel for inserting the date.

  
  


• 
  

  Ctrl + , (comma) is not associated with date insertion.

  
  


• 
  

  Ctrl + D is used to fill down the contents of the cell above into the current cell.

  
  Using keyboard shortcuts like Ctrl + ; improves productivity and efficiency when working with dates in Excel.