安裝中文字典英文字典辭典工具!
安裝中文字典英文字典辭典工具!
|
- Create Drop Down List Within A Form - Excel Help Forum
Hi All! I am working on a form on excel to allow a secretary to log hours into excel But instead of having her type in each name, I want her to be able to choose them from a list So for example, when you do Data>Forms, the category under "name", would be a drop down menu so you could pick a name, and enter the amount of hours worked
- Disappearing drop down menus [SOLVED] - Excel Help Forum
Disappearing drop down menus Hi I'm relatively new to Excel and although I know how to create a drop down menu for a column, what I'm finding is that the drop down arrow at the side of the cells keeps disappearing and I'm having to go through the whole 'data validation' route again and again
- Drop down list in table stop auto populating with new row [SOLVED]
Re: Drop down list in table stop auto populating with new row I figured it out, some data validation was removed from cells in the table column, I selected the range again and reset the list validation and it fixed the issue
- Any way to get the index of a selected item from a dropdown list?
Hi all, I used data validation tool to create a dropdown list All the cells in the column have the same dropdown list when I click it The items in the dropdown is from another column Is there a way I can get the index of the selected item when I choose an item from the dropdown list?
- How do I make the drop-down arrow always appear? - Excel Help Forum
A drop down arrow will not stay visible in a data validation list unless it's the active cell You need to name your list range and insert a combo box if you need help with that, press F1 for help, and it'll get you started
- [SOLVED] Cant type in cell with drop down list - Excel Help Forum
Forum Microsoft Office Application Help - Excel Help forum Excel Formulas Functions [SOLVED] Can't type in cell with drop down list The use of AI tools (e g chatGPT, BARD, GPT4 etc) to create forum answers is not permitted If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed
- [SOLVED] Drop-down list no repeats - Excel Help Forum
Drop-down list no repeats Hi, I have a drop-down list (Data Validation > Allow List) for a number of cells, 12 I think, across a singe row The values for the drop-down menu are in another, hidden, worksheet I would like it so the user can select any option in the drop-down list once and only once
- Displaying and Returning different value in Dropdown List
Helo, Can anybody help me with Drop down list I know how to create drop down list but I have a problem to Return different value then is displayed in Dropdown List For example: On the workbook I have two wokssheets: one with empty cell and secound with list created for dropdown list
|
|
|