Use keyboard shortcuts to add current date/time in Excel

Contents
  1. No recalculations required!
  2. Add current date in Excel using keyboard shortcuts
  3. Update date
  4. Format dates in Excel with shortcut keys
  5. Add current time with shortcut keys
  6. Refresh time
  7. Forming time in Excel with shortcut keys
  8. Enter date and time in one cell
  9. Adjusted date and time formats with shortcuts

No recalculations required!

You can quickly add current date in Excel by using keyboard shortcuts. Besides being quick, adding a date with this method doesn’t change every time the worksheet is opened, like some date functions in Excel.

The information in this article applies to Excel 2019, 2016, 2013, 2010, 2007, and Excel for Mac. The keyboard shortcuts may differ between Excel for Windows and Excel for Mac.

Add current date in Excel using keyboard shortcuts

You can quickly add the current date to any cell in an Excel worksheet by using a keyboard shortcut.

Shortcut key to add date in Excel:

  Ctrl  + ;  (точка с запятой) 

To add the current date to a sheet using only the keyboard:

  1. Select the cell where you want to display the date.

  2. Hold down a key ctrl on keyboard.

  3. Press and leave the key semicolon (;) on the keyboard without releasing the key ctrl

  4. Release the key ctrl

The current date is displayed on the sheet in the selected cell.

The default format for the date entered is the short date format, as shown in the image above. Use another hotkey to change the format to Day-Month-Year.

Update date

Use the TODAY function to update the date each time the worksheet is opened.

Format dates in Excel with keyboard shortcuts

This Excel tip shows you how to quickly format dates using the day-month-year format (for example, Jan 01-14) in an Excel worksheet using keyboard shortcuts.

Shortcut for adding date:

 Ctrl + Shift + # (хэш-тег или клавиша с цифрой) 

To format a date with a keyboard shortcut:

  1. Add a date to a cell on a sheet.

  2. Optionally, click a cell to make it the active cell.

  3. Keep keys pressed ctrl And Shift on keyboard.

  4. Press and leave the key hashtag (#) on the keyboard without releasing the keys ctrl And Shift

  5. Release the keys ctrl And Shift

The date is formatted in day-month-year format, as shown in the image above.

Add current time with hotkeys

While not as commonly used as dates in spreadsheets, adding the current time with a keyboard shortcut can be used as a timestamp, among other things. The time does not change after entry.

Keyboard shortcut to add time in Excel 2019, 2016, 2013, 2010, and 2007:

 Ctrl + Shift +: (клавиша двоеточия) 

To add the current time to a sheet using only the keyboard:

  1. Select the cell where you want the time to appear.

  2. Keep keys pressed ctrl And Shift on keyboard.

  3. Press and leave the key colon (:) on the keyboard without releasing the keys ctrl And Shift

  4. Release the keys ctrl And Shift

The current time is added to the sheet.

Keyboard Shortcut to Add Date in Excel 2016 for Mac and Excel for Mac 2011

 ⌘ (команда) +; (точка с запятой) 

To add the current time to a sheet using only the keyboard:

  1. Select the cell where you want the time to appear.

  2. Hold down a key order on keyboard.

  3. Press and release semicolon key (;) on the keyboard without releasing the key order

  4. Release the key Assignment

The current time is added to the sheet.

Refresh time

If you want the time to be updated every time the worksheet is opened, use the NOW function.

Forming time in Excel with shortcut keys

This Excel tip shows you how to quickly format times in an Excel worksheet using keyboard shortcuts. By default, time in Excel is formatted using hours: minutes and AM/PM (for example, 10:33 AM).

Shortcut for time format:

 Ctrl + Shift + @ (по символу) 

Prepare the time with shortcuts:

  1. Manually add the time to a cell on the worksheet.

  2. If necessary, select a cell to make it active.

  3. Keep keys pressed ctrl And Shift on keyboard.

  4. Briefly press the symbol key (@) on the keyboard above the number 2 without releasing the key ctrl And Shift

  5. Release the keys ctrl And Shift

  6. The time is formatted to display the current time in hours: minutes and AM / PM format as shown in the image above.

Enter date and time in one cell

You can enter date and time in a cell using keyboard shortcuts together.

  • Click Ctrl+; (Semicolon)

  • Click Room

  • Click Ctrl+Shift+; (Semicolon)

The date and time appear in the selected cell.

Custom date and time formats with keyboard shortcuts

If you want to change the date or time format entered in an Excel cell, you can use the shortcut key to open the format dialog.

Shortcut key to open Format Cells dialog

 Ctrl + 1 или ⌘ (команда) + 1 
  1. Select the cell you want to format.

  2. Hold down a key ctrl (Windows) or key order (Mac).

  3. Press and leave the key a on the keyboard without releasing the key ctrl or order

  4. Release the key ctrl or order † The Format Cells dialog box opens.

  5. Make sure the tab is selected Number

  6. Select the desired format from the category date of or Time and select Okay

Leave a Reply

Your email address will not be published.