How to hide a list
How to hide a list
(OP)
Hi,
Here's what I'm working with:
http:// i163.photo bucket.com /albums/t2 82/Calc_ph otos/Excel Help01.jpg
I have made a list of the different temperatures using Data>Validation. Using vlookup I've connected the temp with the yield stress values.
I would like to hide the grayed out values.
How can this be accomplished?
Thank you.
Here's what I'm working with:
http://
I have made a list of the different temperatures using Data>Validation. Using vlookup I've connected the temp with the yield stress values.
I would like to hide the grayed out values.
How can this be accomplished?
Thank you.





RE: How to hide a list
JMW
www.ViscoAnalyser.com
RE: How to hide a list
RE: How to hide a list
RE: How to hide a list
For example attached in sheet2 I highlighted A1:A8 and typed insert/name/create/TopRow.
Then in sheet 1 data validation tab in list box I put =TempData.
Then as stated sheet 2 could be hidden if desired.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: How to hide a list
Nice way to start off the week :)
RE: How to hide a list
mhtml:http://off