Validation lists

Resolved · Urgent Priority · Version 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:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips

Validation lists

Validation lists

RE: validation lists

Excel articles

Excel tip:

Move or Highlight Cells