While there is a way for you to open two Excel workbooks at the same time, you can also open multiple spreadsheets in separate windows. Learn how!

Merge multiple CSV files into one Excel workbook To merge multiple CSV files into one Excel sheet, follow these steps: Create a new folder and paste all the CSV files into that. Open the folder.

If you launch multiple files by double-clicking their shortcut icons, or via the "Open" menu in Excel, the files will run simultaneously in one Excel window.

How to Open a Zip File in Excel 2007. A ZIP file usually contains several other files that have been compressed to a smaller size and bundled into a single package with a .zip filename extension.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.