How to Add, Attach or Insert A File in Microsoft Office Excel Worksheet

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

1. Open the Excel workbook, and switch to worksheet where user wants to insert the file.
2. Choose and highlight the cell where the icon that represents the file would like to be placed to open the inserted file.
3. In the menu bar or ribbon interface, click Insert.
4. Select Object.
5. A dialog window with two tabs, namely “Create New” and “Create From File” will be opened.
6. 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.

7. Click on Browse button and select the file to insert into the worksheet.
8. 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.

9. Optionally, click on Change Icon to change the captext text and the icon for the inserted file, if “Display as icon” is selected.

   

10. 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.

Related Articles

• Remove Excel Workbook or Worksheet Lost Password for Free
• Download Microsoft Excel 2007 Patch for Math Bug Fixes
• Insert and Fill Random Filler Text and Lorem Ipsum Into Office Word, Execel and PowerPoint 2007
• Supress, Hide or Remove #DIV/0! Error in Microsoft Office Excel
• New Microsoft Office 2007 File Formats and Extensions for Word, Excel and PowerPoint Files
• Windows Microsoft Office Mobile 6.1 Released
• Open, View, Edit, and Save Office 2007 Documents, Spreadsheets, Workbooks, and Presentations in Office 2003, XP or 2000
• Combine and Merge Multiple Documents in Microsoft Office Word 2007
• Microsoft Office Live Workspace Add-in – Office Live Update 1.4
• Convert Microsoft Works Database (.wdb) to CSV or Excel Without Works Installed

This entry was posted on Saturday, August 29th, 2009 at 2:00 am and is filed under Business. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.