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. |
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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 12:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com