Solved

Docking Excel Workbooks in Windows 7

Posted on 2011-02-20
3
605 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 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