Show the popup text box in cell when you select the cell.
|
raj-excel.blogspot.com |
Select the cell you want to appear popup tex box.
|
raj-excel.blogspot.com |
Goto Data tab and click the Data Validation.
|
raj-excel.blogspot.com |
After the select the Data Validation the drop down tab appear on screen click the Data Validation...
|
raj-excel.blogspot.com |
When you click the Data Validation a new dialog box show in screen. In settings tab select the Validation Criteria In Allow drop down box select the Any value.
|
raj-excel.blogspot.com |
After the selecting of Any value (Don't click the OK button)
Select the second tab (Input Message) get the check in Show Input message when cell is selected.
and Type the Title of the massage and type your massage in Input Massage box and then click OK.
|
raj-excel.blogspot.com |
|
raj-excel.blogspot.com |
No comments:
Post a Comment