Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel 2010 Problem?

09 Nov 2013   #1

Windows 7 Professional X64 Service Pack 1
Excel 2010 Problem?

Maybe not excel directly, maybe windows problem. (Dual monitors, right monitor #2 on right, where I have excel open) IF I am on a cell and want to format that cell, I right click and choose format. The format window will open under the cell that I want to format. The problem, if that cell is in column A for example, the format window will open but the format window will center the screens, (1/2 on monitor #1 left, and 1/2 on monitor #2 right) Is there a way to keep the whole window on one screen, prefer the active excel screen???

My System SpecsSystem Spec

09 Nov 2013   #2

Windows 7 Home Premium 64 bit sp1

I don't know if I am on the right track here to help you, but have you tried selecting 'Extend these displays" which allows you to drag one copy of Excel to one monitor while keeping the one you are focusing on, on the other monitor.
While on the Desktop right click your mouse & select resolution, which will open a window that allows you to select various monitor options, one being "Extend these displays".
I use this option quite often when working with a few Excel worksheets at the one time, particularly if I want make sure one sheet has exactly the same format as the others, but has varying data in it.
My System SpecsSystem Spec
10 Nov 2013   #3

Windows 7 Professional X64 Service Pack 1

This is what I am talking about. The monitor #2 on the right has the excel sheet full screen, to the left of the row numbers is monitor #1, my desk top. The format cell window is in the middle of both monitors. Since I have 1/2 inch frames on the monitor's the middle is missing from view. This part does not show in the pic.

Attached Images
My System SpecsSystem Spec

11 Nov 2013   #4

Windows 7 Home Premium 64 bit sp1

If Excel is suddenly being split after cell formatting so that it now has half on one screen & half on the other, then it may be a graphics card problem.
How have you got the monitors connected. Is one connected to your graphics card via the DVI connection & the other via the VGA connection or is one connected to the HDMI connection, or does your graphics card have 2 DVI connections.
What happens if you turn the LH monitor off, does it still do it then.
Also what happens if you select "show desktop only on 2", does it do it then.
I have listed these just to go through a process of elimination to possible try & isolate the cause.
My System SpecsSystem Spec
12 Nov 2013   #5

Windows 7 Pro 64-bit

I too have this issue, would really like to know why it does this and if it can be fixed.

Not to HJ but @Ranger4 - I tried what you mentioned; turn off left. Still does it.
My System SpecsSystem Spec
12 Nov 2013   #6

Windows 7 Home Premium 64 bit sp1

I have 2 monitors which I assume is exactly what you have & I do not get that problem when running Excel, but I am using Office 2013 Pro. Perhaps that is the difference, but I can't really see that this is the case.

You could try updating your display adapter drives from the appropriate website that suit your graphics card.

Also right click on Screen Resolution from the desktop & check that the setting are correct for your monitors. I have mine set for "landscape" in the Orientation box.

Try searching help from your graphic adapter program as well.

I think this problem is somehow related to your settings as the problem just should not occur.
My System SpecsSystem Spec
12 Nov 2013   #7

Windows 7 Home Premium 64 bit sp1

Attachment 293440

I have included a screen shot of the settings I have for the dual monitors. This is from the window you get from right clicking Screen Resolution from the desktop & selecting it.
I have them set in this shot to "Extend these Displays" as you can see.
My System SpecsSystem Spec
12 Nov 2013   #8

Windows 7 Pro 64-bit

Could be the difference, I have dual monitors (Dell U2410) connected via HDMI. But the difference I see is that your right monitor is the main whereas mine is the left as my main. All drivers are updated to latest. Just weird
My System SpecsSystem Spec
12 Nov 2013   #9

Windows 7 Home Premium 64 bit sp1

Hi AirPower4ever, what happens if you select "show desktop on 1" or "show desktop on 2" select from "Multiple displays" as shown in my screen shot. Does only having Excel showing on one screen in either of these cases cause the screen to alter.

I notice that you have both monitors connected with an HDMI cable. Does your Graphics card have 2 HDMI connections or are you using one from the Graphics card & one from the motherboard. As you have probably noticed from my earlier post I have one monitor connected to VGA & the other to the DVI connection, both on the graphics card.
My System SpecsSystem Spec
13 Nov 2013   #10

Windows 7 Home Premium 64 bit sp1

After a lot of testing in various monitor configurations using Excel I have found that in fact I do have the same problem. So I apologize if I have given the impression that I did not have the problem. I just had not experienced it before.

There are 3 ways to work around this problem.
1. In "Screen resolution" select "Duplicate these displays" which will give you an identical image on each screen. You can turn off either monitor to save power if you wish.

2. "Extend these displays". Load your worksheet on the active window & then click on the Header Bar IE. the top bar of the spreadsheet & drag it across to the other monitor. This will reduce the screen size so just maximize it again. You can now work on this screen normally. This option is very useful if you want to have 2 different spreadsheets open at the one time, one spreadsheet being on each monitor.

3. "Show desktop only on 1" or "Show desktop only on 2". This will only have one monitor working, so it is virtually the same as only having one monitor. You can turn the other monitor off to save power if you wish.

I hope this helps by providing a few ways around the problem.
My System SpecsSystem Spec

 Excel 2010 Problem?

Thread Tools

Similar help and support threads for2: Excel 2010 Problem?
Thread Forum
Microsoft Office 2010 - Excel problem Microsoft Office
problem saving excel spread sheet in 2010 to 97-2003 format Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Excel 2010 Auto Refresh Problem Microsoft Office
Outlook 2010 EXCEL (64 bit) problem Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:34 AM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33