Change drip down selection for entire coumn

Kyle Sullivan

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? 

Mike Wilday

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.

Kyle Sullivan

Perfect! I didn't realize you could do that with a drop down list, thanks!

 

Mike Wilday

You're welcome!