Here's a quick Excel hack for you. If you frequently have to type dates in cells on a spreadsheet, simply hold down the ctrl (control) key and press the semi-colon key.
On the image below the Ctrl key is highlighted in white:
...and here's the semi-colon key:
(Note: This is a UK QWERTY keyboard).
So here I could get a load of dates in column A, simply by holding ctrl pressing and releasing the semi-colon key, release ctrl then pressing Enter! It took about 2 seconds!
No comments:
Post a Comment