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.
Here’s how:
- 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.
Here’s how:
- 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.
Related tips
Using validation rules to ensure accurate data entry
Enter the current date and/or time into a worksheet
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk