[mso] Excel Validation Copying

Please assume in column K I have the values 1 through 12, and "??". Also 
assume that cells K2 through K7165 contain such values.

Also assume:
Cell K2 = 2
Cell K3=  9
Cell K4= 12
Cell K5= 6


In Cell K2, I made a validation drop down list that will make the user 
choose a value of 1 through 12 or "??".  It did not change the current 
value of that cell, just made a drop down validation list for it.

Can I copy that validation drop down list WITHOUT changing the value of the 
cells below K2? When I tried "copy formula" and paste to Cells K3 on down 
to K7165 without changing the current values of those cells? Possible? It 
would save quite a bit of re-entering.

Thank you.

Robert


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: