98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
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.
Author is a freelance copywriter. For more information on excel courses, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-1704-automatically-insert-time-date-or-both-in-excel.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsThe Health Foundation
PA & Comms Assistant Leila Evans Managing Upwards I thought this course was really engaging and interactive which I think works well for my learning. Tony made was personable and made it fun and enjoyable. I'm really looking forward to applying the new tools to my day to day work. Alfa Chemicals Ltd.
Technical Sales Lindsey Graham-keighley Excel Intermediate This course was fantastic, it covered such a wide range of topics which will all help to make my use of Excel more efficient. Jens was so enthusiastic and helpful throughout the day, making sure to explain everything clearly. I'll definitely be recommending this to colleagues. PSI CRO AG
Project Coordinator Ekaterina Prudova Effective Communication Thank you, the trainer’s personality is great |
PUBLICATION GUIDELINES