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