excel row height
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777
STL

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

Excel Row Height

resolvedResolved · Low Priority · Version 2003

Mon 16 Jun 2008, 16:42 replyReply Delegate Kate said...

Kate has attended:
No courses

Excel Row Height

Do you know what has happened if you format the row height to be 12.75 high and you have the text positioned vertically at the bottom but it still disappears half way up the cell?

Thanks,
Kate.

For upcoming training course dates see: Pricing & availability

Wed 18 Jun 2008, 15:06 replyReply Trainer David said...

RE: Excel Row Height

Hi Kate

You may need to adjuct your row height to show all the infomation in the cell. There are 3 ways you can do this.

Firstly if you position your cursor on the row header of the cell height you wish to be altered and then move slightly down so that you are directly on the line separating the rows, your cursor will change to a cross. If you double click it wil automatically resize the row to fit in all you info.

You can also drag the line below the row header until you have the desired height.

A third way would be to go format/row/height and then type in the height you require.

Hope that answers your question.

David


 

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips

Training courses
London & UK

Live dates & prices »

On-site training

Get a quote »

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.



Excel training
Course rating
4.7 stars - based on 25745 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom

info@microsofttraining.net

Resources

X

Search