Make Hyperlinks in Excel Cells Invisible When the Worksheet Is Printed

BY STANLEY ZAROWIN

Q: I insert hyperlinks in some cells of Excel reports that I eventually distribute to clients. However, those hyperlinks are for my information only: I don’t want them to appear in the reports. Is there some way I can hide the hyperlinks so they don’t show in the printed report?

 

A: The obvious solution is to remove the hyperlinks before you print, but I assume you have a reason for not doing that. I can think of at least two other solutions—both of which involve using formatting.

 

One is to format the hyperlinks’ color the same as the cell background color (for example, a white link in a white cell). The other way is to format the cell with three semicolons (;;;), which renders everything in the cell invisible (see screenshot below).

 

More from the JofA:

 

 Find us on Facebook      Follow us on Twitter

 

SPONSORED REPORT

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: Economy and health care changes top CPAs’ list

CPA decision-makers’ economic outlook and the House Republicans’ proposed tax changes as part of replacing the Patient Protection and Affordable Care Act received attention recently. See how much you know with this short quiz.