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?
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.
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.
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.
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 https://www.libreoffice.org/get-help/bug/
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.
@MuffinTop, I can’t find it either… Go to https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice 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)