I'm working on a worksheet in Excel....for several of the columns, I would like to set up a pull down menu of standard choices (suppliers, income range, etc.). For the life of me...can't figure out how? Tx-in-advance!
2006-11-09 07:26:19 · 2 answers · asked by l2brennan 2 in Computers & Internet ➔ Software
Go in the Data menu, then select Validation.
You can select "List" in the drop-down menu and enter either a cell range or custom values in this format: "A;B;C" (without the quotes)
Good luck!
2006-11-09 07:31:06 · answer #1 · answered by Bernz 6 · 0⤊ 0⤋
I surely have place of work 2010 however the device is an identical. you like a record of things each written in seperate cells for the drop down menu. next click the cellular you like the dropdown to be on. Now below the information menu there ought to be tha 'documents validation' device. choose for that and a small window will look, below the 'enable' dropdown record choose for 'record' and below for the source, click the button on the ultimate suited and spotlight your cells with the counsel on and press the button returned. Then click ok and additionally you have a drop down.
2016-12-14 04:26:19 · answer #2 · answered by vogt 4 · 0⤊ 0⤋