The cleanest way to link data in our spreadsheets is with a PDF button - ever heard of her? PDF buttons are visually pleasing icons you can place inside your cells that replace the functionality of a hyperlink. Check out the gif above for an example: we’ve got a profit report summary tab, and we want to link each month’s respective report in the summary table.
Rather than filling our report with unsightly links, we can insert PDF buttons. To create one, we’ll first insert an object by pressing ALT N J or by navigating to the insert tab and selecting the object command under the text group. Now, we’ll just select Adobe Acrobat document and check the “Display as Icon” box. We can now select the PDF that we’d like to link to, then click open - this creates our button! We’ll just reposition the button slightly in our worksheet so it appears as we’d like it, and that’s it!
Our PDF is one click away, and our worksheet looks much more satisfying!
