Share via

Change the BORDER color that indicates the active cell in Excel 2016

Anonymous
2016-12-17T17:53:20+00:00

Most of the offered solutions for this like RowLiner are for older versions of Excel. I can't believe MS makes changing this so hard. Should be right along there with choosing your default cell font and size.

Any help with this will be greatly appreciated. Again please only solutions that work with Excel 2016. Thank you.

Microsoft 365 and Office | Excel | For home | Windows

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 No comments

7 answers

Sort by: Most helpful
  1. Anonymous
    2017-01-25T01:53:01+00:00

    Such basic functionality such as making an active cell easy to identify should not require an add-in. It seems like Windows 10 and the follow-on changes to Office and such are movements toward less flexibility and sticking users with pre-made choices whether they are good or bad with little flexibility to change them.

    10+ people found this answer helpful.
    0 comments No comments
  2. HansV 462.6K Reputation points MVP Volunteer Moderator
    2016-12-18T10:53:35+00:00

    It's true that the add-in doesn't modify the ribbon, but you can display the Setup form from the Visual Basic Editor: double-click frmSetup, then press F5.

    You can customize RowLiner in the resulting dialog:

    3 people found this answer helpful.
    0 comments No comments
  3. HansV 462.6K Reputation points MVP Volunteer Moderator
    2017-01-25T05:54:29+00:00
    2 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2017-01-25T02:30:48+00:00

    I 100% agree.

    1 person found this answer helpful.
    0 comments No comments
  5. HansV 462.6K Reputation points MVP Volunteer Moderator
    2016-12-18T00:03:49+00:00

    The situation hasn't changed. You still need the same methods as previously. The RowLiner add-in works in recent versions of Excel too.

    0 comments No comments