99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Automatically Insert The Time, Date Or Both In Excel
Tue 24th May 2011
AutoComplete is particularly useful when typing often repeated data, such as the names of towns and cities from a certain area. The welcome sight of those names appearing automatically, after typing only one or more letters, saves an awful lot of keystrokes over the course of a working day. Its near neighbour, AutoFill makes light work of the laborious task of typing in days of the week or months of the year, as it fills in predictive text after only the slightest of prompts.
But not everything you type is covered by these automatic features. The date and time, for example, will not appear automatically when you type it in. Even though you may repeat the same date over and over, Excel will not take the hint and offer you an AutoComplete for it. But then it doesn't need to as there are ways to insert the date, or the time, or even both, without the hassle of keying in numbers and separating strokes.
The date shortcut is extremely useful as this is a commonly entered item in many worksheets. I remember back in the days when I was pretty much an Excel rookie, I had to log the details of new members of the video store I ran. Probably the biggest interruption to the flow of entering these details was switching from typing words to the rather disjointed typing of the numbers and strokes that made up that day's date. The store owner watched me for a while, and, seeing my discomfort every time I had to enter a date, he came to the rescue with the magic key that would allow me to enter today's date at a stroke, and it was as easy as selecting the desired cell and pressing Ctrl +;
I knew that this new shortcut would come in very handy as I logged details of new members and stock. It also whetted my appetite to seek out more shortcuts that could save me time. When the store was empty, I would experiment with Excel to see what other shortcuts were available. I discovered that by capping up the semicolon to a colon (Ctrl = Shift = ;) the time would appear in the cell. I'm not sure if I ever had cause to use this feature, but it was another string to my Excel bow.
As time went on I became more adept in the use of Excel, and I discovered a similar operation that comes in the form of a simple formula; that entering =NOW() into a cell will display both the date and time.
Back in those early days I was finding my feet with, if I remember rightly, Excel 97. Things have moved on quite a way since then and Excel is even more powerful. Yet no matter how up to date the version I use, had I not been shown that shortcut I would still be entering dates into Excel worksheets manually. The moral of the tale is simply this: more learning means more efficiency.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
R&D Planning Administrator
Excel Forecasting and Data Analysis
Really enjoyed the course, feel like I have learnt new skills which I can put into practice at work. Possibly the best extracurricular course I have taken to date. Cannot think of anything you can do better unfortunately!
Close Brothers Group plc
Learning Business Partner
PowerPoint Intermediate Advanced
Really engaging and good understanding of needs and pace
International CRM Marketing Specialist
Emilie Van Camp
Marius is an excellent teacher and made it very easy and enjoyable (for an excell course :)
I would say that the first half of the day went a little bit slower than it could have been whereas I found the second part of the day more useful and interesting but I thought it went a little faster than the first part and I could have done with that part going a little slower. But very useful and interesting overall.