How to Create a hidden data in Excel

  • Thread starter Thread starter Suvarna Raju
  • Start date Start date
S

Suvarna Raju

I m currently working as a Test Analyst in my firm.I use few templates as a
regular practice.Eg:List box has certain properties as below:
a)Check for the display of "" list box.
b)Check for the default selection in the "" list box.
c)Check that single selection of an item is allowed in the "" list box.

Similarly i deal with many fields like Text fields,option button,check box
and etc having the similar properties.For each and every screen i need test
these fields and hence i need to Enter the basic format properties similar to
what mentioned about manually repeatedly.Its Time consuming hence i need to
copy the same format from wordpad and paste in Excel.

what my idea is If we Enter "List box" in one cell...automatically there
should exists the above formats by default.I mean if I enter List box the
properties associated with the List box should be displayed in the Excel.
below the title and these rows must be in editable mode and also there should
be a feasibility to remove or insert data.

Is there any way?
 
Back
Top