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