How to Open a Zip File in Excel 2007

Zipped files are compressed versions of files that are much smaller in size than the original file. They save storage space on the hard disk. Zipping files together into one folder is a convenient way to send multiple files to users via email or instant messages. An entire folder containing files cannot be sent unless it is zipped into one file. Users would have to attach each individual file separately. Likewise, users receiving the file would have to save each file individually. Extracting and opening a zipped file in Microsoft Excel is fairly simple.

Instructions

1. Open Microsoft Excel 2007 and click on the "Open" button in the toolbar.

2. In the Files of type drop down menu, select "All Files (*.*) so files with all extensions can be viewed. Zipped files have a .zip extension. Navigate to where the zipped file is located on your computer.

3. Right click on the zip file and select "Extract All." In the Extraction Wizard window, click on the "Next" button.

4. Click on the "Browse" button or create a new directory to store the extracted files and click on "Next." Click "Finish."

5. Go back to the Open window in Excel and look for the extracted folder. Open the folder and select the file you would like to view in Excel. Click on the "Open" button.

References

• Microsoft Office Help