Highlight current cell

I am running Calc Version: (x64) on Windows 10. I need to highlight the current cell that the cursor is on.

Can someone please help me? I am able to do it with excel 2016, but that program has a problem with hyperlinks that Calc does not.

I am able to do it with excel 2016


There is a macro that does it for excel but it does not work in calc.

Please don’t “answer” with what is a comment (some discussion). E.g., I didn’t use “answer” for my question, because that wasn’t an answer to what you initially asked :slight_smile:

So, your question is about a macro then?

Well, personally I always simply do Shift+ArrowDownArrowUp… but possibly this could help:

Sub SelectCurrentCell
  Dim oDoc As Object
  oDoc = ThisComponent
End Sub

EDIT: sorry - I misread “highlight” as “select”. Well - there’s a “Background color” button on the “Formatting” toolbar - doesn’t it fit your needs?

This does not do the job. I’d like to be able to put a color in the cell I’m working in.

No, I want to just change the color of the current cell so I can see exactly which dell I am working with.

In the attached file there is a macro developed by Mauricio and Xixeme, in the Aoo Spanish forum
Highlight cell in use
(thread Resaltar fila acativa)