Ask Your Question

Can you highlight any chosen content inside a cell in Calc? [closed]

asked 2014-08-20 09:50:37 +0200

Muffin Top gravatar image

I want to manually highlight some words inside certain cells, like I would do with a thick bright highlighter pen. All I find are narrow strokes that you can get on top, in the middle or under the word. I'm new to Calc, but should I just get new goggles?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-02 12:45:12.965372

2 Answers

Sort by » oldest newest most voted

answered 2014-08-20 11:48:48 +0200

Pedro gravatar image

No, you can't change the background of a selected part of the cell content. You can only change the background color of the whole cell.

This is not a Calc (only) limitation. To my knowledge you can't do that on any spreadsheet software. You could suggest to add that to Calc as a Feature Request at

edit flag offensive delete link more


Thank you! And you're right, now that I think about it I don't think any spreadsheet software can do that. Would be helpful sometimes. Sorry, I registered but couldn't find a way to do a simple Feature Request.

Muffin Top gravatar imageMuffin Top ( 2014-08-20 12:51:52 +0200 )edit

@Muffin Top, I can't find it either... Go to with the same login (the other link is just an attempt at a friendlier UI for the bug tracker) and set "Severity:" to "enhancement" (last item on the list)

Pedro gravatar imagePedro ( 2014-08-20 14:03:50 +0200 )edit

answered 2014-08-20 11:47:33 +0200

Lupp gravatar image

Why not select the "some words" in editing mode and use the 'Format' > 'Character...' dialogue then?

A suggestion for free: Be cautious with specific formatting. Spreadsheets are made for calculations mainly. Partial formatting of cell contents can neither be set nor evaluated by formulae.

edit flag offensive delete link more


I tried to do that but I couldn't find a highlighting option. And the reason apparently is that there is none.

I'm working with text only and organizing it manually on a spreadsheet, so no calculations would be harmed by specific formatting. Would just like to have some words in sentences really jump out.

Muffin Top gravatar imageMuffin Top ( 2014-08-20 12:55:59 +0200 )edit

Pedro apparently assumed "highlighting" was meant as "setting a backcround colour". I didn' but he was right. Sorry, the way I suggested you can only choose a text colour, an underlining, a lerger text size , a special font or a font style ...

Sorry again! I would suggest not to rise a feature / enhancement request but use for such purposes text tables inserted into a Writer document.

Lupp gravatar imageLupp ( 2014-08-20 19:54:24 +0200 )edit

Question Tools



Asked: 2014-08-20 09:50:37 +0200

Seen: 1,082 times

Last updated: Aug 20 '14