A shortcut to enter the date or time is one of those shortcuts that you first learn about and think, when will I ever use that? Next thing you know you’re mashing away at your number keys trying to enter in the current date or time because the shortcut went in one ear and out the other. Here is how to execute the shortcut in 2 simple steps.
Step 1: Select the cell you wish to enter the current date or time in.
Step 2: There are, of course, 2 different shortcuts for entering the date and the time. Microsoft Excel graciously placed these two shortcuts on the same key, the semicolon or “;” key. The difference is in the modifier keys. Lets start with the “Insert Date” shortcut.
“Insert Date” shortcut text color corresponds to the “control” modifier key on our Excel Skin so we know the “Insert Date” shortcut is executed by pressing:
The current date will appear in the cell you have selected.
To execute the “Insert Time” shortcut we go through the same thought process. The “Insert Time” text corresponds with the color on the “command” key and therefore our shortcut is:
The current time will now appear in the cell you have selected.
Comments will be approved before showing up.