Side By Side 1 Workbook

[Shanel Arrendell]

Thissite uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

To get your worksheets to be side-by-side, click View in the ribbon, then New Window. You will now have the workbook open in two separate windows. You can work in either or both windows and the workbook will be updated.

I have this same problem too, and already searching for a very long time for a solution!! In all forums/Uservoices/TechCommunities i read, i see that MS does not come out with a(ny) feasable solution (or comment).

The big issue is: this worked very good (and so simple) in former Windows versions (just using Shift or Ctrl-Shift + scroll with a normal mouse up or down, couldn't be more simple, that was the perfect solution).

What is also very troubling (and mind-boggling) is that for some people the Shift (or Shift-Control) works with Horizontal scrolling in Excel with a regular mouse, and for others this is not possible... completely not logical ! And another thing is: on Mac completely no issue with horizontal scrolling with Apple mouse !!!! Try to get some logic in that.... MS-logic?.... I don't get it... And especially since so many people already wrote about this on all kinds of forums & communities....

I *think* this has to do with the Freeze Pane function. I have noticed that on sheets (within the same workbook) that have only rows as 'frozen' panes, I can side scroll. on sheets where I have both rows and columns frozen, there is no side scrolling.

It's also worth noting that prior to having this side scrolling issue, I would often have visual glitches when side scrolling (say, if I had columns A-D frozen, when I scrolled back to the start, I might see columns A-D, and then it would start as A again, or when scrolling, my screen would randomly contain chunks of black).

As others have indicated, this is probably due to Freeze Column. Check to ensure you didn't get a middle column frozen when you clicked "Freeze left column". That's what happened to me. Unfreezing the column solved the issue.

I'm on Windows but perhaps this could help anyway. I've found when this occurs in my spreadsheets a column has gotten "stuck" for lack of a better word - normally column A.

I insert another column right beside Column A and Column A will suddenly hide itself. Click on the arrow at the junction of Column A and Line 1 to highlight the entire spreadsheet, right click and choose unhide and Column A will reappear. You can then delete that extraneous column and the horizontal scrollbar should work normally.

I have to do work between two spreadsheets and I need to view them side by side.I can't just open the workbooks in separate instances because I need to make use of features like paste formatting, and all of that goes away when the workbooks aren't in the same instance.

When you open multiple Microsoft Word documents, you are able to put one on your main monitor and one on your secondary monitor to compare, copy and paste from one document to another. However, if you open multiple spreadsheets from Excel, you can't do the same thing! This has annoyed me since 2007 when Microsoft introduced the functionality in Word but not in Excel.

A coworker of mine accomplished this by using a piece of software called UltraMon. Instead of dragging the Excel application window across both desktops (which I agree, is annoying), you can right click the application in your taskbar and click "Maximize to Desktop."

To display the two files side by side instead of on top of each other, you have to load the two files as two separate instances. To do this, you must open a new instance of Excel, then open/create a workbook.

Please note: checking "Ignore other applications that use Dynamic Data Exchange (DDE)" box will sometimes cause your spreadsheets save with data on them to open as blank or grey spreadsheets. You will have to uncheck "Ignore other applications that use Dynamic Data Exchange (DDE)" box to eliminate this problem. It's kind of a catch 22.

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:

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.

Excel will remember your selected arrangement and use it the next time.

Synchronous scrollingOne 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:

Repeat this step for each worksheet that you want to view. If the sheets are in different files, skip this step.On the View tab, in the Window group, click Arrange All.In the dialog box that pops up, choose the desired arrangement. When done, click OK to display all open Excel windows the way you've chosen. If you are only interested in the tabs of the current workbook, select the Windows of active workbook check box.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.

This is very frustrating. when clicking view SIDE BY SIDE, you used to be able to see them vertically. I often have numerous files open, so selecting view all isn't a viable option. Microsoft needs to fix this to allow SIDE BY SIDE without arrange all.

When I try to type numbers from one open "side by side" work book from the other, the work book I am typing the numbers FROM disappears. I need to work on both open work books at the same time. I don't just need to view them side by side, I need to work on them while both workbooks are open.

Hi, I am currently using excel 2013. The features View Side by Side, Synchronous Scrolling, and Reset Window Position are all greyed out. Any idea how to remedy this where those features can be utilized?

To make these options active, you need to open more than 1 Excel file.

If you want to view several sheets of one and the same Excel workbook, please open this workbook and click the New Window button on the View tab. Then pick the View side by side option.

This is actually an incredibly frustrating automatic feature. Excel recently made it impossible to open two excel spreadsheets in separate windows and now force you to use this view feature. not only does it add numerous extra steps to just simple view to sheets side by side but it also makes things incredibly frustrating if you are working with over 10 spreadsheets at a time.

In a workbook with several sheets, I have only the 1st column for customers the same , but the remaining are different data for same customer , so when I jump between sheets, the columns should jump to same in all sheets. the number of columns is more than 500 & so the requirement.

I have a number of files open but only want to view 2 of them side by side and I don't want to close the others as I am still working with them. If I choose arrange all, ALL the files show up side by side. Can I not just change the default orientation of "view side by side" from horizontal to vertical?

Once I have selected Arrange All to see my 2 excel files side by side, is there an easy way to reverse which one is on the left & right? Is there a quick keystroke to reverse these? Right now, I am manually reversing their position, but I have to make sure they are fit correctly to the space.

To reverse the order, switch to the other workbook (one that is on the right or at the bottom), and click the Arrange All button there. Alternatively, switch to the right-hand file, press Alt+W, hold Alt and press A, then press V, release Alt and press Enter.

Sometimes we need to flip back and forth between two worksheets in order to compare numbers, copy and paste entries, or create formulas. In these instances, it can be much easier to look at the two (or more) sheets side by side.

To accomplish this, we can use the New Window feature in Excel, as well as some desktop shortcuts to create a split screen view of the the sheets we want to look at simultaneously. It's a fairly easy habit to pick up and will save you lots of time and frustration in the long run.

To make a new window, go to the View tab on the Ribbon and press the New Window button. This will create a new window of the active workbook (the workbook you were viewing when you pressed New Window).

Once you've created a new window, you can differentiate between the new and the old by looking at the title bar at the top. The new window will have a dash and the number 2 (then 3, 4, 5 and so on as you continue to open new windows).

Keep in mind that you are NOT creating a duplicate file, just a new window to look at the same file. Any change you make to the workbook in one window will be reflected in the other. It does NOT matter which window you make changes in. All windows will be updated immediately.

3a8082e126