guyskillo.blogg.se - Open excel file in new window 2010 default

#Open excel file in new window 2010 default how to#
#Open excel file in new window 2010 default plus#
#Open excel file in new window 2010 default windows#

Now go to the Excel.Sheet.8 folder ( HKEY_CLASSES_ROOT/Excel.Sheet.8) and repeat the same steps as mentioned above.

Next right-click the ddeexec folder ( HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/ddeexec), select Rename, and rename it to ddeexec2:.

Now right-click the command registry entry (this is from the same HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command folder), select Rename, and rename it to command2:Įnsure you rename the command registry entry and not the command folder.

Make sure you include the quotes and make sure you have a space between the /e and the “%1”.

Add a “%1” to the end of the Value data textbox:.

From the HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command folder right-click on the (Default) registry entry and select Modify…:.

Navigate to the HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command folder:

Once you hit OK the registry editor will open.

Press Win + R on your keyboard, type regedit.exe in the Run box that pops up, and hit OK:.

To make Excel open spreadsheets in new windows, do the following: This tweak works with all Excel files, including files you open yourself and files that programs open via Excel. Take note, however, a) You need administrator access to your computer otherwise you won’t be able to modify the registry and b) You should be very careful when you have the registry editor open - accidental changes could crash your computer.

#Open excel file in new window 2010 default plus#

Office 2007, 2010, etc.), and is very easy to do plus I have provided screenshots to help you, so don’t be scared that you have to modify the registry to do this. This tweak takes less than five minutes, works on any computer (Windows XP, Vista, Win7, etc.) with Microsoft Office 2003 and higher (e.g. To force Microsoft Excel to open files in new window, you must do a registry tweak.

#Open excel file in new window 2010 default how to#

How to force Microsoft Excel to open files in new window This guide shows you how to do exactly that. Fortunately, there is a way to force Excel to open spreadsheets in new windows. Unfortunately, the default behavior of Microsoft Excel is to open spreadsheets in the same window.

#Open excel file in new window 2010 default windows#

Rather, a best practice when working with multiple Excel spreadsheets at a time is to open the spreadsheets in separate windows, allowing you to easily tile the windows next to each other using WinSplit Revolution or, if you use multiple monitors, allowing you to place each window in its own monitor.

However neither of these methods is very attractive if you use multiple monitors or if you like using window-resizer programs like WinSplit Revolution. You can, of course, use Alt + Tab to continually switch between the spreadsheets, or use Microsoft’s build-in secondary window function (you know, how you can minimize spreadsheets within the same window) to place the spreadsheets side by side. Often times you may find yourself in a position where you are using two or more Excel spreadsheets at the same time.