View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default word wrap without row expansion?

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.
--
Kevin Backmann


"Kane" wrote:

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

"Kevin B" wrote:

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" wrote:

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?