ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What is this Excel feature? (https://www.excelbanter.com/excel-discussion-misc-queries/174609-what-excel-feature.html)

joeu2004

What is this Excel feature?
 
When I look at the MS Office Template called LoanAmortization1 (for
Excel 2007), it has a feature that I do not recognize.

What is it? How was it created (i.e. what keystrokes)? And how can I
edit it? Is this feature limited to Excel 2007?

When I select cell D10, an explanation pops up. It looks like a
comment, but I believe it is not. There is no red triangle in a
corner of the cell; the explanation does not up when I simply hover
the mouse cursor over the cell; and when I right-click, the menu shows
Insert Comment, not Edit Comment. Also, the template has no macros.

I should note that although the template was originally created and
saved as an Excel 2007 file, someone "converted" (saved) it to an
Excel 2003 file for me, and I am using Office Excel 2003 to access it.

T. Valko

What is this Excel feature?
 
Sounds like a data validation input message.

Select the cell in question
Goto DataValidationInput message tab

--
Biff
Microsoft Excel MVP


"joeu2004" wrote in message
...
When I look at the MS Office Template called LoanAmortization1 (for
Excel 2007), it has a feature that I do not recognize.

What is it? How was it created (i.e. what keystrokes)? And how can I
edit it? Is this feature limited to Excel 2007?

When I select cell D10, an explanation pops up. It looks like a
comment, but I believe it is not. There is no red triangle in a
corner of the cell; the explanation does not up when I simply hover
the mouse cursor over the cell; and when I right-click, the menu shows
Insert Comment, not Edit Comment. Also, the template has no macros.

I should note that although the template was originally created and
saved as an Excel 2007 file, someone "converted" (saved) it to an
Excel 2003 file for me, and I am using Office Excel 2003 to access it.




joeu2004

What is this Excel feature?
 
On Jan 27, 2:43*pm, "T. Valko" wrote:
Sounds like a data validation input message.
Select the cell in question
Goto DataValidationInput message tab


Bingo! Thanks.

T. Valko

What is this Excel feature?
 
You're welcome!

--
Biff
Microsoft Excel MVP


"joeu2004" wrote in message
...
On Jan 27, 2:43 pm, "T. Valko" wrote:
Sounds like a data validation input message.
Select the cell in question
Goto DataValidationInput message tab


Bingo! Thanks.




All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com