Insert any format file in Excel such as PDF, Word, Audio, Video etc.

Insert any format file

We know the Microsoft Excel is useful to prepare reports, analyse Data and to save list of record etc. easily and more efficiently. But do you know Excel can hold attachment also. Attachments send with e-mail can be insert into excel also. 

Suppose you have one Excel and there are lots supporting documents of each entry in excel. Sometime it is difficult to find which supporting is for which entry. Obliviously we can rename the supporting documents as per entry to identify easily. But there is also one more option to insert those supporting in excel opposite of respective entries. It is Very simple and only two step process –

Let’s Start Tutorial – 

Select cell where you want show documents in Excel. Then go to “Insert” tab. In Insert tab you can find second last option Object. Click on Object menu.

 
Object window will be open with Two Option

1.    Create New
2.    Create From File

If suppose file format you require is not available on Create new list then simply click on Create from File. Click on Browse button. It will ask to select file. Then select file which want to attach.

And tick on Display as Icon button. After selecting click Ok button. Now you can see small Icon appear on your sheet. 

You can open your attached document by double clicking on this icon. If you forget to tick on Display as icon then whole document will be embedded on you sheet.
With the same process you can add any documents such as pdf, word or ever audio and video song to your excel sheet.

Hope you understand. Thank you. :)
 
Thank you !! Enjoy Excelling !! Have a Nice Day !!