• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Split View with Different Tab

AWM198822

New Member
I accidentally accomplished this the other day, so I know it's possible but here's my dilemma:

I'd like to be able to use the "Split" feature under the View tab in the ribbon and have two different tabs in the same workbook displayed. I'm aware that this is very easily done by arranging two instances of the same file using the "New Window" feature in combination with the "Arrange All" feature. However, the view isn't very clean and I would much prefer to use the "Split" feature.

See the uploaded example file.

Thanks for any and all help!
 

Attachments

  • Book2.xlsx
    7.8 KB · Views: 2
Good day AWM198822 and welcome to the forum
Choose Window|New Window, then Window|Arrange.
 
Thanks, bobhc. I was hoping to accomplish views of two different tabs with the "Split" feature, which cuts down on the amount of screen space that is lost to window borders.
 
1. Click the "View" tab and click "New Window" from the "Window" group.
2. Click the "View Side by Side" button from the "Window" group. The Workbook will open again on your screen. (Select "Synchronous Scrolling" if required)
3. Click "Arrange All". Select option as per need.
4. Click the tabs at the bottom of each worksheet to display the data you want to compare.

Hope this is what you want.
 
Back
Top