| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent Row Height from increasing when Pasting lenghthy text into Cell.
Hello,
In Excel 2000, whenever I paste a large paragraph into a single cell, the cell/row height increases. Is there a way to prevent this from happening, keeping it at the default 12.75? Thank you in advance. Hal. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Prevent Row Height from increasing when Pasting lenghthy text into Cell.
IF you FIRST change the row height to 13 or 12.5 (a wee bit off 12.75), OR
FIRST use Format/Row/Height (and leave it as 12.75), it won't happen. However, you may see very little of the text -- it's still marked as word wrap. The smallest # of steps to rectify the original problem is to do the paste, then format the cell to NOT be word wrap. "Hal" wrote in message ... Hello, In Excel 2000, whenever I paste a large paragraph into a single cell, the cell/row height increases. Is there a way to prevent this from happening, keeping it at the default 12.75? Thank you in advance. Hal. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Prevent Row Height from increasing when Pasting lenghthy text into Cell.
I have a lot of pasting to do (approx. 3,000 times). They are product
descriptions. I am looking for the most effective way. "Bob Umlas" wrote in message ... IF you FIRST change the row height to 13 or 12.5 (a wee bit off 12.75), OR FIRST use Format/Row/Height (and leave it as 12.75), it won't happen. However, you may see very little of the text -- it's still marked as word wrap. The smallest # of steps to rectify the original problem is to do the paste, then format the cell to NOT be word wrap. "Hal" wrote in message ... Hello, In Excel 2000, whenever I paste a large paragraph into a single cell, the cell/row height increases. Is there a way to prevent this from happening, keeping it at the default 12.75? Thank you in advance. Hal. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Prevent Row Height from increasing when Pasting lenghthy text into Cell.
Thank you for your help.
Hal. "Bob Umlas" wrote in message ... IF you FIRST change the row height to 13 or 12.5 (a wee bit off 12.75), OR FIRST use Format/Row/Height (and leave it as 12.75), it won't happen. However, you may see very little of the text -- it's still marked as word wrap. The smallest # of steps to rectify the original problem is to do the paste, then format the cell to NOT be word wrap. "Hal" wrote in message ... Hello, In Excel 2000, whenever I paste a large paragraph into a single cell, the cell/row height increases. Is there a way to prevent this from happening, keeping it at the default 12.75? Thank you in advance. Hal. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Pasting Text from Outlook into 1 Excel cell | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
