| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get drop down pick list comments to appear over selection | Excel Worksheet Functions | |||
| Drop Down Pick List | Excel Discussion (Misc queries) | |||
| how do i get a drop down pick list in a cell | Excel Worksheet Functions | |||
| how do i get a drop down pick list in a cell | Excel Worksheet Functions | |||
| Pick from a drop-down list | Excel Worksheet Functions | |||
Linear Mode
