- #HOW TO MAKE WORD PAGES SIDE BY SIDE HOW TO#
- #HOW TO MAKE WORD PAGES SIDE BY SIDE WINDOWS#
If the View Side by Side button is greyed out, that means you have just one Excel window open.
#HOW TO MAKE WORD PAGES SIDE BY SIDE WINDOWS#
If you are only interested in the tabs of the current workbook, select the Windows of active workbook check box. When done, click OK to display all open Excel windows the way you've chosen.
In the dialog box that pops up, choose the desired arrangement. On the View tab, in the Window group, click Arrange All. If the sheets are in different files, skip this step. 
Repeat this step for each worksheet that you want to view.
If the sheets are in the same workbook, click the target tab, and then click View tab > New Window. To view all sheets at a time, proceed in this way: The methods described above work for 2 sheets. To disable synchronous scrolling, just click this button to toggle it off. The option resides on the View tab, right below View Side by Side, and activates automatically with the latter. As its name suggests, it allows scrolling both sheets at the same time. One more handy feature that you may like is Synchronous Scrolling. Cascade - windows overlap one another from top to bottom.Įxcel will remember your selected arrangement and use it the next time. Horizontal - windows are placed one below another. Tiled - windows are arranged as equally sized squares in the order you opened them. Or choose another option that suits you best: In the Arrange Windows dialog box, select Vertical to place the sheets next to each other. To change the default composition, click the Arrange All button on the View tab. When using the View Side by Side feature, Excel positions two windows horizontally. #HOW TO MAKE WORD PAGES SIDE BY SIDE HOW TO#
How to arrange sheets side-by-side vertically In case you have more than two files open, the Compare Side by Side dialog box will pop up asking you to choose the workbook to be compared with the active one.
In each workbook window, click the tab you want to compare. To view two sheets in different workbooks side by side, this is what you need to do: To arrange the tabs vertically, use the Arrange All feature. The image below shows the default horizontal arrangement. In each window, click the desired sheet tab. On the View tab, in the Window group, click View Side by Side. This will open another window of the same workbook. On the View tab, in the Window group, click New Window. If the sheets you want to compare are in the same workbook, here are the steps to place them side by side: 
How to view two Excel sheets side by side
View two sheets of the same workbook side by side. Luckily, it's as easy as it appears to be :) Just choose the technique that fits your situation: When it comes to comparing worksheets in Excel, the most obvious solution is to place tabs next to each other. In this article, you will learn how to open two or more windows side by side in Excel 365, 2021, 2019, 2016, 20.
0 kommentar(er)
