Menu
In Excel 2010, is there a way to open different tabs of the same workbook in separate windows? It's possible to open different workbooks in separate windows by opening multiple instances of Excel but that isn't working for opening different tabs of the same workbook since an error message arises that the workbook is already locked for editing.
955
If you want to open workbooks in separate application windows, you will have to start multiple instances of Excel: Start Excel and open a workbook. Right-click the Excel icon in the Windows taskbar and select Microsoft Excel 2010 from the context menu. A new instance of Excel will start in a separate window.
If the worksheets that you want to view are in the same workbook, do the following: Click a worksheet that you want to view. On the View tab, in the Window group, click New Window. Repeat steps 1 and 2 for each sheet that you want to view.
Press CTRL+N to create a new winodw. Excel designates multiple windows of the same workbook by appending a colon and a number to the file name on the title bar. Switch to the new window, and then click a sheet that you want to view. Repeat steps 1 and 2 for each sheet that you want to view in a window.
There is a "New Window" button on the View tab of the Ribbon.
If you follow this up by clicking "Arrange All" you can view the same worksheet in two different places (side by side or stacked).
Is that what you had in mind?
72
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
