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

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

News quiz: Senate health care bill in the spotlight

Reports related to the Republican bill to repeal many provisions of the PPACA, other tax issues, and the giant AICPA ENGAGE Conference offered a diverse reading list for June. See how much you know about recent news with this short quiz.