Skip to content

Split Your Workbook Into Two Windows

This article will show you how to split your workbook into two windows.

In other words, you will be able to have two windows open on your computer, each displaying a different view of the same workbook.

This way, you can view or edit two different places in your workbook at the same time.

How to Split Your Workbook

To split your workbook into two windows, follow these three steps.

  • Go to View New Window  (Alt → W → N)
  • Go to View Arrange All ( Alt → W → A)
  • Select how you want to arrange the window display

Step 1 – Open a Second Window

The first thing you need to do is open a second window through which you can view and edit your workbook.

To do this, go to View New Window in the Excel Ribbon. You can also use the keyboard shortcut Alt → W → N.

Steps 2 & 3 – Arrange the Windows on Your Desktop

The second step involves setting up the windows on your desktop so that you can easily view and work with both at the same time.

To arrange the windows neatly on the screen, go to View Arrange All in the Ribbon. You can also use the shortcut Alt → W → A.

The arrange windows dialog box will appear.

Select how you would like to display your windows, and then click ok!

You can now easily view and edit different locations in your workbook simultaneously! How amazing is that!?

This Post Has One Comment

  1. I just learned about the “New Window” button this past year and it’s changed my Excel life! I didn’t know there was a short cut! I’m going to be using this all the time!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top