data validation

umzsexythang

Board Regular
Joined
Jul 11, 2003
Messages
50
Hi guys,

Is there a way that when I data validate cells, the drop down arrow does not disappear when you click on another cell?

Thanks
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,114,675
Messages
5,549,363
Members
410,911
Latest member
AniEx
Top