?
Solved

Docking Excel Workbooks in Windows 7

Posted on 2011-02-20
3
Medium Priority
?
613 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

765 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