Compare side by side stuck

[Rh+]

I started a side by side compare in excel and the program closed abnormally
before I closed the side by side compare and now when I call up this
worksheet, there are two worksheets with the same name except one is :1 and
the other is :2 at the end of the name.

I cannot find a way to turn the side by side off and reutrn to a normal
worksheet.

Any suggestions.

 

[Pete_UK]

Select the window which has the :2 at the end of the name (by clicking
on it) then use the close icon (X) for the WINDOW - not the Excel
close icon. This will leave you with just the one window open, which
you can then maximise. Save the file to ensure that the second window
is not there when opened in the future.

Hope this helps.

Pete

 

[Gord Dibben]

Close one of the sheets using the "x" on that sheet not the workbook "x"

Or CTRL + w to close the active window.

Save the workbook.


Gord Dibben MS Excel MVP

 

[Rh+]

This worked. Thank you.
--
Rh+

Select the window which has the :2 at the end of the name (by clicking
on it) then use the close icon (X) for the WINDOW - not the Excel
close icon. This will leave you with just the one window open, which
you can then maximise. Save the file to ensure that the second window
is not there when opened in the future.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

This worked. Thank you.
--
Rh+






- Show quoted text -