Opening different tabs of same workbook in different windows in Excel 2010

excel excel-2010
Sawan Tivakaran picture Sawan Tivakaran · Aug 3, 2012 · Viewed 29.2k times · Source

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.

Answer

devuxer picture devuxer · Aug 3, 2012

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?

Related questions

IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
Remove leading or trailing spaces in an entire column of data

How do I remove leading or trailing spaces of all cells in an entire column? The worksheet's conventional Find and Replace (aka Ctrl+H) dialog is not solving the problem.

Read More
Insert picture into Excel cell

I'm tying to generate a report with pictures, but I cannot get the pictures into a single cell. I can get the pictures to "float" around my worksheet, but I need to put them into a cell. How can I …

Read More