word wrap without row expansion?

[Kane]

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]

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.

 

[Kane]

Interesting. I also use the filters on this sheet. Would merging cells
effect that performance?

 

[Kevin B]

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]

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]

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.