Forum Discussion
copy command
Hello, I am a business user. I am trying to copy this command to the other rows. I created a data validation and rules. The rules, it makes me make a new rule for every row. I am trying to copy ...
Copy only data validation (validity rule) from cells
Select the cell that contains the data validation to be copied.
Activate copy mode (Ctrl + C).
Highlight the target cells.
Right-click a cell in the selection.
From the context menu list, select Paste Special.
In the Paste Special dialog, check Validation (Ctrl + Alt + V).
Confirm your setting. by clicking OK.
Additional info:
File with data validation examples.
Hope I was able to help you with this information.
Thank you for your understanding and patience
I know I don't know anything (Socrates)