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

excel row height

ResolvedVersion 2003

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.

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:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.