In this article, you will learn how to open two or more windows side by side in Excel 365, 2021, 2019, 2016, 2013 and 2010. Show
When it comes to comparing worksheets in Excel, the most obvious solution is to place tabs next to each other. Luckily, it's as easy as it appears to be :) Just choose the technique that fits your situation: How to view two Excel sheets side by sideLet's begin with the most common case. If the sheets you want to compare are in the same workbook, here are the steps to place them side by side:
The image below shows the default horizontal arrangement. To arrange the tabs vertically, use the
Arrange All feature. How to open two Excel files side by sideTo view two sheets in different workbooks side by side, this is what you need to do:
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. How to arrange sheets side-by-side verticallyWhen using the View Side by Side feature, Excel positions two windows horizontally. To change the default composition, click the Arrange All button on the View
tab. In the Arrange Windows dialog box, select Vertical to place the sheets next to each other. Or choose another option that suits you best:
Excel will remember your selected arrangement and use it the next time. One more handy feature that you may like is
Synchronous Scrolling. As its name suggests, it allows scrolling both sheets at the same time. The option resides on the View tab, right below View Side by Side, and activates automatically with the latter. To disable synchronous scrolling, just click this button to toggle it off. How to view multiple sheets at onceThe methods described above work for 2 sheets. To view all sheets at a time, proceed in this way:
View side by side not workingIf the View Side by Side button is greyed out, that means you have just one Excel window open. To activate it, open another file or another window of the same workbook. If the View side by Side button is active, but nothing happens when you click on it, click the Reset Window Position button on the View tab, in the Windows group. If resetting the position does not help, try this workaround:
Useful tipsAs a final note, it's worth pointing out a couple of helpful tip-offs:
These are the fastest ways to view Excel tabs side by side. I thank you for reading and look forward to seeing you on our blog next week! You may also be interested inHow do you modify worksheet so you can see four different areas?View multiple panes, sheets, or workbooks. Select below the row where you want the split, or the column to the right of where you want the split.. On the View tab, in the Window group, click Split. To remove the split panes, click Split again.. How do you modify the chart so the owner draw data series is plotted along the secondary axis?Modify the chart so the Owner Draw data series is plotted along the.. On the Charts Tools Design tab, in the Type group, click the Change Chart Type button. IN the Change Chart Type dialog, click the Secondary Axis check box next to the Owner Draw series.
How do you switch to the view that shows all the worksheet elements as they will print?When you select one or more sheets and then click File > Print, you'll see a preview of how the data will appear on the printout. Select the worksheet(s) you want to preview. Click File, and then click Print to display the Preview window and printing options. Keyboard shortcut You can also press Ctrl+F2.
How do you modify a workbook so people Cannot change worksheet names?How to prevent from changing sheet name in Excel?. Click Review > Protect Workbook, see screenshot:. In the Protect Structure and Windows dialog box, enter the password, check the Structure under Protect workbook for, and then confirm the password again, see screenshot:. |