iumjilo.blogg.se - Excel split screen wordbook

#EXCEL SPLIT SCREEN WORDBOOK HOW TO#
#EXCEL SPLIT SCREEN WORDBOOK WINDOWS#

Synchronous Scrolling between the Sheets of the Same or Different Workbooks

At this point, your opened workbooks get split into two parts.

In the end, uncheck the “Windows of active workbook” option and click OK.

Now, select the split-screen view (Tiled, Horizontal, Vertical, Cascade) from the drop-down.

After that, go to the “View” tab and then click on the “Arrange All” icon under the “Window” group on the ribbon.

First, open the workbooks, you want to split and compare.

Split and View Two Sheets Side by Side of the Different Workbooks Users can split more than two workbooks at the same time just by creating more copies of the workbook from the “New Window” icon under the “Window” group on the ribbon.

To switch the sheets between these two, just click on the sheet tab, you want to display for comparison.

At this point, your current workbook gets split into two parts.

The “Windows of active workbook” option should always be tick marked while splitting the sheets of the same workbook.

Now, select the split-screen view (Tiled, Horizontal, Vertical, Cascade) from the drop-down and click OK.

After that, click on the “Arrange All” icon under the “Window” group on the ribbon.Excel auto adds the numbers like 1, 2,3, and so on at the end of the name of the copied workbooks.The number of times you click on “New Window”, you will get the copies of the currently opened workbook.First, go to the “View” tab and click on the “New Window” icon under the “Window” group on the ribbon.Split and View Two Sheets Side by Side of the Same Workbook

#EXCEL SPLIT SCREEN WORDBOOK HOW TO#

We have mentioned some quick and easy steps for you on how to split two or more worksheets of the same or different workbooks. Users can also sync scrolling between those worksheets which makes comparison very quick and easy. If there's something else you'd like us to share next time, please let us know in comments.Excel has a feature to split and compare two worksheets of the same or different workbooks and with the help of this users can compare the data of those sheets quickly without switching between them again and again. That's how the Excel Split Screen feature works. To view two tabs in the same workbook at a time, you need to open another window of the same workbook as explained in View two Excel sheets side by side. The Excel Split feature only works within a single spreadsheet. How to split screen between two worksheets Another easy way is to double click the split bar. To undo the worksheet splitting, just click the Split button again. If a wrong cell was accidentally selected, you can adjust the panes by dragging the split bar to the desired position using the mouse.

If cell A1 is selected, the worksheet will be divided into four equal parts. In the image below, cell G10 is selected, so the screen is separated into the following parts:īy default, the split always occurs above and to the left of the active cell. For this, select the cell above and to the left of which the split should appear, and then use the Split command. To view four different sections of the same worksheet simultaneously, split your screen both vertically and horizontally. And now, you can bring any part of each pane to focus by using two vertical scrollbars. The window gets divided into two panes, one above the other. As the West data begin in row 10, we have it selected: Let's say you aim to compare data for East and West regions. To separate your Excel window horizontally, select the row below the row where you want the split to occur. This will hide columns D through F from view, focusing your attention on the more important column G: Now that the first three columns are locked by the split, you can select any cell in the right-hand pane and scroll to the right. To have it done, select column D on the left of which the split should be made:Īs the result, the worksheet is divided into two vertical panes, each having its own scrollbar. In the dataset below, suppose you want to display the item details (columns A through C) and sales numbers (columns D through H) in separate panes. To separate two areas of the spreadsheet vertically, select the column to the right of the column where you wish the split to appear and click the Split button.

#EXCEL SPLIT SCREEN WORDBOOK WINDOWS#

On the View tab, in the Windows group, click the Split button.ĭepending on your selection, the worksheet window can be divided horizontally, vertically or both, so you have two or four separate sections with their own scrollbars.

Select the row/column/cell before which you want to place the split.

To split up a worksheet into two or four parts, this is what you need to do:

Splitting is a one-click operation in Excel.