Ask Your Question

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 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

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".


  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


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


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

Seen: 835 times

Last updated: Jun 21 '17