Forum Discussion
copy paste validation only on excel online
How I copy paste data validation only in excel online
thanks for your answer I want past data validation only without formatting or formula in excel online
Hi Sherif! Yes, I understood that and explained how to do it in my first post.
Hello dscheikey, I am also trying to figure out how to copy validation in the web version of Excel. When I follow the instructions you outlined, I'm not given the choice to copy the validation from the source, it just brings up the window to define a validation settings (and overwrite for all selected cells).
Just to help me understand what's happening here, holding CTRL after clicking one cell just selects all of them right? I think I must be missing a step to say which is the source for the formatting.
Thanks for your help
