Thread: data validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
b166er
 
Posts: n/a
Default data validation


hi members,

i used data validation on my data consists of more
than 6000 rows when i clicked on circle invalidation entries there was
message(your worksheet contains more than 255 invalid cells.only the
first 255 cell will be marked) how can i increase that limit of 255
cells.


--
b166er
------------------------------------------------------------------------
b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=552659