×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Wrap Text in Excel2000
3

Wrap Text in Excel2000

Wrap Text in Excel2000

(OP)
I have a simple spreadsheet in Excel 2000.

The row descriptions are fairly long (50-150 characters), so i used the wrap text function.

It did move the text onto another line in the cell but the row height did not change. I have to manually resize the row height to be able to see the contents.

It may not seem like a big deal but it's a pain.

Can anybody help?!?!?

RE: Wrap Text in Excel2000

I'm sure there is an easier way to do this without having to force a line break, but here is my suggestion.

You can <ALT>+<ENTER> at the end of the desired line to force a carrage return within a cell, producing a multi-line cell.  Every time I use this method, the row automatically adjusts in height.  If the cell column is too narrow, I still get the automatic word wrap, so the column sizes still have to be adjusted manually.

RE: Wrap Text in Excel2000

Menu->Format->RowHight
Wasnt there some option to automatically resize row hights for the whole sheet?

RE: Wrap Text in Excel2000

If rowheight does not auto-adjust just select the entire column conatining the text (by clicking the column header) and do - Format>Row>Autofit

If you want to do it for the whole worksheet, select all cells (by clicking the small grey square located above the row header for Row 1 and to the left of the col. header for Col.A) and do - Format>Row>Autofit

RE: Wrap Text in Excel2000

You can also double click on the edge between two rows or columns, they will then autofit automatically!

Select the cell you'd like to wrap text. Right click, choose Format cells (or menu Format and then Cells) and select the sheet [n]Alignment.
Check the check box Wrap text it should automatically adjust the row height if the text exceeds the columnwidth, regardless of the text being one word or more.

Jonathan

RE: Wrap Text in Excel2000

(OP)
Thanks for your help guys - some good pointers there.

Cactus - I am using wrap text, it's just not resizing the row heights. Like Tigrek, I thought (and have seen) row heights automatically resize without having to use any tools or special formats.

Go on call me lazy...

RE: Wrap Text in Excel2000

(OP)
I've just cracked it!

In the same screen where you choose wrap text, there is also vertical and horizontal alignment.

I had the cells set to vertically align at the top. If you change it to any other option (centered works best) the row height does automatically resize!

Thought I'd let you all know.

Thanks for your help anyway!

RE: Wrap Text in Excel2000

Good work, DanielH
I've been working with XL for some years now and encountered this problem but never really found out...
Thanks, once again

RE: Wrap Text in Excel2000

DanielH, Like Mala I wondered why it only worked sometimes...

Now add the the "merged" property to multiple cells on a single row.  Autofit once again does not work, but I'd really like it to.  (I use Excel 97 & 2000)

Has anyone found a way?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close