| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop text carries over
We all knows that long text will carries over to the next empty cell, but how
to stop it. That is the long text in cell A1 will not carries over to cell B1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stop text carries over
You have 2 options, the text will wrap so your cell/row will become deeper or
you can shrink the text to fit in you existing cell width. These are in the Format - Cells - Alignment options "Godwin Chan" wrote: We all knows that long text will carries over to the next empty cell, but how to stop it. That is the long text in cell A1 will not carries over to cell B1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stop text carries over
On Jul 4, 1:33*pm, Dennis wrote:
You have 2 options, the text will wrap so your cell/row will become deeper or you can shrink the text to fit in you existing cell width. These are in the Format - Cells - Alignment options "Godwin Chan" wrote: We all knows that long text will carries over to the next empty cell, but how to stop it. That is the long text in cell A1 will not carries over to cell B1- Hide quoted text - - Show quoted text - hey you have one more option. Stop writin so long text... kidding!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stop text carries over
Actually the case I face is
Cell A1 Cell B1 Cell C1 F/F & EQUIPMENTS (Compu software) ( nothing in it) Site office but the sheet shows F/F & EQUIPMENTS (Compu (blank) Site office The remaining text in A1 "software)" cannot carries over . "Godwin Chan" wrote: We all knows that long text will carries over to the next empty cell, but how to stop it. That is the long text in cell A1 will not carries over to cell B1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I stop my text being truncated at RHS of a cell? | Excel Discussion (Misc queries) | |||
| Need Sales Quote Template that carries over to more than one page | Excel Discussion (Misc queries) | |||
| stop text box from resizing | Charts and Charting in Excel | |||
| stop text to data split | Excel Discussion (Misc queries) | |||
| How to stop text changing to date | Excel Discussion (Misc queries) | |||
Linear Mode
