YyCxRzVMk1cTTKQCqgZtdTRUQInSdt.jpg' alt='Microsoft Excel 2010 Tutorial 7 Case Problem 1' title='Microsoft Excel 2010 Tutorial 7 Case Problem 1' />1Notes This tutorial is suitable for Excel versions 2007 and 2010. The screenshots show Excel 2010 on Windows 7. Download readymade files. View the Excel 97, 2000. Download Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats from Official Microsoft Download Center. How to Convert a List from All Caps to Regular Case in Excel 2010. This tutorial describes how you can convert a list of words from one case to another using Excel. Thanks, Jon, for taking the time to put together this very clear, useful tutorial. Unfortunately, the default behavior of Microsoft Excel is to open spreadsheets in the same window. Fortunately, there is a way to force Excel to open spreadsheets in. How to force Microsoft Excel to open files in new window How To Guide Reviews, news, tips, and tricks. Often times you may find yourself in a position where you are using two or more Excel spreadsheets at the same time. You can, of course, use Alt Tab to continually switch between the spreadsheets, or use Microsofts build in secondary window function you know, how you can minimize spreadsheets within the same window to place the spreadsheets side by side. However neither of these methods is very attractive if you use multiple monitors or if you like using window resizer programs like Win. Split Revolution. 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 Win. Split Revolution or, if you use multiple monitors, allowing you to place each window in its own monitor. Unfortunately, the default behavior of Microsoft Excel is to open spreadsheets in the same window. Router Huawei E5372 Lte Play. Fortunately, there is a way to force Excel to open spreadsheets in new windows. This guide shows you how to do exactly that. How to force Microsoft Excel to open files in new window. To force Microsoft Excel to open files in new window, you must do a registry tweak. This tweak takes less than five minutes, works on any computer Windows XP, Vista, Win. Microsoft Office 2. Office 2. 00. 7, 2. I have provided screenshots to help you, so dont be scared that you have to modify the registry to do this. Take note, however, a You need administrator access to your computer otherwise you wont 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. This tweak works with all Excel files, including files you open yourself and files that programs open via Excel. To make Excel open spreadsheets in new windows, do the following Close Excel, if it is open. Press Win R on your keyboard, type regedit. Run box that pops up, and hit OK Once you hit OK the registry editor will open. Navigate to the HKEYCLASSESROOTExcel. H7sQQQKVx7k/hqdefault.jpg' alt='Microsoft Excel 2010 Tutorial 7 Case Problem 1' title='Microsoft Excel 2010 Tutorial 7 Case Problem 1' />Sheet. Opencommand folder From the HKEYCLASSESROOTExcel. Epsxe Gameshark Emulator here. Sheet. 1. 2shellOpencommand folder right click on the Default registry entry and select Modify Add a 1 to the end of the Value data textbox Make sure you include the quotes and make sure you have a space between the e and the 1. Do not modify anything else. Click OK when you have finished. Now right click the command registry entry this is from the same HKEYCLASSESROOTExcel. Sheet. 1. 2shellOpencommand folder, select Rename, and rename it to command. Ensure you rename the commandregistry entry and not the commandfolder. Next right click the ddeexec folder HKEYCLASSESROOTExcel. Sheet. 1. 2shellOpenddeexec, select Rename, and rename it to ddeexec. Now go to the Excel. Sheet. 8 folder HKEYCLASSESROOTExcel. Sheet. 8 and repeat the same steps as mentioned above. In other words, add a 1 to the Default registry entry from HKEYCLASSESROOTExcel. Stop Full Screen. Microsoft Excel 2010 Tutorial 7 Case Problem 1' title='Microsoft Excel 2010 Tutorial 7 Case Problem 1' />Sheet. Opencommand, rename the command registry entry to command. HKEYCLASSESROOTExcel. Sheet. 8shellOpencommand, and rename the ddeexec folder HKEYCLASSESROOTExcel. Sheet. 8shellOpenddeexec to ddeexec. Close the registry editor click the X button. Done. Keep in mind, if you ever update Microsoft Office or apply a patch, you will need to repeat these steps because updates override the registry changes you just made. Conclusion. I really hope Microsoft adds an option within Excel in future versions to open files in new windows but until they do, this registry tweak allows you to easily and quickly force Excel to open all files in new windows. Enjoy. Related Posts. Overview Free Microsoft Office Tutorials Adding a Print Button Appendix added 14115 end of article This is a VBA Excel Phone list series that will develop this. Microsoft Excel 2010 Tutorial 7 Case Problem 1' title='Microsoft Excel 2010 Tutorial 7 Case Problem 1' />3 Microsoft Project 2007 Tutorial Boston University Contents Table of Contents Microsoft Project 2007.