automatic info filling
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 » Automatic info filling

Automatic info filling

resolvedResolved · Low Priority · Version 2007

replyReply Wed 9 Jul 2008, 16:39Delegate Lir said...

Lir has attended:
Excel Advanced course

Automatic info filling

when entering formulas, the options appear below in a dropdown. Is there any way of selecting these so you can use them? if you select, it doesn't seem to work

For upcoming training course dates see: Pricing & availability

replyReply Fri 18 Jul 2008, 14:56Trainer Mark said...

RE: automatic info filling

Hi Lir

How are you today

You can use the drop down lists when the list appears you can choose any of them to use by double clicking them

this should do the trick

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

 

Please browse our web site to find out more about
vba-excel-training and other Microsoft training courses.

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

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