ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   drop down box (https://www.excelbanter.com/excel-worksheet-functions/21891-drop-down-box.html)

gbeard

drop down box
 
How do I create a drop down box in a cell? I would like 2 drop down boxes
on a sheet, one to select a different sheet to get data from and another one
that simply has 3 options.

Thanks in advance,
Gary



gbeard

Click on the cell, select

DATAVALIDATIONLIST

Make sure "in-cell dropdown" is checked and put the source cells in the
SOURCE box.




All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com