| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Drop Down Lists
I have a range of cells that I have formatted using Data Validation to have
their contents limited to selection from a drop Down list. However the down arrow at the right hand side of each cell is missing or not displayed. What could be wrong please? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Drop Down Lists
The dropdown arrow is visible only when you select the cell.
Do you have "In-cell dropdown" selected? Do you have ToolsOptionsViewObjects set for "Show All"? Gord Dibben MS Excel MVP On Tue, 2 Mar 2010 08:48:06 -0800, biggles592 wrote: I have a range of cells that I have formatted using Data Validation to have their contents limited to selection from a drop Down list. However the down arrow at the right hand side of each cell is missing or not displayed. What could be wrong please? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Drop Down Lists
hi
see this site... http://www.contextures.com/xlDataVal...rowsNotVisible regards FSt1 "biggles592" wrote: I have a range of cells that I have formatted using Data Validation to have their contents limited to selection from a drop Down list. However the down arrow at the right hand side of each cell is missing or not displayed. What could be wrong please? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Drop Down Lists
Hi Gord,
Many thanks for responding to my enquiry. Yes I do have "In cell dropdown" selected and I do appreiciate that the dropdown arrow is only visable when the cell is selected. I can't however find Tools menu on any of the following Tabs I have at the top of the screen; namely Home,Insert,Page Layout,Formulas,Data, Review,View,Developer and Add-Ins. Can you advise specifically where I can find this "Tools" menu please?. Additionally I did try saving the file as an .XLSX files rather than a.XLS file in Excel 97-2003 format and running it in compatability mode. Whaddya Know! in XLSX format the dropdown arrows re-appear but this might be because I've not got something set or checked in this version that is set or checked in the 97-03 version maybe???! Any ideas would greatly be appreiciated. Many thanks, Biggles592 "Gord Dibben" wrote: The dropdown arrow is visible only when you select the cell. Do you have "In-cell dropdown" selected? Do you have ToolsOptionsViewObjects set for "Show All"? Gord Dibben MS Excel MVP On Tue, 2 Mar 2010 08:48:06 -0800, biggles592 wrote: I have a range of cells that I have formatted using Data Validation to have their contents limited to selection from a drop Down list. However the down arrow at the right hand side of each cell is missing or not displayed. What could be wrong please? . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Drop Down Lists
2007.............ButtonExcel OptionsAdvancedDisplay Options for workbook.
You will find Objects....All or Nothing. Uncheck "nothing" Gord On Wed, 3 Mar 2010 03:50:01 -0800, biggles592 wrote: Hi Gord, Many thanks for responding to my enquiry. Yes I do have "In cell dropdown" selected and I do appreiciate that the dropdown arrow is only visable when the cell is selected. I can't however find Tools menu on any of the following Tabs I have at the top of the screen; namely Home,Insert,Page Layout,Formulas,Data, Review,View,Developer and Add-Ins. Can you advise specifically where I can find this "Tools" menu please?. Additionally I did try saving the file as an .XLSX files rather than a.XLS file in Excel 97-2003 format and running it in compatability mode. Whaddya Know! in XLSX format the dropdown arrows re-appear but this might be because I've not got something set or checked in this version that is set or checked in the 97-03 version maybe???! Any ideas would greatly be appreiciated. Many thanks, Biggles592 "Gord Dibben" wrote: The dropdown arrow is visible only when you select the cell. Do you have "In-cell dropdown" selected? Do you have ToolsOptionsViewObjects set for "Show All"? Gord Dibben MS Excel MVP On Tue, 2 Mar 2010 08:48:06 -0800, biggles592 wrote: I have a range of cells that I have formatted using Data Validation to have their contents limited to selection from a drop Down list. However the down arrow at the right hand side of each cell is missing or not displayed. What could be wrong please? . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Drop Down Lists
Hi Gord,
Thank you for responding so quickly again. I've checked that all is selected and it was but still running under compatability mode as an .xls file the down arrows refuse to show. I've even cleared formats and data validation and re-entered it to no avail. Most frustrating! "Gord Dibben" wrote: 2007.............ButtonExcel OptionsAdvancedDisplay Options for workbook. You will find Objects....All or Nothing. Uncheck "nothing" Gord On Wed, 3 Mar 2010 03:50:01 -0800, biggles592 wrote: Hi Gord, Many thanks for responding to my enquiry. Yes I do have "In cell dropdown" selected and I do appreiciate that the dropdown arrow is only visable when the cell is selected. I can't however find Tools menu on any of the following Tabs I have at the top of the screen; namely Home,Insert,Page Layout,Formulas,Data, Review,View,Developer and Add-Ins. Can you advise specifically where I can find this "Tools" menu please?. Additionally I did try saving the file as an .XLSX files rather than a.XLS file in Excel 97-2003 format and running it in compatability mode. Whaddya Know! in XLSX format the dropdown arrows re-appear but this might be because I've not got something set or checked in this version that is set or checked in the 97-03 version maybe???! Any ideas would greatly be appreiciated. Many thanks, Biggles592 "Gord Dibben" wrote: The dropdown arrow is visible only when you select the cell. Do you have "In-cell dropdown" selected? Do you have ToolsOptionsViewObjects set for "Show All"? Gord Dibben MS Excel MVP On Tue, 2 Mar 2010 08:48:06 -0800, biggles592 wrote: I have a range of cells that I have formatted using Data Validation to have their contents limited to selection from a drop Down list. However the down arrow at the right hand side of each cell is missing or not displayed. What could be wrong please? . . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Drop Down Lists
I think we have covered everything except workbook corruption.
But have a browse through Debra's site to see if anything applies to you. http://www.contextures.on.ca/xlDataV...rowsNotVisible Gord On Wed, 3 Mar 2010 09:41:01 -0800, biggles592 wrote: Hi Gord, Thank you for responding so quickly again. I've checked that all is selected and it was but still running under compatability mode as an .xls file the down arrows refuse to show. I've even cleared formats and data validation and re-entered it to no avail. Most frustrating! "Gord Dibben" wrote: 2007.............ButtonExcel OptionsAdvancedDisplay Options for workbook. You will find Objects....All or Nothing. Uncheck "nothing" Gord On Wed, 3 Mar 2010 03:50:01 -0800, biggles592 wrote: Hi Gord, Many thanks for responding to my enquiry. Yes I do have "In cell dropdown" selected and I do appreiciate that the dropdown arrow is only visable when the cell is selected. I can't however find Tools menu on any of the following Tabs I have at the top of the screen; namely Home,Insert,Page Layout,Formulas,Data, Review,View,Developer and Add-Ins. Can you advise specifically where I can find this "Tools" menu please?. Additionally I did try saving the file as an .XLSX files rather than a.XLS file in Excel 97-2003 format and running it in compatability mode. Whaddya Know! in XLSX format the dropdown arrows re-appear but this might be because I've not got something set or checked in this version that is set or checked in the 97-03 version maybe???! Any ideas would greatly be appreiciated. Many thanks, Biggles592 "Gord Dibben" wrote: The dropdown arrow is visible only when you select the cell. Do you have "In-cell dropdown" selected? Do you have ToolsOptionsViewObjects set for "Show All"? Gord Dibben MS Excel MVP On Tue, 2 Mar 2010 08:48:06 -0800, biggles592 wrote: I have a range of cells that I have formatted using Data Validation to have their contents limited to selection from a drop Down list. However the down arrow at the right hand side of each cell is missing or not displayed. What could be wrong please? . . |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Drop Down Lists
Agree we've covered everthing but nice to check with an expert! Remain
convinced it's a compatability issue as when I save the file as an .xlsx file everything re-appears. So thats my answearthen. But many thanks for your kind assistance. Regards Biggles592 "Gord Dibben" wrote: I think we have covered everything except workbook corruption. But have a browse through Debra's site to see if anything applies to you. http://www.contextures.on.ca/xlDataV...rowsNotVisible Gord On Wed, 3 Mar 2010 09:41:01 -0800, biggles592 wrote: Hi Gord, Thank you for responding so quickly again. I've checked that all is selected and it was but still running under compatability mode as an .xls file the down arrows refuse to show. I've even cleared formats and data validation and re-entered it to no avail. Most frustrating! "Gord Dibben" wrote: 2007.............ButtonExcel OptionsAdvancedDisplay Options for workbook. You will find Objects....All or Nothing. Uncheck "nothing" Gord On Wed, 3 Mar 2010 03:50:01 -0800, biggles592 wrote: Hi Gord, Many thanks for responding to my enquiry. Yes I do have "In cell dropdown" selected and I do appreiciate that the dropdown arrow is only visable when the cell is selected. I can't however find Tools menu on any of the following Tabs I have at the top of the screen; namely Home,Insert,Page Layout,Formulas,Data, Review,View,Developer and Add-Ins. Can you advise specifically where I can find this "Tools" menu please?. Additionally I did try saving the file as an .XLSX files rather than a.XLS file in Excel 97-2003 format and running it in compatability mode. Whaddya Know! in XLSX format the dropdown arrows re-appear but this might be because I've not got something set or checked in this version that is set or checked in the 97-03 version maybe???! Any ideas would greatly be appreiciated. Many thanks, Biggles592 "Gord Dibben" wrote: The dropdown arrow is visible only when you select the cell. Do you have "In-cell dropdown" selected? Do you have ToolsOptionsViewObjects set for "Show All"? Gord Dibben MS Excel MVP On Tue, 2 Mar 2010 08:48:06 -0800, biggles592 wrote: I have a range of cells that I have formatted using Data Validation to have their contents limited to selection from a drop Down list. However the down arrow at the right hand side of each cell is missing or not displayed. What could be wrong please? . . . |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Drop Down Lists
Any chance you could send the file to me?
I'd like to test in 2003 and 2007. Save as Excel 97-2003 format. Send to gorddibbATshawDOTca change the obvious. Gord On Thu, 4 Mar 2010 09:40:01 -0800, biggles592 wrote: Agree we've covered everthing but nice to check with an expert! Remain convinced it's a compatability issue as when I save the file as an .xlsx file everything re-appears. So thats my answearthen. But many thanks for your kind assistance. Regards Biggles592 "Gord Dibben" wrote: I think we have covered everything except workbook corruption. But have a browse through Debra's site to see if anything applies to you. http://www.contextures.on.ca/xlDataV...rowsNotVisible Gord On Wed, 3 Mar 2010 09:41:01 -0800, biggles592 wrote: Hi Gord, Thank you for responding so quickly again. I've checked that all is selected and it was but still running under compatability mode as an .xls file the down arrows refuse to show. I've even cleared formats and data validation and re-entered it to no avail. Most frustrating! "Gord Dibben" wrote: 2007.............ButtonExcel OptionsAdvancedDisplay Options for workbook. You will find Objects....All or Nothing. Uncheck "nothing" Gord On Wed, 3 Mar 2010 03:50:01 -0800, biggles592 wrote: Hi Gord, Many thanks for responding to my enquiry. Yes I do have "In cell dropdown" selected and I do appreiciate that the dropdown arrow is only visable when the cell is selected. I can't however find Tools menu on any of the following Tabs I have at the top of the screen; namely Home,Insert,Page Layout,Formulas,Data, Review,View,Developer and Add-Ins. Can you advise specifically where I can find this "Tools" menu please?. Additionally I did try saving the file as an .XLSX files rather than a.XLS file in Excel 97-2003 format and running it in compatability mode. Whaddya Know! in XLSX format the dropdown arrows re-appear but this might be because I've not got something set or checked in this version that is set or checked in the 97-03 version maybe???! Any ideas would greatly be appreiciated. Many thanks, Biggles592 "Gord Dibben" wrote: The dropdown arrow is visible only when you select the cell. Do you have "In-cell dropdown" selected? Do you have ToolsOptionsViewObjects set for "Show All"? Gord Dibben MS Excel MVP On Tue, 2 Mar 2010 08:48:06 -0800, biggles592 wrote: I have a range of cells that I have formatted using Data Validation to have their contents limited to selection from a drop Down list. However the down arrow at the right hand side of each cell is missing or not displayed. What could be wrong please? . . . |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Drop Down Lists
On Thu, 04 Mar 2010 10:42:06 -0800, Gord Dibben <gorddibbATshawDOTca
wrote: Any chance you could send the file to me? I'd like to test in 2003 and 2007. Save as Excel 97-2003 format. Send to gorddibbATshawDOTca change the obvious. Gord He may be confused by something he saw elsewhere. If one creates a combo-box with a scroll bar edge, it remains at all times. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Drop Down Lists Help | Excel Worksheet Functions | |||
| Drop down lists in excel | Excel Discussion (Misc queries) | |||
| Excel Drop-down lists | Excel Discussion (Misc queries) | |||
| Excel drop down lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Linear Mode
