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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Validation lists

Validation lists

ResolvedVersion 2003

Tue 2 Jun 2009, 10:21 Delegate Liz said...

Liz has attended:
SharePoint course

Validation lists

Hello
I am entering =listname to define cell contents.
The list is longish.
The cell input defaults to the END of the list, which is blank because I am allowing for adding more entries.
How can I get the cell input to go to the top of the list please?
Thanks

Tue 2 Jun 2009, 13:29 Trainer Stephen said...

RE: validation lists

Hi Liz

Thank you for your question

This question is hard to answer without seeing the workbook in question.

If you could email me a copy at stephen@stl-training.co.uk, I will look into the matter and reply as soon as possible

Thanks

Stephen

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Validation lists

Validation lists

RE: validation lists

Excel articles

Excel tip:

Switch on smart tags – Excel 2007