ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formating problems (https://www.excelbanter.com/excel-discussion-misc-queries/199547-formating-problems.html)

fkosmakos

Formating problems
 
I am using Windows XP Home. I have used excel for over 20 years. I am not an
expert, but I am pretty proficient with it for what I need. Never have had
problems until today.
I am trying to place classmate reunion information in a spread sheet (
please don't ask why). I placed the first name in col A line 1, last name in
column B line 1 and address / phone numbes in column C, line 1. I am then
placing the personal information in the cell C2. I highlight C1 and C2, go to
format, and then select that the text should be to the left and at the top,
and that the text should wrap. The problem is sometimes it wraps, sometimes
it doesnt; sometimes it wraps but only shows the first 14 lines of the text.
If I click once on the cell all of the text shows in a window at the top of
Excel, but not all of it shows in the cell c2; If I double click the cell,
all of the text shows; if I then move the cursor to another cell, the text
below line 14 disappears. Too esoteric? A friend suggested that maybe the
excel file is corrupt, and that I should cut and paste the info from it, into
an new excel spreadsheet.

John C[_2_]

Formating problems
 
The problem you are most likely encountering is you have set a row height.
Once a row height is set by typing in a number, it will not adjust.

Go to menu Format|Row|Autofit

Hope this helps.
--
John C


"fkosmakos" wrote:

I am using Windows XP Home. I have used excel for over 20 years. I am not an
expert, but I am pretty proficient with it for what I need. Never have had
problems until today.
I am trying to place classmate reunion information in a spread sheet (
please don't ask why). I placed the first name in col A line 1, last name in
column B line 1 and address / phone numbes in column C, line 1. I am then
placing the personal information in the cell C2. I highlight C1 and C2, go to
format, and then select that the text should be to the left and at the top,
and that the text should wrap. The problem is sometimes it wraps, sometimes
it doesnt; sometimes it wraps but only shows the first 14 lines of the text.
If I click once on the cell all of the text shows in a window at the top of
Excel, but not all of it shows in the cell c2; If I double click the cell,
all of the text shows; if I then move the cursor to another cell, the text
below line 14 disappears. Too esoteric? A friend suggested that maybe the
excel file is corrupt, and that I should cut and paste the info from it, into
an new excel spreadsheet.


fkosmakos

Formating problems
 
I wish that was it, but it wasn't. I tried and it did not do anything. I
tried on one row, I selected all rows. The typed material does not appear in
the cell even though there is space created by me dragging the cell to a
bigger size. I just have white space and the last sentence ending in
mid-sentece

"fkosmakos" wrote:

I am using Windows XP Home. I have used excel for over 20 years. I am not an
expert, but I am pretty proficient with it for what I need. Never have had
problems until today.
I am trying to place classmate reunion information in a spread sheet (
please don't ask why). I placed the first name in col A line 1, last name in
column B line 1 and address / phone numbes in column C, line 1. I am then
placing the personal information in the cell C2. I highlight C1 and C2, go to
format, and then select that the text should be to the left and at the top,
and that the text should wrap. The problem is sometimes it wraps, sometimes
it doesnt; sometimes it wraps but only shows the first 14 lines of the text.
If I click once on the cell all of the text shows in a window at the top of
Excel, but not all of it shows in the cell c2; If I double click the cell,
all of the text shows; if I then move the cursor to another cell, the text
below line 14 disappears. Too esoteric? A friend suggested that maybe the
excel file is corrupt, and that I should cut and paste the info from it, into
an new excel spreadsheet.



All times are GMT +1. The time now is 11:48 AM.

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