[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Docking Excel Workbooks in Windows 7

Posted on 2011-02-20
3
Medium Priority
?
620 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 668 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 (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 668 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 664 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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

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

There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

612 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