i have tired all the Pivot Options which i … Excel Ribbon: Click on View the Arrange All to see more options for arranging your workbooks: Note that you can still create new windows (or multiple windows) showing the same workbook. By Greg Harvey . Why is there no support for side by side installations of Office 2010? Similarly, the “View Side by Side” and “Synchronous Scrolling” features work just like they used to. ; On the View tab, in the Window group, click View Side by Side. View two worksheets in the same workbook side by side in Excel 2007, 2010, 2013 & 2016. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab. ; In the workbook window, click the worksheets that you want to compare. You’ll notice that there are now two taskbar buttons for Excel. Thanks The Excel 'help' clearly states that to use 'side by side' (View tab, Window section, Side by Side - 1st option middle section) you must "turn on" 1st. This works but is awkward. On the View tab, in the Window group, click View Side by Side. I hope now you have a better picture. How do I turn these on to do a side by side viewing of two pages of one worksheet? My work around is to custom install 2010 x64 with only Excel installed; then install Office 2007 with everything except Excel.

Tell us what you think In this dialog box, under Compare Side by Side with, click the workbook that contains the worksheet that you want to compare with your active worksheet, and then click OK. You can activate the Excel 2010 hot keys by pressing the Alt key before you type the mnemonic letters for a particular task.

In this dialog box, under Compare Side by Side with, click the workbook that contains the worksheet that you want to compare with your active worksheet, and then click OK. Frustrating! Open the second Excel spreadsheet. All three items in my Excel's "Window" section are grayed out. here's the dialog box: "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL,EXE The application has failed to start because its side-by-side configuration is incorrect. If you have more than two workbooks open, Excel displays the Compare Side by Side dialog box. Each instance has a own workbook loaded. here's the dialog box: "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL,EXE The application has failed to start because its side-by-side configuration is incorrect. Click the View Side by Side button in the Window group of the View tab. p.s. I have several clients who would benefit from Excel 2010 x64, but do not need the rest of the suite in 64 bit. I mean two excel instance. Part of Excel 2010 All-in-One For Dummies Cheat Sheet . If you have more than two workbooks open, Excel displays the Compare Side by Side dialog box. I would like achieve that both Instance placed side by side on my desktop. I want to see the Values/measures side by side , if the dimensions are same across the row for a selected periods. I use Excel 2010. If you have more than two … I think this question is more of a excel related one but here is what i am doing, i have a SSAS cube which i access using Excel 2010. But no matter which one you click, it pops up in the same window. The mnemonic letter for all view-related commands in Excel 2010 is W (the last letter you see in vieW).Therefore, all the hot keys for switching the Excel worksheet into a new view begin with Alt+W. On the View tab, in the Window group, click New Window.

On the View tab, in the Window group, click View Side by Side.. No workbook placement side by side in one Excel instance.