d

Show the popup text box on cell in Excel 2013

Show the popup text box in cell when you select the cell.


Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com


Select the cell you want to appear popup tex box.

Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com

Goto Data tab and click the Data Validation.

Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com

 After the select the Data Validation the drop down tab appear on screen click the Data Validation...

Show the popup text box on cell in Excel 2013
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.

Show the popup text box on cell in Excel 2013
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.

Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com



Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com

No comments:

Post a Comment

Recommended for You

LinkWithin

Related Posts Plugin for WordPress, Blogger...