Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

word wrap without row expansion?

0 views
Skip to first unread message

Kane

unread,
Oct 15, 2008, 12:53:02 PM10/15/08
to
How can I edit a cell many times without it expanded the row everytime I
finish?

I use excel for tracking status of issues and projects (who doesn't?). I
like to edit my notes in a cell periodically using alt-enter for a little
formatting. I also like the row height to be uniform with all the other rows
for easier scrolling and viewing. And when I want to view the contents of
the notes cell I click on it and read the contents in the formula bar. Works
great. Except everytime I finish editing the notes cell, the row expands for
that cell. Is there anything here I can do to keep it from expanding?

Kevin B

unread,
Oct 15, 2008, 1:03:09 PM10/15/08
to
You could merge 2 cells horizontally and place your notes in the merged cell.
Row height does not automatically adjust for text in a merged cell.
--
Kevin Backmann

Kane

unread,
Oct 15, 2008, 2:59:04 PM10/15/08
to
Interesting. I also use the filters on this sheet. Would merging cells
effect that performance?

Kevin B

unread,
Oct 15, 2008, 3:54:04 PM10/15/08
to
It doesn't have any impact on AutoFilter, however it can get testy about
sorting.

On the other hand you could remove the Wrap Text format from the cells in
the column that contain your notes.

Kane

unread,
Oct 15, 2008, 4:33:02 PM10/15/08
to
So I would have to manually remove the wrap text formatting from each cell
each time I edit it? I think I am back to my original need here.

Kevin B

unread,
Oct 15, 2008, 5:12:01 PM10/15/08
to
If you don't want the cell to wrap why would you format it to do so?

Once you remove the format from the cell and save your workbook it stays
that way unless you reformat the cell.

0 new messages