excel row height
Courses running during train strike
Hide

TrustPilot

starstarstarstarstar Excellent

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