Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Using a Single Instance of Excel with Two Monitors.

Using a Single Instance of Excel with Two Monitors

by Allen Wyatt
(last updated August 15, 2018)

15

Joe has a system that uses dual monitors. He would like to have one Excel workbook appear on one of the monitors and another workbook appear on the other monitor. He can do this, but only if he opens two instances of Excel. The problem with that, however, is that he cannot easily copy and paste information from one workbook to another. What would be ideal is if Joe could open both workbooks in a single instance of Excel and still have the two workbooks appear on their own monitors.

Assuming that you've got Windows configured so that it views the two monitors as a single desktop, there is only one way to do this that we've been able to discover. Follow these general steps:

  1. Open one of the workbooks in Excel, as you normally would.
  2. Make sure that the Excel program window doesn't fill the entirety of a monitor. (Click the Restore button, in the upper-right corner of the program window, if necessary.)
  3. Make sure the program window is fully visible in your left-most monitor. (Drag the title bar of that program window into that monitor, if necessary.)
  4. Drag the right side of the program window into the right-most monitor. Your program window should now cover most of the extended desktop, across two monitors.
  5. Open the second workbook in this same instance of Excel.
  6. Display the View tab of the ribbon.
  7. Click the Arrange All tool in the Window group. You should see the Arrange Windows dialog box. (See Figure 1.)
  8. Figure 1. The Arrange Windows dialog box.

  9. Make sure the Vertical radio button is selected.
  10. Click OK.
  11. Drag the borders of the workbooks so that each appears fully in the left and right monitor windows.

If you prefer, you can record a macro as you do these steps, and then run that macro each time you want to position your workbooks. Also, there is one drawback to this approach: The ribbon extends across the top of both monitors, which can (once in a while) make getting to some of the tools on the ribbon a bit interesting.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6199) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Using a Single Instance of Excel with Two Monitors.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Inserting a File

Need to combine several files into a single document? You can do it by inserting one file into another, as outlined in ...

Discover More

Only Showing the Maximum of Multiple Iterations

When you recalculate a worksheet, you can determine the maximum of a range of values. Over time, as those values change, ...

Discover More

Copying Dates a Year Into the Future

Need to copy a range of dates and update them to a different year? Here are a number of ways to accomplish this task with ...

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

More ExcelTips (ribbon)

Fixing a Numeric Keypad Key

We all expect the keyboard keys to operate as normal, and when they don't, it can be bothersome. Geraldine had such a ...

Discover More

Dividing the Screen Unevenly between Two Workbooks

When working with multiple workbooks, you'll typically want to resize the workbook windows so you can see the data from ...

Discover More

Reference Shortcut

Need to modify how a cell reference, in a formula, is constructed? The shortcut described in this tip will help you step ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 8 - 1?

2018-08-16 10:05:06

Col Delane

Re the different experience of users:

I understand a change was made in either XL2013 or XL2016/Office 365 to how the application and workbooks were managed that enabled display of different workbooks on different monitors. In XL2010 and prior it is not possible to achieve this, so the workaround as described in this tip is as good as it gets.


2018-08-16 10:03:57

Dave Bonin

Alan and Scott,

I believe the issue is not whether you can arrange multiple open
files within a single instance of Excel, but rather how to quickly
and evenly arrange the files.

Of course you can drag and resize the file windows as you like.
It's just how much effort do you want to put into arranging the
files.

In my case, I wrote a macro to do all the arranging across two
monitors with just one short key because I frequently work with
two files and I'm constantly closing and opening the second.


2018-08-15 22:44:04

Alan Cannon

I don't understand the issue. I have Excel 2013. I can open a workbook, then click File | Open and select/open another workbook. It is still in the same instance of Excel but opens in its own window, which you can drag anywhere you want it! And if you have a single monitor you can do the same thing if you size the 2 windows so both fit on the screen. … What am I missing? I know I only have one instance of Excel open because I don't get a warning about personal.xlsb already open when I open the 2nd workbook.


2018-08-15 18:37:10

Scott

Same as Philip and Keith. Win10 and Office Home & Business 2016. Never been a problem


2018-08-15 10:18:07

Dave Bonin

I have three monitors, all the same size and all side-by-side.
My primary monitor is the center one, and I routinely use Excel
across the center and right monitors.

I got tired of fiddling around with how two or more Excel files
were displayed across the monitors, so I wrote two simple
macros and put them in my Personal.xlsb file.

The first macro displays Excel across two monitors. The files
are spread evenly across the monitors, which for two files is
ideal. Whichever file is active appears in the leftmost position.

The second displays Excel maximized on my center monitor.

I assigned the macros to shortcut keys Ctrl-M and Ctrl-Shift-M,
respectively. "M" for monitor.

You will have to tweak the parameters in the first macro to suit
your monitor resolutions and borders.

Sub FillAllMonitors()

' Purpose: Expand Excel to fill all monitors in side-by-side views.
'
' Notes: Assigned to keyboard shortcut Ctrl-m (m for monitors)
'
' Need to adjust the values for MonitorQuantity, MonitorWidth and MonitorHeight to suit your hardware.
' May also need to similarly adjust the values for MonitorEdges and MonitorGutter.
' May also need to similarly adjust the values for OriginX, OriginY and Pixels2Points.
'
' In the two-monitor view, you may not be able to adjust the overall window so that there are no
' slivers of visible underlying windows (or desktop) outboard of the left and right window edges.
' If so, then center the overall window as best as you can.

' ---------------------------------------------------------------------------------------------------------------------------
' You may need to adjust the constants BELOW to suit your hardware
' ---------------------------------------------------------------------------------------------------------------------------

Const MonitorQty As Double = 2 'How many side-by-side monitors to spread Excel over

' Pick an appropriate pair of Width and Height values and comment out the other(s)
Const MonitorWidth As Double = 1680 'Physical width of monitors in pixels, eg: 1680 wide x 1050 tall
Const MonitorHeight As Double = 1050 'Physical height of monitors in pixels, eg: 1680 wide x 1050 tall

' Const MonitorWidth As Double = 1280 'Physical width of monitors in pixels, eg: 1280 wide x 1024 tall
' Const MonitorHeight As Double = 1024 'Physical height of monitors in pixels, eg: 1280 wide x 1024 tall

Const MonitorEdges As Double = 2 'Allowance for left and right edges in pixels, eg: 2
Const MonitorGutter As Double = 29 'Allowance for bottom toolbar in pixels, eg: 29

Const OriginX As Double = 1 'Where do the monitors start on the horizontal axis in pixels, eg: 1
Const OriginY As Double = 1 'Where do the monitors start on the vertical axis in pixels, eg: 1

Const Pixels2Points As Double = 0.75 'Conversion factor between pixels and points

' ---------------------------------------------------------------------------------------------------------------------------
' You may need to adjust the constants ABOVE to suit your hardware
' ---------------------------------------------------------------------------------------------------------------------------

Dim VisibleWindowsCount As Long: VisibleWindowsCount = 0
Dim ThisWindow As Window


' This is the one WindowState we can work with
Application.WindowState = xlNormal

' Anchor the top left corner
Application.Left = Pixels2Points * OriginX
Application.Top = Pixels2Points * OriginY

' Aim for really big knowing it will stop at the physical screen edges
Application.Width = Pixels2Points * ((MonitorQty * MonitorWidth) + MonitorEdges)
Application.Height = Pixels2Points * (MonitorHeight - MonitorGutter)

' How many visible windows
For Each ThisWindow In Application.Windows
If ThisWindow.Visible = True Then VisibleWindowsCount = VisibleWindowsCount + 1
Next ThisWindow

' Arrange windows side by side
If VisibleWindowsCount > 1 Then
Application.Windows.Arrange ArrangeStyle:=xlVertical

' Maximize the active window
Else
On Error Resume Next
Application.ActiveWindow.WindowState = xlMaximized
End If

End Sub


Sub FillOneMonitor()

' Purpose: Maximize Excel to completely fill one monitor.
'
' Notes: Assigned to keyboard shortcut Ctrl-M (M for monitors)

' This is the one WindowState we can work with
Application.WindowState = xlMaximized

' Maximize the active window
On Error Resume Next
Application.ActiveWindow.WindowState = xlMaximized

End Sub


2018-08-15 04:05:46

Mike

I use DisplayFusion to control 4 monitors and extending any window across any number of monitors can instantly be accomplished with a key combo. For example I use ctrl-win-2 for two monitor spread. The free version can do this, although many more controls are available in the Pro version.


2018-08-15 03:22:17

Philip

Don’t understand this. I jus open as many workbooks as I want in the same Excel instance, and they each can work in their separate window. And I’m NOT using Excel365. Works on both Mac and Win10 ...


2018-08-15 03:12:44

Keith

I have just read your post regarding using a single instance of excel using two monitors, I am running Excel 365 and Windows 10 and can simply open two or more workbooks (in a single instance of Excel) and drag them as desired to where I want any where on the two monitors without looking at View and Arrange All. Would this be because I am using Excel 365?


2018-04-23 12:41:50

Gary

Thanks Allen. That method works okay, but I am trying to work in one worksheet, while the second worksheet is regularly updated through a visual basic routine that is continuously running. The problem is that every time the second worksheet updates, it interrupts the one I am working in. Do you know of any way to resolve this?


2016-09-26 22:11:07

Clifford

Thanks, it works!!
Your guidance is simple to follow. Thanks and God Bless.


2016-09-06 12:19:27

Nicolas

JUST AMAZING, THANK YOU. THOSE WINDOWS OFFICE SOLVING PROBLEM BASTARDS CAN´T EVEN GET A FIX ON THEIR OWN SOFTWARE. STUPIDS AF.
Thank you again. As you can see, I'm very angry, but very grateful to you. Thank you all over again


2016-08-18 14:48:15

Christine

This worked perfectly for me and saved me probably 3 hours messing around back and forth between 3 spreadsheets, Thank you so much!


2016-04-26 07:49:10

Sherri

This tip is awesome for wanting to view full size spreadsheets at the same time. Thank you.


2014-12-05 14:40:27

Santosh

I unable to work in two monitors by using separated excel sheets which i have different sources. And i unable to look two excel sheets in two monitors which i have different sources.But i doesn't want "View Two Excel Spreadsheets at Once". I am getting problem in by using number of times Alt+Tab to go another excel sheets.I can open new two separate sheets in two monitors,but while opening my sources i unable to do it.


2014-09-18 15:34:34

pam

AWESOME!!! So excited to be able to do this; I don't know why I didn't think of this before. :) Thank you, thank you!!


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.