In excel, how do I enter unique cell information in a column

S

snowdog120

I do not want to input duplicate data in any cell of the same column, in an
excel spreadsheet.
 
T

Teethless mama

Highlight your range,

In the Menu Data>Validation>Under Allow: select Custom>Under Formula:
=COUNTIF($A$1:A1,A1)=1
click OK
 
Top