98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
Fri 30 May 2008, 16:27Delegate Carl said...
Carl has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course
Excel VBA Intro Intermediate course
Project Intro Intermediate course
Excel
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!
Mon 2 Jun 2008, 11:46Trainer Rajeev said...
RE: Excel - data validation source list
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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Remove unused toolbar buttonsAre there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following: |
