Microsoft Office Excel application allows user to add and insert a file into a work sheet, so that the file can be opened and accessed together with the Excel workbook for reference or information purpose. By attaching files directly to Excel sheets, user can minimize the hassle to link interrelated files together which must be read together with the workbook or worksheet.
How to Add or Insert a File in Excel Sheet
- Open the Excel workbook, and switch to worksheet where user wants to insert the file.
- Choose and highlight the cell where the icon that represents the file would like to be placed to open the inserted file.
- In the menu bar or ribbon interface, click Insert.
- Select Object.
- A dialog window with two tabs, namely “Create New” and “Create From File” will be opened.
- For some certain files, such as Acrobat PDF, Microsoft Word, Microsoft PowerPoint, WordPad document, OpenDocument Text and OpenDocument Presentation, Excel allows direct inserting and displaying of the content of the file, or even direct creation or editing of the document. To use this feature, choose “Create New”.
For this tutorial purpose, which deals with attaching of existing files, go to Create from File tab.
- Click on Browse button and select the file to insert into the worksheet.
- Two are two options available when adding and inserting a file into Excel:
Link to File: Insert the contents of the file into the document and create a link to the original source file. Changes to the source file (as long as link is still valid or source file not moved) will be reflected in the Excel workshet.
Display as icon: Insert an icon that represents the content of the file into Excel workbook.
Tick the check boxes for the option that user prefers. When no check box is selected, file content will be displayed, and changes to source document will not be reflected in the Excel workbook.
- Optionally, click on Change Icon to change the captext text and the icon for the inserted file, if “Display as icon” is selected.
- Click OK when done, and the file will be inserted into the Excel sheet, with content displayed or as an icon.
It’s possible to move the file or icon in the worksheet. When double clicking on the file or icon, it will open the file in the default editor or program assigned to view it.
Share This Post
- Able2Extract Professional 11 Review – A Powerful PDF Tool
- How to Install Windows 10 & Windows 8.1 with Local Account (Bypass Microsoft Account Sign In)
- How to Upgrade CentOS/Red Hat/Fedora Linux Kernel (cPanel WHM)
- How to Install Popcorn Time Movies & TV Shows Streaming App on iOS (iPhone & iPad) With No Jailbreak
- Stream & Watch Free Torrent Movies & TV Series on iOS with Movie Box (No Jailbreak)
- Xiaomi AMAZFIT Cor IPS Smartband User Manual English Version
- Xiaomi Mijia Mini 4K 30fps Action Camera User Manual English Version
- Free Download 8 Awesome Software (Worth $350+) For Special Giveaway
- Windows 10 Insider Preview Build 18234 Released to Insider in Fast ring for PC – Here’s What’s New Improvements, Fixes, and Known Issues
- Windows 10 Insider Preview Build 17755 What’s New, Fixed and Known issues for PCs