LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
JRD JRD is offline
external usenet poster
 
Posts: 60
Default Dropdown list for entering data

Can anyone help?

I am using excel 2003 and want to make it easier to enter data into cells.
Is it possible to create different "dropdown lists" for different columns so
that it is quicker to enter data

e.g. if I wanted to enter which fruit I had eaten on a particular day in
column A out of the following: apple, pear, banana, strawberry, grapes, is it
possible to have that list pop up when I click on a cell in column A, so that
I can just click on the appropriate fruit to enter it into a cell.

Thanks

John
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling data from other wb based on data to populate dropdown list Suzann Excel Discussion (Misc queries) 0 April 23rd 09 04:29 PM
Drop Down list for entering data dscmm Excel Discussion (Misc queries) 1 December 13th 07 08:16 PM
Entering multiple data into list Marty Excel Discussion (Misc queries) 1 November 15th 06 03:28 AM
entering data from a list Harley Rider Excel Worksheet Functions 5 March 14th 06 01:00 PM
Entering data from dropdown list Bruce M Excel Discussion (Misc queries) 8 February 8th 06 02:18 AM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"