I have an existing data validation list (it has about a dozen items in it). I need to add two items at specific locations in that list.
To edit the existing list I clicked on:
Data > Validation...
In the "Data Validation" popup, I selected the Settings tab
On that tab, "Allow" shows "List"
On...
I regularly distribute spreadsheets to a number of people and take their updates, consolidate them and prepare a report.
To quickly spot updated fields, I take (for example) columns A-E and copy them to AA-AE, then apply conditional formatting on columns A-E so that if the cell (for example) B5...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.