Ask Your Question
0

How do I resize a comment in a libre spreadsheet?

asked 2017-06-21 19:53:54 +0200

HughMungus gravatar image

I've created a comment in a Libre Office 5.3.3.2 spreadsheet, running on Windows 10. It's very narrow and tall, too tall to be read without scrolling. I'd like to make it considerably wider so that I can view it all without scrolling it. How do I do that?

I've tried everything I can think of but I have been unsuccessful in widening it. I'm guessing there's some "trick" that puts it in resizing mode where there are actual sizing arrows that will change the width but I can't figure out the trick.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-06-21 20:23:57 +0200

librebel gravatar image

updated 2017-06-21 20:31:25 +0200

Hello HughMungus, for example:

  1. right-click inside the Comment and choose the menu item "Text...",
  2. check the checkbox "Fit width to text".

or:

  1. select your cell that contains the comment,
  2. select the menu item "Sheet : Cell Comment : Show Comment",
  3. click inside the Comment and the blue resizing handles appear.
edit flag offensive delete link more

Comments

Many thanks, that solved my problem!

HughMungus gravatar imageHughMungus ( 2017-06-21 21:33:07 +0200 )edit

You're welcome @HughMungus, glad to be of help :D

librebel gravatar imagelibrebel ( 2017-06-21 21:59:18 +0200 )edit

No matter how many comments I set to "Fit width to text", every time I make a new comment it's not enabled by default. It's very inconvenient.

Mark Jeronimus gravatar imageMark Jeronimus ( 2018-11-06 14:25:22 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-06-21 19:53:54 +0200

Seen: 601 times

Last updated: Jun 21 '17