Ask Your Question

calc comments line [closed]

asked 2018-05-07 22:28:24 +0100 gravatar image

Have a workbook with several sheets and they are cross referenced with one another.

The main is sheet1 and has eight columns. I want to insert a row for comments/instructions: I need the newly inserted row merged across for the comments/instructions This could be several lines of text I entered a new row and turned on WRAP I entered several lines of text It looks great until I hit the enter key The row height does not adjust and I end up with only one line of text, instead on three lines.

What do I need to do to get the ROW HEIGHT to adjust????

Thanks, Rich Ramik

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by
close date 2018-11-07 16:55:57.219142

1 Answer

Sort by » oldest newest most voted

answered 2018-05-07 22:43:31 +0100 gravatar image

updated 2018-05-07 22:44:03 +0100

I found the answer. For the comments/instruction line, I needed to set the the row height to "optimal"

That solved the problem.

Rich Ramik

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-05-07 22:28:24 +0100

Seen: 17 times

Last updated: May 07 '18