Using Excel online, how do I update the data validation to all cells in the column?

Question

Using Excel online, how do I update the data validation to all cells in the column?

Anonymous

I have an Excel Online workbook with a sheet that contains tables for data validation. Another sheet in the same workbook contains the data. When I add an item to the validation list, the data worksheet does not update. In the desktop Excel, I can copy and paste validation (paste special) from one cell to the rest of the column, but I can't figure out how to do this in Excel Online. Is there a way for the validation to update when the table is updated?

Thank you

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Hi Anams_473,

Thank you for writing to the Microsoft Answer Community Forum, I am Gunasekar, an advisor and a user like you, and I am glad to be helping you out today.

I understand you want to Update the data validation to all cells in the column. I have found related articles for your reference.

Here is a link:

https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-add-existing-drop-down-lists-with-data/40c9509e-cfe8-423d-b28e-40265fa313e5#

Select the cell(s) and click ‘Data’ from the tab list.
Click ‘Data Validation’ from the ‘Data Tools’ group in the ‘Data’ tab.
You’ll see the data validation dialogue box.
Select ‘List’ under ‘Allow’
Make sure the ‘In-cell dropdown’ checkbox is checked
Lastly, supply the ‘Source’.

I hope this information helps. If you have any questions, please let me know and I’ll be glad to assist you further.

Best regards Gunasekar N

Share via

Using Excel online, how do I update the data validation to all cells in the column?

0 additional answers