[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 618
  • Last Modified:

Docking Excel Workbooks in Windows 7

I would like to dock two workbooks in windows 7; one in the left half and other in the right half of the screen. But it seems like all workbooks get docked together to the same side of the screen. Is there anyway I can make this work?
0
zzzy
Asked:
zzzy
3 Solutions
 
roylongCommented:
Open both workbooks.
set the windows to tile.
Drag one window to the left most side of the screen by the title bar.
Drag the other to the right most side of the screen.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

Just a few words of explanation about the solution above: unlike Word, Excel does not use separate windows for separate files. If you open several workbooks, they are all in the same window, even if you see more than one Excel icon in the taskbar. Therefore, you will need to tile the Excel workbooks in the main window.

Another possibility is to use separate Excel instances. Instead of opening several workbooks in the same Excel session, start another Excel session from the Start menu. Now you have two separate Excel windows that you can arrange on your desktop.

The downside of separate Excel sessions, though, is that you will not be able to use the Paste Special dialog with the options to paste only formulas/value/formats etc between sessions. That only works for workbooks in the same session.

cheers, teylyn

0
 
Dave4125Commented:
I agree with teylyn, but with an additional comment. You can use the Side by Side feature by going to the View tab and enabling [View Side by Side].
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now