Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

How can i get just ONE window to be viewed in Excel?

Hey guys, i have this workbook file in Excel with different tabs on the bottom. Now, everytime that i click on one of the tabs on the bottom, i get TWO windows side by side of the same thing. How can i get rid of one of them so that there's only ONE page to be viewed PER tab? Thanks!

Update:

Here's a picture of the screen to better understand my question. Thanks! http://www.flickr.com/photos/98097748@N06/

1 Answer

Relevance
  • Anonymous
    8 years ago
    Favorite Answer

    Try the following:

    Click on Normal to the left of Page Layout.

    Double-click on the vertical blue area between the 2 sheets.

    Right-click the tab, click Move or Copy..., select that Worksheet & copy it to a new Workbook. Then copy the rest of the Worksheets to the new Workbook.

    NB Make a copy of the file before you try this.

    Source(s): Microsoft Office user.
Still have questions? Get your answers by asking now.