![]() This Excel tip shows you how to quickly format dates using the day-month-year format (such as 01-Jan-14) in an Excel worksheet using shortcut keys on the keyboard. ![]() To have the date update every time the worksheet is opened, use the TODAY function.įormatting Dates in Excel With Shortcut Keys Use another keyboard shortcut to change the format to the day-month-year format. The default format for the date entered is the short date format as shown in the image above. The current date appears in the worksheet in the selected cell. Press and release the semi-colon key ( ) on the keyboard without releasing the Ctrl key. ![]() ![]() Press and hold the Ctrl key on the keyboard. Select the cell where you want the date to appear. Keys for other layouts might not correspond exactly to the keys on a US keyboard. Important: These shortcuts refer to the US keyboard layout. This includes the shortcuts that you can use to access the Ribbon. To add the current date to a worksheet using just the keyboard: This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel. The key combination for adding the date in Excel is: You can quickly add the current date to any cell in an Excel worksheet using a keyboard shortcut. Maybe some scripters will come forward with some help or suggestions.īut I came across an alternative that might be of use to you:Īdding the Current Date in Excel Using Shortcut Keys
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |