4

In Windows 7, in most applications, when an application is maximized...I can "tear" the window (grab the title bar and drag) from it's maximized size and off the top of the screen and then I can drag it to wherever...but when Excel is maximized I do not have that functionality...Is there some trick to adding this functionality for Excel 2007...I can do it with Word 2007 so it doesn't appear to be Office itself. The machine is a Dell Latitude D820 with the Nvidia Quadro NVS 110M video card...running the latest video drivers...

3 Answers 3

2

It is apparently a known issue/bug: http://social.technet.microsoft.com/Forums/en-US/w7itproui/thread/ae500d79-1b19-4f8b-9983-926ba864c5c5

0
0

Here's the only way that I know how to in Windows 7; it's not the cleanest but works for what you want.

I followed the steps as said here: http://onlineitpro.com/?p=810

The only problem is that afterwards you can't double click on a speadsheet and open it. You'll have to open an instance of Excel and then open the file from there.

Hope this helps.

5
  • Will opening the files in this manner allow me to "tear" the window away?...I'm not at the laptop rtight now...
    – w4ik
    Sep 25, 2010 at 14:45
  • I believe so. I tried it on my machine and since it's two different Excel processes you can maximize and do whatever you want to either one.
    – Hondalex
    Sep 27, 2010 at 14:09
  • Tried it on the laptop and no joy...It definitely opened Excel in two different instances...but still wouldn't let me tear either of the instances from their position when maximized. Maybe's it just a quirk with that particular machine?
    – w4ik
    Sep 28, 2010 at 12:39
  • I tried again on my machine and I wasn't able to tear the window away. You can maximize it by draging it to the top and to the side but it won't come down once it's been maximized. I guess it's an Excel thing since all other Office apps do tear like you want.
    – Hondalex
    Sep 28, 2010 at 13:10
  • That doesn't work. Feb 8, 2011 at 14:56
-1

As for "Why" - the main Excel window is actually just a container for you worksheets. Below the main minimize, maximize and close buttons is another set of the same buttons. If you click the bottommost minimize button then only the active worksheet will be minimized, but not the whole Excel window. Probably that's why it doesn't behave the way other programs do.

4
  • Understood...Excel is definitely an MDI program...en.wikipedia.org/wiki/Multiple_document_interface I just wanted to see if anyone knew of a trick to allow me to "tear" the window away...looks like it's just not possible
    – w4ik
    Oct 5, 2010 at 18:41
  • Do you have any documentation to support this theory? It doesn't sound very plausible to me. Feb 8, 2011 at 15:01
  • @Nick: what theory are you exactly commenting on? That Excel is a MDI program? See w4ik's link for documentation
    – Siim K
    Feb 8, 2011 at 22:28
  • I'm skeptical that there is any relationship between Excel being an MDI application and Excel 2007's inability to be "unmaximized" by dragging the title bar. Feb 8, 2011 at 22:31

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .