How to Attach Zip File in Excel (3 Quick Tricks)

While working on Excel sometimes we want to attach files to the worksheet. For example, we may wish to include a zip file in the worksheet. This comes in handy to use the zip file in the worksheet. In this article, we will show 3 quick tricks to attach zip file in Excel.

How to Attach Zip File in Excel: 3 Quick Tricks

Excel offers different ways to attach files in it. The procedures are similar to some extent but each method has some differences in their applications. The guidelines for every 3 tricks are discussed in the following section.

1. Attach Zip File to Excel Sheet as Icon

The zip file can be attached as an icon in the worksheet. The icon represents the content of the zip file in the worksheet. Follow the steps given below to attach the zip file to the Excel sheet as an icon.

First, select a cell in the worksheet where we want to place the zip file.

Next, from the ribbon select Insert > Text.
Afterward, choose Object from the options.

An object window will pop up, and from the window, select Create from File.
Then, browse and insert the zip file from your computer.
Further, put a mark on the Display as icon option.
Finally, press OK.

We will see the zip file attached to our worksheet.
Similarly, we have included another zip file in the worksheet.
Hurrah! We have successfully attached two zip files to our active worksheet.

Read More: How to Attach Screenshot in Excel

2. Insert Zip File to Excel Sheet as Link

Instead of attaching the zip file as an icon, we can also insert it as a link. This time, the content of the file will be included in the worksheet, and a link will be created with it to the source file which means a change in the source file will reflect the change in the file in our worksheet. The steps for the method are described below.

First, select a cell in the worksheet where you want to attach the zip file.

Then, select Insert > Text.
Next, select Object from the list.

Consequently, an Object window will appear, select Create from File.
Now, browse and insert the zip file from your PC.
Next, mark the option Link to file.
Finally, press OK.

As a result, we will see the zip file attached to our active worksheet as a link.

3. Place Zip File in One Cell of Excel Sheet

So far, we have attached a zip file to the worksheet but it was not fixed to a specific cell. The zip file was in a floating condition. In this method, we will show the way to attach a zip file in a specific cell which means the zip file will move and resize with the cell.

First, we insert the zip file to our worksheet following the procedure in Method 1.

Now, we have to resize our attached zip file or resize the cell so that the zip file fits the cell properly.
Afterward, select the attached zip file and right-click on it.
Next, choose Format Object from the menu.

Consequently, a Format Object window will appear.
Now, select Properties tab > Move and size with cells.
Finally, press OK.

The attached zip file is fixed to the cell now. If we resize the cell, the zip file will adjust its size accordingly.
We have attached two zip files similarly.

Read More: How to Attach Documents in Excel

Download Practice Workbook

You can download the workbook attached below to practice.

Attaching Zip File.xlsx

Conclusion

Attaching a zip file to a worksheet comes in handy sometimes. We can attach the zip file quite simply. In this article, we have shown 3 quick tricks to attach a zip file to a worksheet in Excel. Please let us know by commenting if you have any queries about the procedures.

<< Go Back to Attach File in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!