Side by Side

[BK]

Using Windows XP and Office 2007

I have opened two separate workbooks, both of which are in the 2007 Excel
format. When I click the "view side by side" icon, I get a top and bottom
view. One workbook is the entire width of the screen and displays from the
top of the screen to about half way down. The second workbook is also the
entire width of the screen and it displays from the center of the screen to
the bottom.

I thought side by side would display next to each other rather above and
below each other. Or am I missing something important???

 

[Gord Dibben]

You can change the default behavior to vertically side by side.

From another post on this subject

My problem was that I was arranging the windows left/right BEFORE picking
View side by side. You have to arrange the windows AFTER picking View Side
By Side.

If you do that, however you arrange the two windows, it gets recorded in the
registry in:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options\PosSideBySide

The "it" that get recorded is both position and size. If you arrange the
windows side by side that's what gets recorded and that's what you get from
then on until you change the positions while in View side by side. So if
you make the windows tiny and put one in the top left corner and the other
in the lower right corner that's what you get the next time.

If you click "Reset Window Position" you get the default over/under and the
registry entry is deleted.

Gord Dibben MS Excel MVP

 

[BK]

Thanks so much. I'm off to give that a try.

You can change the default behavior to vertically side by side.

From another post on this subject



Gord Dibben MS Excel MVP