Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel
hi i was wondering how to make a drop down box so i can select a name for
say my taxinvoices for my clients instead of having to type in the whole thing thank you |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel
you should use Data Validation feature. select the range of cells where you want a drop down list. go to menu Data Validation under Allow options select List and type tax invoice numbers in Source field each seperated with a comma. instead of typing invoice numbers in Source field, you can put a reference of cells which contain invoice numbers. hope this would solve your problem. H&J Trans Wrote: hi i was wondering how to make a drop down box so i can select a name for say my taxinvoices for my clients instead of having to type in the whole thing thank you -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=572974 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |