Making a Cell drop down?

[rkovelman]

I was wondering how in Excel, I can make a cell drop down. What I
mean is if there is a cell with information in it, but then I want a
cell to drop down with more information in it. So it is hidden unless
I want to view it. Is there a way? I am thinking its like a venetion
blind
Thanks
Ross

 

[Bob Greenblatt]

I was wondering how in Excel, I can make a cell drop down. What I
mean is if there is a cell with information in it, but then I want a
cell to drop down with more information in it. So it is hidden unless
I want to view it. Is there a way? I am thinking its like a venetion
blind
Thanks
Ross

If all the information is in the cell, the only way to do this is with code
that changes the row height. You might try with cell notes (comments) that
way additional information will show when you ³mouse over² the cell. But,
the comment information is not part of the cell¹s data available to other
cells and calculations, unless you again use code.

 

[Laroche J]

I was wondering how in Excel, I can make a cell drop down. What I
mean is if there is a cell with information in it, but then I want a
cell to drop down with more information in it. So it is hidden unless
I want to view it. Is there a way? I am thinking its like a venetion
blind
Thanks
Ross

Perhaps you'd be interested in Data / Validation. In the dialog, under the
Settings tab, select Allow List and set the Source to the range where the
allowed values are stored.

JL
Mac OS X 10.4.10, Office v.X 10.1.9