View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default blank lines in text cells

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

"Ed Williams" wrote:

Still no answers, could someone PLEASE offer advice???

"Ed Williams" wrote:

Horizontal = General
Vertical = Bottom
?

"Kevin B" wrote:

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.
--
Kevin Backmann


"Ed Williams" wrote:

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.