extending dropdown lists

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Extending drop-down lists

Extending drop-down lists

resolvedResolved · Medium Priority · Version 365

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

Wed 21 Dec 2022: Automatically marked as resolved.


 

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

View all Excel hints and tips


Server loaded in 0.23 secs.