Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
Excel changing number formatting and source data in graphs on it's own!!! JohnHamer Excel Discussion (Misc queries) 2 September 22nd 05 02:29 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
"Data Validation from list" Pocket excel ? graeme gw Excel Discussion (Misc queries) 0 February 22nd 05 10:31 PM
Help with Charting My Data -- DavidM Charts and Charting in Excel 7 January 7th 05 01:08 PM


All times are GMT +1. The time now is 02:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"