ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i add an drop down arrow to a cell (https://www.excelbanter.com/excel-discussion-misc-queries/193186-how-do-i-add-drop-down-arrow-cell.html)

little c

how do i add an drop down arrow to a cell
 
I am trying to create drop down arrows with list of numbers, or date, etc. I
cannot remember how. I have tried everything like validation then the list
option, please help.

Jarek Kujawa[_2_]

how do i add an drop down arrow to a cell
 
in Excel 2003
Data-Validation-List

TomPl

how do i add an drop down arrow to a cell
 
Once you get to the "List" options you can add your values (separated by
commas) to the lower box or you can put the range that contains your options
in that box.

"little c" wrote:

I am trying to create drop down arrows with list of numbers, or date, etc. I
cannot remember how. I have tried everything like validation then the list
option, please help.



All times are GMT +1. The time now is 09:08 PM.

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