excel general
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel in general

Excel in general

resolvedResolved · Low Priority · Version 2003

replyReply Mon 23 Mar 2009, 16:42Delegate Frank said...

Frank has attended:
Excel Intermediate course

Excel in general

How do you ensure that when Excel opens, it has today's date and it updates the date as and when you access the programme every single day?

For upcoming training course dates see: Pricing & availability

replyReply Mon 23 Mar 2009, 19:36Trainer Amanda said...

RE: Excel in general

Hello Frank

Thank you for your question and welcome to the forum.

To ensure Excel always displays the current date in a spreadsheet, select a cell in the spreadsheet and enter

=today()

then press Enter.

This is a function that will always show the current date.

Kind regards
Amanda

 

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard