Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I have added a column to my sheet that is a drop down list column. I would now like to automatically have these selected as, "Not Started". Is there a way to do this other than going down and automatically updating each cell?
You can click on the first cell after you change it to Not Started, and then drag the bottom right corner of the cell down and it will apply it to all of the other cells. You're still updating every row, but it's not as time-consuming.
Perfect! I didn't realize you could do that with a drop down list, thanks!
You're welcome!
