Viewing Cell Data

[Jeff]

I just downloaded a Loan Amortization Schedule template. When I enter data in
the cells, I can only see it if I highlight the cells. How do I make the data
alway appear?

 

[Tyro]

I have no idea. You don't state what template you downloaded and from where
you downloaded it so that someone could look at it. We are not mind readers.

Tyro

 

[Jeff]

I downloaded the loan amortization schedule template from MS Office online.
It is this one:
http://office.microsoft.com/search/...ID=XA9DAzWzI&respos=3&rt=2&pid=CT101172751033

 

[Gord Dibben]

Jeff

Generally a good idea to post the URL of the Template in question.

There are a few of them.

I will assume this one................

http://office.microsoft.com/en-us/templates/TC010197771033.aspx?pid=CT101172751033

Where are you entering data? Which cells?

Should be entering at the top in column D rows 6 through 13 under the "Enter
Values" category.

I have no problem seeing what I enter in those cells.


Gord Dibben MS Excel MVP

 

[Tyro]

I downloaded the template and tested it in Excel 2007 and it works just
fine. How are you "highlighting the cells"?

Tyro

 

[Jeff]

The cells that I do not see the data I enter into them are columns A-J rows
18 and up. The data is there, but I can only see it when those cells are
highlighted.

 

[Tyro]

You enter your data in cells D5 through D10 and nowhere else. All of the
other cells are calculated after you enter the data in D510

Tyro

 

[Jeff]

I downloaded the template again and only entered data into cells D510. No
other data appears in any of the other cells. Shouldn't I also enter data
into cells H5:H10?

 

[Tyro]

No, absolutely not. The worksheet calculates those cells for you. D4 says
"Enter values", you enter the values in D510 and all other cells are
calculated for you.
Tell me what you're entering in D510

Tyro

 

[Jeff]

I found my problem. I was using 0% in cell D7 which I guess is an invalid
value. I entered 1% in D7 and the calculations were all entered into the
remaining cells. Thank you all for your help.

 

[Tyro]

In Excel 2007, you're not allowed to enter 0 in cell D7. It must be 1
through 30 to be valid.

Tyro

 

[Gord Dibben]

D7 is "loan period in years".

Maybe you meant D6?

Whatever the case, sounds like you're sorted out.

Thanks for letting us know what your solution was.

Your original description of the problem was not quite what was happening..

You could see the data you were entering, just couldn't see the results of the
formulas.


Gord