ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to creat a selection pull down window? (https://www.excelbanter.com/excel-worksheet-functions/47898-how-creat-selection-pull-down-window.html)

accountant2005

how to creat a selection pull down window?
 
if I can select a name from the pull down window, it could save time for
repeating key in. anybody now how to create a pull down window? thanks

Paul B

accountant2005, one way, use data validation, have a look here on how to do
it

http://www.contextures.com/xlDataVal01.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"accountant2005" wrote in message
...
if I can select a name from the pull down window, it could save time for
repeating key in. anybody now how to create a pull down window? thanks





All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com