We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

How do I change the size of the font in a spreadsheet comment box please?

asked 2021-02-23 15:08:01 +0200

Moggsy gravatar image

I've been using LO for some time, particularly the spreadsheet. I've recently duplicated the sheet and now ant comment that is inserted into a cell is very small and almost impossible to read. How do I change the font/comment box size please?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2021-02-23 15:33:38 +0200

Opaque gravatar image

Hello,

  • Right click cell -> Show comment
  • Click into comment (You'll see the green handles, which are used to resize a comment)
  • Select the text
  • Select the font size from the format toolbar

image description

Hope that helps

edit flag offensive delete link more

Comments

Thank you for your help. Unfortunately, I can't make your instructions work. After right clicking the cell, the green handles appear. I then try to click into the box and the pointer turns into a four pointed arrow like the points on a compass. I am unable to highlight the text as the four pointed arrow repositions the comment box.

Moggsy gravatar imageMoggsy ( 2021-03-03 19:36:12 +0200 )edit

I then try to click into the box and the pointer turns into a four pointed arrow like the points on a compass

You need to double click the text, while the pointer is "a four pointed arrow like the points on a compass" to select the text.

Opaque gravatar imageOpaque ( 2021-03-03 19:51:53 +0200 )edit
0

answered 2021-02-23 15:27:29 +0200

Przemo gravatar image

While inserting/editing comment right click on the comment text (not on comment window) and select Character... You can change the font size there.

edit flag offensive delete link more

Comments

Thank you for your help. This works but I want to set a decent text size by default as it used to be. Can you suggest how I do that please?

Moggsy gravatar imageMoggsy ( 2021-03-03 19:40:02 +0200 )edit

This works but I want to set a decent text size by default as it used to be.

If you want that, then you should have mentioned in your question: The answer would have been: You can't set a default font size for comments in Calc.

Opaque gravatar imageOpaque ( 2021-03-03 19:54:14 +0200 )edit

Thank you. The default text size in a comments box was larger before I copied and pasted the spreadsheet that's for sure. I'm not sure why it's changed.

Moggsy gravatar imageMoggsy ( 2021-03-03 20:15:33 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-02-23 15:08:01 +0200

Seen: 36 times

Last updated: Feb 23