Autofit text into a cell

G

Guest

Hi, I have a huge file that has rows and rows of text. On my screen the text
appears as though it fits on the cell, when I print it, it is chopped off, or
title rows.

I have tried to autofit, but it doesn't fix it (it doesn't expand the row to
fit the text in). Some of the text items are not that large about 100
characters.

I went to this link for fix, but didn't help:
http://www.microsoft.com/office/com...5298&catlist=&dglist=&ptlist=&exp=&sloc=en-us

Thanks so much.
 
G

Guest

Hi,

Do the following:

1. Click the left corner to highlight the whole worksheet.
2. Right-click in side the worksheet.
3. Click Format Cells. The Format cell dialog box diaplays.
4. In the Format Cells dialog box, click the Alignment tab.
5. Under Text Control, click the Wrap text check box.
6. click Ok. to return to the worksheet.

Challa Prabhu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top