Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank lines in text cells
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank lines in text cells
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank lines in text cells
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. |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
blank lines in text cells
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. |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter various number of blank lines in cells | New Users to Excel | |||
grid lines printing with blank cells | Excel Discussion (Misc queries) | |||
Blank lines in cells | Excel Discussion (Misc queries) | |||
No blank lines in text files | Excel Discussion (Misc queries) | |||
No blank lines in text files | Excel Discussion (Misc queries) |