Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Where Data Validation List Boxes Open in Mac Excel 2004
Hi All,
I'm running an app I created in Excel 2003 for PC and am trying to convert a version of the app for Mac Excel 2004. My main problem: I have data validation lists that open half-off screen. Aside from inserting new columns (which doesn't really work, I've tried), is there any way to have data validation list boxes open directly *below* or *on top of* the cells they are tied to? My data validation list host cells are merged and fairly wide (about a third of the screen, they are used for a series of sentence comments), thus the drop-down list is wide as well. When the drop-down list opens, however, it opens to the *left* of the wide cells, thus "cutting off" half of the data validation list. Changing the zoom sort of works, but I'm open to any other solution. Thanks much, Stephan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
"Data Validation from list" Pocket excel ? | Excel Discussion (Misc queries) | |||
Help with Charting My Data -- | Charts and Charting in Excel |