copy paste validation only on excel online

New Contributor

How I copy paste data validation only in excel online 

3 Replies

@Sherif_Abbas 

Please try this: Click on the cell with data validation that you want to copy. Then hold down the CTRL key and click on the cell that should have the same data validation. Then after all cells are selected you can release CTRL. Then click on Data Validation in the menu. Excel asks:

dscheikey_0-1664034714422.png

With YES and Apply you have copied the data validation.

@dscheikey 

thanks for your answer I want past data validation only without formatting or formula in excel online 

@Sherif_Abbas 

Hi Sherif! Yes, I understood that and explained how to do it in my first post.