Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel general

ResolvedVersion 2003

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?

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

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.