blank lines in text cells

E

Ed Williams

I'm getting blank lines at the tops of text cells. Column widths are fixed
and row heights are set to AutoFit. Cell alignment is set to Wrap text.
What am I missing?

Simple spreadsheet to track time spent on a project. First column is date,
second column is verbal description of work done, and third column indicates
hours spent on those tasks on that day. First and third columns are always
one line and set for Top vertical alignment. Second column is typically
several lines and is the one giving me problems. Changing from the default
Bottom vertical alignment to Top has no effect.

Solutions will be greatly appreciated.
 
K

Kevin B

Select your cells and click FORMAT in the menu & select CELLS. Click the
alignment tab and check to see if you have vertical alignment set to center.
 
E

Ed Williams

Horizontal = General
Vertical = Bottom
?

Kevin B said:
Select your cells and click FORMAT in the menu & select CELLS. Click the
alignment tab and check to see if you have vertical alignment set to center.
 
T

Tom Hutchins

I don't know if this is the same problem you are having, but I had a
worksheet with cells which autosized much wider (column) or taller (row) than
necessary. The problem turned out to be the font, which was Courier. When I
changed the font
to Arial, autosizing worked as expected.

Hope this helps,

Hutch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top