Or make sure the dropdowns are below the Freeze line.


Gord Dibben MS Excel MVP

On Fri, 09 May 2008 06:44:06 -0500, Dave Peterson
wrote:

You're still using xl97????

This bug/feature was fixed in xl2k.

The workaround is to remove the freeze panes.

Jason wrote:

I'm working on an Excel spreadsheet which includes a number of drop down
lists. When I select freeze panes to prevent horizontal and vertical
movement the drop down list optins is no longer available. Is there a
solution/work around available?