In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes how to quickly insert today's date or current time (Excel and Access)...
Tame your computer - timely tips
In trying to improve the quality and effectiveness of our training I always ask delegates to complete an evaluation form. One of the questions is “What is your favourite tip you picked up today?”. Because one of this week’s Access course participants wrote “shortcut for today’s date” I thought I’d dust off tip 358, as it doesn’t just apply to Excel, but also to Access.
- Press CTRL + ; to enter today's date OR
- Press CTRL + SHIFT + ; to enter the current time
If you'd like the date to be updated every time someone opens Excel or Access, you can insert the date as a field.
- Type =Date() in the Field Properties Default Value box in the table design of Access OR
- Type =TODAY() or =NOW() in a cell in Excel
With thanks to Kathryn for this week’s tip inspiration.