![]() |
Newbie-need menu of names
Hi
I need a list to appear eg (A1:A12) when a cell is clicked. Then when a list item is clicked i need it to be entered into the cell. Help much appreciated |
Newbie-need menu of names
Hi Suril,
This facility is offered by rhe built in Data Validation feature. See Debra Dalgleish's web page on Data Validation which provides a tutorialt with step by step instructions ilustrated wit numerous informative screenshots. --- Regards, Norman "Sunil Patel" wrote in message ... Hi I need a list to appear eg (A1:A12) when a cell is clicked. Then when a list item is clicked i need it to be entered into the cell. Help much appreciated |
Newbie-need menu of names
Hi Suril,
Let me try that again and iclude the link as well! This facility is offered by the built in Data Validation feature. See Debra Dalgleish's web page on Data Validation which provides a tutorial with step by step instructions illustrated with numerous informative screen shots: http://www.contextures.com/xlDataVal01.html --- Regards, Norman "Norman Jones" wrote in message ... Hi Suril, This facility is offered by rhe built in Data Validation feature. See Debra Dalgleish's web page on Data Validation which provides a tutorialt with step by step instructions ilustrated wit numerous informative screenshots. --- Regards, Norman "Sunil Patel" wrote in message ... Hi I need a list to appear eg (A1:A12) when a cell is clicked. Then when a list item is clicked i need it to be entered into the cell. Help much appreciated |
Newbie-need menu of names
I might want to look at the List option of the Data, Validation feature.
-- Jim "Sunil Patel" wrote in message ... | Hi | | I need a list to appear eg (A1:A12) when a cell is clicked. Then when a | list item is clicked i need it to be entered into the cell. Help much | appreciated | | |
All times are GMT +1. The time now is 01:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com