Rudi has attended:
Excel Intermediate course
Extending drop-down lists
I’m trying to extend drop-down options down columns on a spreadsheet but am afraid I will erase existing data if I do so. The drop-down list only goes to a certain row before you have to input the data yourself. Do you know how to extend the drop-down list?
RE: Extending drop-down lists
Hello Rudi,
Thank you for your question. To copy the drop-down list to more cells down a column, select the last drop-down cell in the column, place your mouse pointer on the bottom right-hand corner of that cell, (it will change to a black plus) then click and drag downwards. This will extend the drop-down cells down the column.
You're quite right about deleting existing data further down the column. You will need to check for any existing data, then perhaps insert more rows before copying the drop-downs.
I hope this helps.
Kind regards
Marius Barnard
