Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2003

Tue 20 May 2008, 16:29 Delegate Catherine said...

Catherine has attended:
Outlook Advanced course
Excel Intermediate course
PowerPoint Intermediate Advanced course

Excel

How do I unhide cells?

Tue 27 May 2008, 13:32 Trainer Amanda said...

RE: Excel

Hi Catherine

Thank you for your question.

You can unhide cells by selecting the columns or rows either side of the hidden cells; then right-click within the columns or rows selected and choose Unhide from the options. The column or row of hidden cells should reappear.

I hope this helps.
Amanda

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Creating a range of monthly payments as text