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. Your PDF will now be inserted into Excel as an icon. 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. Select a cell next to the numbers you want to sum click AutoSum on the Home tab press Enter and youre done. Word 2016 Merge field codes always displayed. Excel 2016 is a powerful productivity tool with some mind-blowing features. This option, as with the others, places the content of your PDF into Excel. Click in cell B9 the cell directly below the data. 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. Click the Find & Select button on the Home tab, then click Go to Special. This method, as the name suggests, inserts an icon that represents the contents of your file. Select the range of cells in your worksheet. Alternatively, you can check the box next to “Display as icon” for a less intrusive option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |