| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extra Line in Cell
I have an Excel Document with several columns and these columns are set to
text wrap. There are several cells that I have deleted information from and entered in new information. When I enter in new information, the first line of the cell is blank. How did I get this line and how do I remove it? Thank You, Missile Man |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extra Line in Cell
No the first line is not blank; rather the cell is displaying the
information with vertical alignment set to bottom. Select the cells; use Format | Cells; open Alignment tab and set vertical to Top best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Missile Man" <Missile wrote in message ... I have an Excel Document with several columns and these columns are set to text wrap. There are several cells that I have deleted information from and entered in new information. When I enter in new information, the first line of the cell is blank. How did I get this line and how do I remove it? Thank You, Missile Man |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extra Line in Cell
Thanks.
"Bernard Liengme" wrote: No the first line is not blank; rather the cell is displaying the information with vertical alignment set to bottom. Select the cells; use Format | Cells; open Alignment tab and set vertical to Top best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Missile Man" <Missile wrote in message ... I have an Excel Document with several columns and these columns are set to text wrap. There are several cells that I have deleted information from and entered in new information. When I enter in new information, the first line of the cell is blank. How did I get this line and how do I remove it? Thank You, Missile Man |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem: Copying a cell that contains line breaks adds extra quotes | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How to remove an extra line added by excel when pasting into notep | Excel Discussion (Misc queries) | |||
Linear Mode
