Excel Pick List
Last week the tip took a break as my son got married on Sunday 25th July. This week we are back with a handy Excel Tip.
You are filling in a long list of entries and you find that you are repeating the same thing over and over. It would be handy to have a drop down or pick-list to select from.
So here is how to get an instant drop down list by using the Right Mouse button.
Create a Pick List in Excel 2007 and Excel 2010
Create a Pick List in Excel 2008 Mac
Remember to let me know if you would like me to write a tip for you.
For any IT Training Needs you may have on either Windows or Mac give me a call on 020 8203 1774 or email me firstname.lastname@example.org
I look forward to hearing from you! :)
6th January 2011
Shelley Fishel is the Founder and Managing Director of The Training Surgery, an IT training company that focuses on the needs of the clients. Training in your office, with your documents focussed on your...