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

excel

ResolvedVersion 2007

Sian has attended:
Excel Intermediate course

Excel

What is the shortcut for inserting todays date?

RE: Excel

Hi Sian

Welcome to the forum and 12 months support.

The keys you are looking for are

Insert the date - Ctrl + ; (semi-colon)

Insert the time - Ctrl + Shift + ; (semi-colon)

regards

Best Team

Thu 27 Aug 2009: Automatically marked as resolved.

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

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.11 secs.