XL Enter date/time

XL Enter date/time

To enter the current date in a cell, press Ctrl-Semicolon (hold the Ctrl key down and press the ; key). To enter the current time, press Ctrl-Shift-Semicolon (;).