Solved

Docking Excel Workbooks in Windows 7

Posted on 2011-02-20
3
602 Views
Last Modified: 2012-05-11
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
Comment
Question by:zzzy
3 Comments
 
LVL 15

Accepted Solution

by:
roylong earned 167 total points
ID: 34939395
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
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst
Ingeborg Hawighorst earned 167 total points
ID: 34939424
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
 
LVL 3

Assisted Solution

by:Dave4125
Dave4125 earned 166 total points
ID: 34939551
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
A quick guide on how to use Group Policy to create a custom power plan and set it active on Windows 7.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now