Share via

Linked Word/Excel: Want to Highlight all linked text

Anonymous
2014-03-13T19:59:55+00:00

Greetings,

I have a Word document that has about 140 sections linked to Excel.  I want to be able to highlight all 140 places quickly (they are generally a few words or numbers long).  How can I highlight all linked sections quickly and easily?

Thanks!

Microsoft 365 and Office | Word | 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

Answer accepted by question author

  1. Paul Edstein 82,861 Reputation points Volunteer Moderator
    2014-03-13T21:29:00+00:00

    Go to File|Options|Advanced>Show Document Content> Field Shading and choose the 'Always' option. That will shade all fields (not just the Excel links), thus shading any in-line links, but not links that are formatted as worksheets and have, say, 'square' text wrapping applied. Those should be fairly obvious, though.

    10+ people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-03-13T22:04:33+00:00

    No big deal.

    Thanks again!

    0 comments
  2. Paul Edstein 82,861 Reputation points Volunteer Moderator
    2014-03-13T21:52:45+00:00

    Grey is all you get - but at least it doesn't print.

    0 comments
  3. Anonymous
    2014-03-13T21:47:25+00:00

    Worked great.  Thanks!  Only question I have: how do I change the shading color?  Default is gray and I'd like to change it if possible...

    0 comments