![]() But if you execute a long VBA code or recalculate complex formulas in one workbook, other workbooks within the same instance may become irresponsive. However, they all open in the same Excel instance by default. When opening multiple files in Excel 2013 and later, each workbook is displayed in a separate window. To switch between different windows displaying different spreadsheets, use the Ctrl + F6 shortcut. Switch to the new window and click the desired sheet tab.This will open another window of the same workbook. On the View tab, in the Window group, click New Window.To get multiple sheets of the same workbook to open in different windows, carry out these steps: How to open Excel sheets in separate windows ![]() To open a file in a new Excel instance, follow these instructions. ![]() So, what do I do to open files in different windows in modern Excel versions? Nothing special :) Just use the Open command in Excel or double-click a file in Windows Explorer. Meaning, in Excel 2013 and later versions, each application window can only contain one workbook that has its own ribbon UI. The reason is that Excel 2013 started to use the Single Document Interface (SDI), in which each document is opened in its own window and handled separately. Open Excel files in multiple windows in Office 2013 and laterīeginning with Office 2013, each Excel workbook is displayed in a separate window by default, even though it is the same Excel instance. 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. Instead, you can right-click the files in Windows Explorer, and choose Send to > Excel. Now, you can avoid opening additional files 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 Show hidden files, folders, or drives. Follow the steps above for creating an Excel shortcut.Ĭ:/Users/UserName/AppData/Roaming/Microsoft/Windows/SendTo.It is actually easier than it may seem, just try it: If you often have to open multiple Excel windows simultaneously, see this advanced shortcut solution. 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.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 open a new instance of the program.Īnother quick way to open Excel workbooks in different windows is this: In 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 scroll 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 the Excel icon on the taskbar and pick Microsoft Excel 2010 or Microsoft Excel 2007.To open another file in a different window, use one of the following techniques:. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |