You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Tips
How-to
News
Videos
Stories
Switching back and forth between worksheets can make your eyes spin around in their sockets (a great party trick but something your optometrist would advise against). Keep those baby blues steady when you use Excel 2007:
— Crabby
Comments: (13) Collapse
Crabby --
When I try to use the "view side by side" option, Excel acts as though I actually clicked a button labeled "view one above the other". I haven't been able to get the two windows to appear side-by-side, which makes comparing their contents more difficult. Any suggestions?
Emily - Thanks for your comment. Let me see... I'm assuming this is with Excel 2007, right? Try this: Click one of the worksheets on the taskbar, and then hold control and click the second one on the taskbar. This will select both the windows. Now (still holding control key), right click either one and choose “Tile Vertically”.
Will you let me know if this works for you? If not, I'll call in the big guns (people with more expertise than I).
- Crabby
I'm using Excel 2010/Win7 Home Premium and have the same prob exactly as Emily. Your work around doesn't seem to work for 2010/Win 7 poss because the taskbar works differently. I find it curious that the button "view side by side" actually produces "view one above the other" anyway, especially in the new 2010 version - is this a bug?
Again: any suggestions?
@David: It appears that "one on top of the other" is the default side and no, I don't know why. But I did find a workaround (and just tested it on Win 7/ Excel 10):
After you click "View Side by Side" in that same Window group you'll see a button called "Arrange All." Click that, and then in the dialog box that pops up, select Vertical and then OK.
That worked for me but still, it seems that either vertical should be the default or they change the name of the feature.
Thank you for the solution to my problem, Crabby!
Today I needed to view two worksheets from the same workbook side by side and it took me a while to find that the "Windows of active workbook" tickbox in the "Arrange Windows" dialog box didn't do the trick. Do you know the purpose of this tickbox? I eventually discovered that the "New Window" button in combination with your explanation did the trick!
As an amusing aside one of my Googled responses to the original question was from Dummies.com and completely ignores the commonly held view that side by side means one to the left or right of the other, as their illustration clearly shows the windows one above the other! =XD
Thanks again for saving me a lot of time copying a lot of data somewhere else while switching windows back and forth!
That is brilliant, thanks Crabby (I wonder why they put these little bugs in - i.e. pressing "view side by side" didnt work, and I didnt know you had to open a new window first (unlike Word)!
Thanks once again for the great tunes.
Crabby, Thanks, by the time I had read it all, I was finally able to get two worksheets from the same workbook open side by side. I had previously achieved a similar effect by by re-opening the workbook as Read-Only and then manually jiggling the size and postion of the two worksheets. This is much tidier. It would be great if the default action of the View Side by Side button did actually do what it said it would do, but it may happen one day.
An interesting bonus of this method over my previous attempt is that the Magnifier bar in the bottom right of the two windows operates on both worksheets, whether or not you have selected Sync Scroll.
Cheerz.
I tried this with a file that has 36 tabs, each with "Freeze Panes" set. After viewing two tabs side-by-side (Excel 2010), and finishing, all Frozen Panes were removed. Is there a way to prevent this, and retain the original Frozen Panes on every tab?
@ HDL-NYC: Can you please email me at MSFTCrabby@live.com with this issue? And can you provide any more information? The more info you have (like the actual steps in the procedure you did) the better. Even sending a file that has 36 tabs (NOT your actual file) would be great because then I can test it. Thanks--look forward to hearing from you.
I was able to change from Top/Bottom view to Side by Side as well with your tips. In earlier versions of Office (currently on 2010), I was able to open 2 or more Windows with Excel, not just within one window. This is the way Word works. I know it can be done, but I've searched all over for a fix and haven't found one. Any ideas here? I run dual monitors and would like to put an Excel window (spreadsheet) on each one for REAL side by side (not just nestled into one). THANKS
Quick update folks. I FOUND IT!! Here's the link that worked: www.lytebyte.com/.../how-to-open-two-excel-files-side-by-side-in-separate-monitors
Look in "Options/ Advanced" in the General section, put a check in the box for "Ignore other applications that use Dynamic Data Exchange (DDE)". Now when you have one Workbook open, and you open a secondary one, the second will open in it's own window. No need for the Side By Side anymore! Whew, I knew it could be done!
Boy, do I feel dumb. I got into side-by-side mode in Excel 2007 O,K. but now I can't figure out how to get out. Clicking Side-By-Side again switches the focus between workbooks and rearranges the workbook windows but they're all still displayed in the same Excel task window. I closed all the workbooks and Excel, restarted Excel and re-opened the workbooks. They're still in Side-By-Side mode. I re-booted the PC. Still in Side-By-Side mode. Please tell me the secret ritual to get out. Thanks.
Comments: (loading) Collapse