Trying to view the files side by side eats a lot of space and it isn't always the best option. Looking at spreadsheets in two different windows makes many Excel tasks easier. One of them is selecting the 'Ignore other applications that use Dynamic Data Exchange (DDE)' option in Advanced Excel Options. There are two other solutions that work for many people.

You can right-click the file you want in a new instance, and choose to Send To -> Excel. Now you can avoid opening your second file from within Excel.

Paste the shortcut into the SendTo folder.

To make it visible, go to Folder options in Control Panel, switch to View tab and select to 'Show hidden files, folders, or drives'.

Open this folder on your computer: C:/Users/UserName/AppData/Roaming/Microsoft/Windows/SendTo.

Follow the steps above for creating Excel shortcut.It is actually easier than it may seem, just try it: If you often have to open two Excel windows simultaneously, see this advanced shortcut solution suggested on the forum. Whenever you need to open a new instance of Excel - double-click this desktop shortcut. Choose the option to Create shortcut and send it to your desktop.Find the Excel.exe application and right-click on it.If you have Excel 2007, the name of the last folder is Office 12. The default path for Excel 2010 is C:/Program Files/Microsoft Office/Office 14. Open the folder where your Office is installed.This will always open a new instance of the program. If you have Windows 7 or an earlier version, you can also go to Start menu -> All Programs -> Microsoft Office -> Excel, or simply enter Excel in the search box, and then click on the program icon.If your mouse has a wheel - click on the Excel taskbar icon with the wheel.Then open your second file from the new instance. Press and hold the Shift key on your keyboard and click the Excel icon on the taskbar.Then navigate to File -> Open and browse for your second workbook. Right-click Excel icon on the taskbar and pick 'Microsoft Excel 2010' or 'Microsoft Excel 2007'.

Then use one of the following four ways to open a new instance:.

Open your first file as you normally would.

To open Excel documents in separate windows, this is what you need to do: Here are 3 ways to open Excel files in separate windows in Office 2010 and Office 2007 that actually work: I've read all the complaints and solutions on the Office forums, and this post will try to provide the summary of the easiest ways to go, which don't require messing with the registry. But there is another, presumably non-standard, task that appears to be very popular - to open your Excel 2010 or 2007 spreadsheets in different windows. Once we covered how to view Excel workbooks side by side.

Excel add ins windows 7