visual+basic+for+excel+courses+london - dates

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » visual+basic+for+excel+courses+london - Dates

visual+basic+for+excel+courses+london - Dates

resolvedResolved · Low Priority · Version Standard

Chris has attended:
Excel Advanced course
Excel Intermediate course

Dates

How do you enter the date on a s/sheet via a short cut key?

RE: Dates

Hi Chris, Thank you for the post, to enter the date which is not updatable daily try the key combination CTRL+; (semi colon) to enter a date which updates each day you can use the =today() or if you want the time too, use =now(), hope you enjoyed the course, regards Pete


 

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips


Server loaded in 0.08 secs.