ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Extra Line in Cell (https://www.excelbanter.com/excel-discussion-misc-queries/117768-extra-line-cell.html)

Missile Man

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

Bernard Liengme

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




Missile Man

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






All times are GMT +1. The time now is 05:15 PM.

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