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!
