ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autofit text into a cell (https://www.excelbanter.com/excel-discussion-misc-queries/142265-autofit-text-into-cell.html)

rp2chil

Autofit text into a cell
 
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/comm...xp=&sloc=en-us

Thanks so much.

challa prabhu

Autofit text into a cell
 
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

"rp2chil" wrote:

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/comm...xp=&sloc=en-us

Thanks so much.



All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com