Share via

how to highlight an active row so that I can see it clearly and not lose my place

Anonymous
2025-02-06T12:15:11+00:00

I work on a few spreadsheets at a time and find that the box highlighting the cell I'm working in isn't apparent enough. I've looked at conditional formatting and can't figure out how to do it.

All I want to do, is for Excel to highlight the cell I'm actually in so I don't lose my place when jumping from work book to work book.

Is there an easy way to do this?

I'm using Windows 11 Microsoft 365

Microsoft 365 and Office | Excel | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rich~M 20,370 Reputation points Volunteer Moderator
    2025-02-06T15:43:05+00:00

    Have you checked out the new Focus Cell feature? It highlights the row and column of whatever your current active cell is. On the View ribbon select Focus Cell in the Show section to activate it.

    40+ people found this answer helpful.
    0 comments
  2. Anonymous
    2025-02-06T15:54:32+00:00

    Hi

    Thanks for taking the time to answer.

    I should have mentioned, I'm using a live spreadsheet through Share point, so sadly I don't have this option available here. Unless you know of a way to add this option or make it available for live sheets as well?

    Thanks

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2025-02-06T12:56:38+00:00

    If dealing with multiple instances probably simplest if you simply amend cell format color

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2025-02-06T13:11:23+00:00

    Hi

    Thanks so much for your quick response. But how would I do that?

    I really just need to be able to quickly look at the page and find where I am, it's so difficult to see.

    I guess older versions of windows you could do this, but on Windows 11, the conditional formatting is different than all the tutorials I've seen on youtube.

    Thanks!

    0 comments