Software

Ask something
Question Locked

Formatting in Excel 2003

0 helpful
4 replies

by cjeanne99

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a template that has fixed width columns for my data. Column A is populated with text and is set to wrap. In some cases, Excel adds an extra line to the text. It's as if Excel is anticipating that IF the cell had one more character it would need to wrap again. The template is used to create 12 worksheets within 254 workbooks. The extra line is appearing in multiple places on the output - so I can't predict that a specific cell will have the extra line. Any suggestions would be appreciated.

4 replies

by thumbsup2

Click inside one of the cells that has what appears to be an extra line, then click to the far right side of the forumala bar. If the cursor position idicates there is at least one space after all of the text in that cell, there's your culprit.

Of course, you'll need to check each and every wrapped cell. There's no shortcut to do it.

---

by cjeanne99

Already looked for additional spaces in the source text - there are none. I'll have to go back to the output docs created by the template and see if an extra space is in THAT text.

by rkinnett12002

Late response, but in case anyone else runs across this post:

A period at the end of a text cell seems to cause that obnoxious extra line. Other people say it has to do with TrueType fonts; not the case for me in '07Pro, VistaHome.

-Ryan

This discussion is closed to new replies.