Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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...

share|improve this question

3 Answers 3

up vote 2 down vote accepted

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

share|improve this answer
    
Thanks for posting the link here! –  w4ik Feb 8 '11 at 22:22

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.

share|improve this answer
    
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 '10 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 '10 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 '10 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 '10 at 13:10
    
That doesn't work. –  Nick Feb 8 '11 at 14:56

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.

share|improve this answer
    
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 '10 at 18:41
    
Do you have any documentation to support this theory? It doesn't sound very plausible to me. –  Nick Feb 8 '11 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 '11 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. –  Nick Feb 8 '11 at 22:31

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.