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

shortcut

ResolvedVersion 2007

Sarah has attended:
Excel Advanced course

Shortcut

Hi,

Can you please tell me the best shortcurt for inputting todays date? Its becoming a little tedious having to manually type it in each morning!

Many Thanks,
Sarah.

RE: Shortcut

Hello Sarah,

Hope you enjoyed your Microsoft Excel Advanced course with BEST Training.
Thank you for your question regarding entering today's date.

The answer is to hold "Ctrl" and then press the ";" button.

Its really quick and easy to use

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

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.