Ask Your Question
0

calc comments line [closed]

asked 2018-05-07 22:28:24 +0200

richramik@yahoo.com 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 richramik@yahoo.com
close date 2018-11-07 16:55:57.219142

1 Answer

Sort by » oldest newest most voted
0

answered 2018-05-07 22:43:31 +0200

richramik@yahoo.com gravatar image

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

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

Stats

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

Seen: 19 times

Last updated: May 07 '18