Excel Hack

Date shortcut in Excel

Excel has a variety of shortcuts for dates. There are shortcuts to change the date format, shortcuts to change the date format from the Format Cells dialog box, and other shortcuts that are always useful to know. Use these shortcuts to improve your work efficiency when entering data that contains dates.

Date shortcut

Date Format Shortcut

Windows
Ctrl + Shift + #

Mac
control + shift + #

Display the Format Cells dialog box

Windows
Ctrl + 1
Access Key: Alt + H + F + M

Mac
command + 1 or control + 1

Change the date format

How to change the date to dd-mmm-yy format using shortcut keys.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell where you want to change the date format.

Change the date format

Change the date format

Press Ctrl + Shift + # to change the date to dd-mmm-yy format.

Changing the date format from Format Cells dialog box

Select a cell

Select the cell where you want to change the date format.

Select a date format

Press Ctrl + 1 or Alt + H + F + M to display the Format Cells dialog box.

Press Alt + T to select type, use Arrow key to select the date format, and press Enter.

The date format has been changed

The date format has been changed.

Articles related to Date & Shortcut

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments