Free Microsoft Excel 2013 Quick Reference

Text wrap and allow cell height to increase with wrap

I am trying to format a page where all employees can access it. I need cells to text werap (I know how to do that) but I need the cell to increase in size as the wrap takes place. I don't want to explain to all the users to enlarge the cells etc. I want it automatic. Any help?


Post your answer or comment

comments powered by Disqus
Hi All

I need to be able to auto-expand some already wrapped and merged cells. The merged area is already quite large, however, often more text is required and this remains out of sight if in excess of the already merged area. Users are having to play around with the cell heights which is causing some confusion amongst some of them.

Is there a way of auto-expanding the area should someone input excessive text, so all text will be shown?

If a VBA is required, will this work on the whole worksheet (and additional worksheets saved in the same spreadsheet), or are multiple VBA modules required?

Will it also work for all users if the sheet/s are protected by the author?

Example sorksheet attached. The text boxes are cell B11, B32, B42 and B64. Would a VBA also affect all cells on the sheet or can it just affect these specific merged areas

(I have Excel 2007)

Many thanks in advance.

Thanks in advance for you help,

I am creating a template which will be used to track large accounts. Text
will be entered directly into cells, and most of the text will not require
the row to expand in size. For the cases where I need an unlimited amount of
room for text entry, I merged the cells across most of the printable field
and then checked text wrap, and align left, but I can't get it to work. In
addition I have formatted the rows to allow autofit, so then can expand
automatically. What do I need to do to fix this simple problem?

Thanks,
Steve

I know how to set automatic text wrap in a cell ... but how can I
automatically wrap text in a cell ... and have the cell resize larger
automatically as I add more text? Thanks.

Some cells contain text that is concatenated from several cell references.
How do I automatically adjust the cell height to accommodate the resulting
content?

Hi,

I have incorporated text wrapping in a cell, but everytime I press Enter to
create a new line of text/paragraph within the cell, the cursor jumps to the
next cell below. How can I overcome this?

Many thanks,

Simon.

Hi experts,

i have a combobox on a userform. The user selects a value.
Then i have to lookup the value in a range (zoekrange) and delete the cell
containing the value and the cell next to it. I tried resizing the zoekrange
but it did not work.
Here's my code so far...

Private Sub but_verwijder_Click()
Dim zoekrange As Range
Application.ScreenUpdating = False
Sheets("hulpblad").Select
Set zoekrange = Range("b2:c500").Find(cbo_accountnr.Value)
zoekrange.Resize(0, 1).Delete shift:=xlShiftUp
MsgBox "done"
Sheets("nieuwe productie 2006").Select
Application.ScreenUpdating = True
Unload Me
End Sub

any ideas please ?
thanks,
Pierre

--
Message posted via http://www.officekb.com

how do I insert picture and have cells shifted to make room for it so
insertrd picture doesnt cover any cells that would otherwise be underneath
the inserted pic?

In the past, I would use the text wrapping function for an entire column and then the rows would increase in size to accomodate how many lines of wrapped text is needed for the cell. For ex:

Say column C is formatted for text wrapping and the column has a width of 15. Cell C1 has 2 words, C2 has 10 words, and C3 has a paragraph of words. Since all of these cells are wrapped, shouldn't the rows automatically adjust to find the row hieght that is appropriate for the amount of each cell's wrapped text? So C1 would be of one line hight, C2 would probably be around 2 line heights, and c3 would be around 20 line heights, etc.

As I said above, in the past this seems to have worked for me, but now the row heights are staying the same for each and I have to manually adjust them to make all the words fit. Any suggestions? Thanks,

Don

I often find that with a cell set to "wrap text" the cell opens up an
additional line before a charater of inserted text is actually placed
on (wrapped to) the new line. With a certain length of text in the
cell, a blank line appears at the bottom of the cell. (If the cell is
set to vertically align its contentes to "top".)

Short of manually setting the cell height to an explicit fixed value,
is there any way of preventing this behavior? Such that the cell is
always "filled," i.e., no blank line.

I'm using WinXP, SP-2 and Excel 2003, but it has been a problem with
Win2k SP-4 and Excel 2000 as well. I suspect it's a problem with all
versions of Excel.

Is this "too hard" for Microsoft to fix?

Thanks,

Fred Holmes

Hello there,

I've been trying to look for a way to wrap the text and display it in
the row by adjusting the row height. I have found a way of doing this
for a selected cell, however i need my macro to be able to traverse
through the sheet and perform the task. I am not familiar to vba
functions and would appreciate if some one could provide sugggestions
on how to achieve this.

In my case the cells aren't merged!
/*****************
Sub AutoFitMergedCellRowHeight()
Dim CurrentRowHeight As Single, MergedCellRgWidth As Single
Dim CurrCell As Range
Dim ActiveCellWidth As Single, PossNewRowHeight As Single
If ActiveCell.MergeCells Then
With ActiveCell.MergeArea
If .Rows.Count > 1 And .WrapText = True Then
Application.ScreenUpdating = False
CurrentRowHeight = .RowHeight
ActiveCellWidth = ActiveCell.ColumnWidth
For Each CurrCell In Selection
MergedCellRgWidth = CurrCell.ColumnWidth + _
MergedCellRgWidth
Next
.MergeCells = False
.Cells(1).ColumnWidth = MergedCellRgWidth
.EntireRow.AutoFit
PossNewRowHeight = .RowHeight
.Cells(1).ColumnWidth = ActiveCellWidth
.MergeCells = True
.RowHeight = IIf(CurrentRowHeight > PossNewRowHeight, _
CurrentRowHeight, PossNewRowHeight)
End If
End With

End If
End Sub
***************/

Thank You

--
AK

I often find that with a cell set to "wrap text" the cell opens up an
additional line before a charater of inserted text is actually placed
on (wrapped to) the new line. With a certain length of text in the
cell, a blank line appears at the bottom of the cell. (If the cell is
set to vertically align its contentes to "top".)

Short of manually setting the cell height to an explicit fixed value,
is there any way of preventing this behavior? Such that the cell is
always "filled," i.e., no blank line.

I'm using WinXP, SP-2 and Excel 2003, but it has been a problem with
Win2k SP-4 and Excel 2000 as well. I suspect it's a problem with all
versions of Excel.

Is this "too hard" for Microsoft to fix?

Thanks,

Fred Holmes

I know this is probably a painfully fundamental question, but I have never run into this situation before. Either if I have text wrap set for a cell (or series of cells) or when I do a hard carriage return in the cell(s) (Alt + Enter) I would expect the row height to increase to show all of the text. However, the cell always remains at the same height hiding any text that is bumped down. Is there any way around this?

When formatting a cell with text wrapping, the row is not automatically
increasing in height to account for extra text. Therefore, some text is
hidden. Is there something that can be done while formatting for wrapping so
that this will not occur.

I have merged a number of cells and included text that wraps in the cell. Is
it possible to set the cell so that the height is automatically adjusted to
the height of the text?

I've tried searching and couldn't find any results, and I've also tried many of the different cell formatting options, but I cant find a way to get Excel to automatically expand the cell height when the text becomes to long to display. Is there something I am missing that will accomplish this, or do I need to write some VBA that will make the cell larger once the character limit that will fit on one row is exceeded?

Thanks!

While Printing a report in 2003, the last column on the right side is over 100 characters and even reducing the text to 80% or even 75% does not allow it to be printed all across the page. I tried text wrap in "Format Cells" and in the alignment tab I selected Horizontal = "general", and vertical = "top" and then I click on "wrap text." In some of the wider cells the word wrap words well and in others it just cuts off part of the text.

Do I have to highlight all of the columns before I do the alignment?

What would the proper procedure be.

Thank you in advance for your help.

ChickenParm2Go

Hi!

Is there a way to specify if there are 46 characters in a cell, to apply text wrap, indent the second line, and resize the row height to 25.5?

For example, I always will have text on merged cells B7:C7. I'd like to have a macro that determines if the text goes over C7 (I figured that it would take 46 characters to do this), that the merged cells will be text wrapped, then row 7 will be resized to 25.5.

Please help! I know how to record a macro that will text wrap and resize the row height but am not sure how to do the "if" condition. Thanks much!

Question if you have a merged cell, with wrap text selected and auto row height, it only shows you the first part of the text. Is there any way around this?

Any help would be appreciated.

Is there a way that, after inputting text into a word-wrapped cell, when you tab out of it, the cell is automatically increased in height to show all the text? This is for merged cells.

TIA

Geoff Culbertson
Petersfield, Hampshire, UK

Hi,

I am confused with text wrapping. I have two separate workbooks, where i am using drop down menus. In one workbook, the cell automatically wraps and resizes to the content of the drop down cell content. In my other workbook, the cell size (height) doesnt adjust. I cant seem to find the difference?

Can anyone assist with infroming me how I can make the text boxes automatically wrap and rejust their height?

Kind regards,
Mil.

I'm using Excel 2007, and am running into a formatting issue.

Lets say I have merged cells A2, A3, A4 & A5. I have also set the text to wrap, and set the row to Autoheight.

My problem is the merged cell does not automatically adjust in height. The text does wrap properly, and I can manually adjust the row height to display the text properly. If I unmerge the cells, the information in A2 does Wrap and AutoHeight correctly.

This has something to do with the merging of the cells.

I can take contents of the merged cell and place the value in another cell. Lets say in cell A10, I use a formula "=A2", if the cell width is set to the same as the merged cells it will format correctly. By that I mean cell A10 will wordwrap and Autoheight correctly, and with the height of the row changing, Now cell A2 display correctly. This is my current work around.

Any thoughts would be appreciated

I have 3 column that are merged cells that I would like to text wrap. I
understand that Excel has a problem doing this, but is there some sort of
formatting I can to make it automaticaly adjust my row height. If there is
then please let me know. Normally I would just do it manually but there are
some formulas I don't want screwed up and other people will be entering data
so I want to protect my worksheet.....Thanks in advance for any help or
attempted help.
Travis

Hi - Does anyone know if there is maximum number of characters in a cell, above which wrapping and the row height auto-fit functions will not work? I typed a paragraph into a cell and have the cell set to wrap and the row height to auto-fit but it does not display on print preview or on actual printing past a certain character in the cell. Even when I manually increase the row height, it still does not display. Thanks for your help.

Hi All, I understand how to automatically set a text box size to display text contained by right-clicking the textbox and put a check in the auto-size box under "Alignment".

However I would like to set the widht of the text box and automatically adjust the height according to the number of lines of text. Is this possible by VBA code or othe means?

Thank you for any suggestions. CDT


No luck finding an answer? You could always try Google.