Pick From Drop-Down List...
 

I have created a list in cells A2 thru A13. A1 has text 'Month & Yr'
entered. When I right-click in A14, I do not have the option of Pick From
Drop-Down List... appear. I have this in another file that was converted
over from Excel 2000 & it works fine. What am I missing in Excel 2003?

Thanx! Mary

Pick From Drop-Down List...
 

Copy cell A13 down to A14 and see if it give you what you want.

"Mary Z" wrote:

I have created a list in cells A2 thru A13. A1 has text 'Month & Yr'
entered. When I right-click in A14, I do not have the option of Pick From
Drop-Down List... appear. I have this in another file that was converted
over from Excel 2000 & it works fine. What am I missing in Excel 2003?

Thanx! Mary

Pick From Drop-Down List...
 

Pick From Drop-Down List... still does not appear in the right-click menu.

"Barb Reinhardt" wrote:

Copy cell A13 down to A14 and see if it give you what you want.

"Mary Z" wrote:

I have created a list in cells A2 thru A13. A1 has text 'Month & Yr'
entered. When I right-click in A14, I do not have the option of Pick From
Drop-Down List... appear. I have this in another file that was converted
over from Excel 2000 & it works fine. What am I missing in Excel 2003?

Thanx! Mary

Pick From Drop-Down List...
 

No "pick from list" selection appearing at all?

How about you reset the right-click menu.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate Window.

Copy/paste this line into the window and hit <enter

Application.CommandBars("Cell").Reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 08:18:00 -0700, Mary Z
wrote:

Pick From Drop-Down List... still does not appear in the right-click menu.

"Barb Reinhardt" wrote:

Copy cell A13 down to A14 and see if it give you what you want.

"Mary Z" wrote:

I have created a list in cells A2 thru A13. A1 has text 'Month & Yr'
entered. When I right-click in A14, I do not have the option of Pick From
Drop-Down List... appear. I have this in another file that was converted
over from Excel 2000 & it works fine. What am I missing in Excel 2003?

Thanx! Mary