If you want to anchor the PDF to (and format with) a specific cell, then right-click the icon and select “Format Object” from the drop-down menu. You’ll notice that once inserted, the PDF takes on an “In front of text” layout style and hovers above the cells. And once I select the text file, the Text Import Wizard opens. By clicking on that button, we’re given the option to select a text file. Your PDF will now be inserted into Excel as an icon. You can find this command under the Data tab in the Get External Data group. Once you’ve selected the option that works best for you, click “OK.” Any changes to the source file would be reflected in your document.Īlso keep in mind that you can select both the “Link to file” and “Display as icon” options, creating a less intrusive method of accessing a live document. The difference here is that it creates a link to the source file, making it a live document. This option, as with the others, places the content of your PDF into Excel. Double-clicking the icon opens the file in your computer’s default PDF viewer.Īnother solution would be to check the “Link to file” option. This method, as the name suggests, inserts an icon that represents the contents of your file. ![]() Alternatively, you can check the box next to “Display as icon” for a less intrusive option.
0 Comments
Leave a Reply. |