LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Data Validation - Allow List - In-cell Dropdown not showing up

This is in a MS Office 97 Excel Workbook, although I have selected data
validation for a cell the in-cell dropdown is not showing up. Of course
some silly person would tell me that I don't have the In-cell Dropdown
checkbox selected . . . got it smart guy. It is still not working.

I will give you the current setup:

Cell L4 has the current data validation:
Allow: List
Source: =$B$54:$B$65
Ignore blank - selected
In-cell Dropdown - selected

Cells B54:B65
January
February
March . . . etc.

Anyone have any ideas?



 
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
Data validation with dropdown list geotso Excel Discussion (Misc queries) 2 February 1st 09 05:59 PM
Substition for data validation, dropdown list Russ G Excel Worksheet Functions 9 November 27th 07 06:26 AM
blanks in data validation list dropdown confused Excel Worksheet Functions 7 June 7th 06 02:10 PM
size of data validation dropdown list Stefi Excel Worksheet Functions 2 December 8th 05 03:36 PM
Data Validation - Dropdown List Not Appearing MWS Excel Discussion (Misc queries) 2 April 25th 05 05:05 PM


All times are GMT +1. The time now is 05:28 PM.

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

About Us

"It's about Microsoft Excel"