| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Menu Greyed Out?
The sheet is protected?
The workbook is shared? You have more than one sheet selected? Gord Dibben MS Excel MVP On Wed, 3 Sep 2008 12:04:01 -0700, TomP wrote: I have a spreadsheet that already has "drop down" arrows on every cell in a column data to select from. I was able to find the data that is supposed to be used for the "drop down" menu and that the data name range assigned to it. The problem I'm having is that when I go to the menu bar and select Data, the Validation option is greyed out. How can access the data validation menu when it is greyed out? The entire file is unprotected. Thank you for your help! Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Menu Delete greyed out | Excel Worksheet Functions | |||
| Why the data validation button is greyed out when it is in trackchange mode in Excel 2007 | Excel Discussion (Misc queries) | |||
| Why the data validation button is greyed out when it is in trackchange mode in Excel 2007 | Excel Discussion (Misc queries) | |||
| Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
| greyed out menu items | Excel Worksheet Functions | |||
Threaded Mode
