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)
- Windows 10 20H1 Insider Preview Build 18898 Released to the Fast Ring with Task Manager Improvements
- Dashlane Premium Free 1-Year Access With No Cost
- Media Creation Tool for Windows 10 Build 18362 (19H1)
- Windows 10 Insider Preview Build 18885 (20H1) Released to Windows Insiders in Fast Ring – Here What’s New, Fixes, Changes, Improvements
- Google Chrome 74 Released – Here the Changes and Download Links