visual+basic+for+excel+courses+london - dates
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 » visual+basic+for+excel+courses+london - Dates

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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

resolvedResolved · Low Priority · Version Standard

replyReply Mon 19 Nov 2007, 13:00Delegate Chris said...

Chris has attended:
Excel Advanced course

Dates

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

For upcoming training course dates see: Pricing & availability

replyReply Mon 19 Nov 2007, 15:49Trainer Pete said...

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 articles

· Flexible uses for Excel at Home
· Do You Really Need Excel VBA Training?
· Excel 2010 Can Make Your Reports Better And More Detailed Than Ever
· How To Share Files In Excel 2010
· The Mysteries Of Excel Explained

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.



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

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy