microsoft excel 2003 vba courses - excel
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 » microsoft excel 2003 vba courses - Excel

microsoft excel 2003 vba courses - Excel

resolvedResolved · Low Priority · Version Standard

replyReply Tue 9 Oct 2007, 16:10Trainer Amanda said...

Excel

How do I create a drop down list?

For upcoming training course dates see: Pricing & availability

replyReply Tue 9 Oct 2007, 16:34Trainer Richard said...

RE: excel

You can do this by using DATA > VALIDATION

Choose LIST from the ALLOW menu, and then type your list of data, separated by commas.

 

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

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