Excel

Version 1.9

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

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

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

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

Excel

Carl has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course
Excel VBA course
Project Intro Intermediate course

by - delegate Carl [2 posts] (2008 May 30 Fri, 16:27) Reply

How can you edit the Data Validation list source when you have manually typed in a list scrolling beyond the size of the input box? Using the cursor keys references cells on the worksheet!

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
2007	2009 Jan 20 Tue	Bloomsbury	3	book now	£224	£224
2003	2009 Jan 20 Tue	Southwark	4	book now	£207	£215
Full Schedule: See all 134 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: Excel - data validation source list

by - trainer Rajeev gold contributer [480 posts] (2008 Jun 2 Mon, 11:46) Reply

Dear Carl

Thank you for attending Excel, Access and Project courses. I hope you enjoyed the courses and benefited from them.

This is few of the annoying things that Excel does but there is a way around this.

The best way is to press the function key F2 on the keyboard and that activates the cursor to move within the input box. Pressing F2 deactivates it.

Another long winded option would be to type your entries in Word or Notepad separating then by commas (,) and then cut (CTRL +X) and paste (CTRL +V) them in the input box in Excel Data Validation dialog box.

I hope this answers your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003

Training by application

Main information pages

Excel

Related articles

Excel tip:

Hiding Formulae in the Formula Bar