Ask Experts Questions for FREE Help !
Ask
    DrJ's Avatar
    DrJ Posts: 1,328, Reputation: 339
    Ultra Member
     
    #1

    Aug 4, 2008, 03:31 PM
    Excel. Cant see the top of the file when open to move it lol
    OK, this is a strange problem. I am not a novice.. I know Excel quite well but I have encountered this issue.

    So when I open this file (File A) maximized, it is fine. However, for this particular part of my job, I need 2 excel files open at the same time.

    So I stretch Excel out across my dual monitors and minimize the individual files so they are 2 instances of Excel files viewable in the same Excel program.

    However, ONE of these files somehow ended up in the high left hand corner of Excel... so far up that I cannot access the top bar (of THAT file alone) in order to move it around the blank Excel screen.

    When I stretch the top of the program up, the file follows... when I stretch the left side of the program left, the file follows. I cannot see a way to access the top bar so I can position it where I want?? Lol it seems so silly but I can't seem to figure it out. Here is a screen shot so you know what I mean.

    (BTW, I know that I could open up TWO instances of Excel and open one file maximized in each so they are both viewable but I don't want to do that. I want to figure out how to solve this issue)



    So you can see that the file on the left side is way to far up... no matter how I resize the over all Excel program, it is not accessible...

    Any ideas? I don't even know how it got up there. I do this same process every month with the same file
    mdosh01's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
     
    #2

    Aug 5, 2008, 05:09 AM
    Interesting. I haven't done much with dual displays so here's a stab in the dark. I'm not sure of the exact order you do things, so I would switch it up a bit. If you open both files and then stretch Excel, try stretching Excel first and then open the two files. Try opening the file on the left in the right window first full-screen and then minimize. If it's movable, then move it to the right screen.

    Sorry, that's about all I can think of.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #3

    Aug 5, 2008, 05:13 AM
    Try rightclicking on the window and see if there is a Move choice. Then use the cursor keys to move it dow n to where you can see the titlebar.
    DrJ's Avatar
    DrJ Posts: 1,328, Reputation: 339
    Ultra Member
     
    #4

    Aug 5, 2008, 09:26 AM
    Yeah, I have tried opening it in various orders & positions. Regardless, every time this file opens (whether I open it full screen or not) it is still always positioned in the far upper corner like that.

    I've also attempted the Move option. I can select it from the task bar but when I do, my cursor jumps to the top of the screen with an outline of the little rectangle (similar to the size of the taskbar item). However, no matter where I place this and hit Enter, nothing seems to happen.

    If I try to access the Move option anywhere else in Excel, I am not given the option... unless it is referring to the entire instance of Excel... in which case, it moves the whole program and the file itself says in the relevant position.

    Im pulling my hair out... I encounter bigger problems than this on a daily basis and have never felt so stuck.. and it is SUCH a silly little problem :confused:

    I know the work around for it... but still, it's becoming a matter of principle! :cool:
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #5

    Aug 5, 2008, 10:55 AM
    Can you try the keyboard shortcut to maximize (whatever that is)?
    DrJ's Avatar
    DrJ Posts: 1,328, Reputation: 339
    Ultra Member
     
    #6

    Aug 5, 2008, 11:32 AM
    EUREKA!! Thanks ScottGem... you got me to look into keyboard shortcuts. I found these two on Microsoft:

    • ALT+SPACE: Displays the main window's System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window)
    • ALT+- (ALT+hyphen): Displays the Multiple Document Interface (MDI) child window's System menu (from the MDI child window's System menu, you can restore, move, resize, minimize, maximize, or close the child window)

    The first one give the command box for the Excel Program itself (the parent window. However, the SECOND one offers the same command window (Move, Maximize, Minimize, etc) for the Excel FILE (child window). So when I selected Move, I was able to move it with the arrows down into position!!

    *sighs* I can finally sleep at night...


    Thanks again!
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #7

    Aug 5, 2008, 12:21 PM
    Ahh the age of mousing, we forget what we can do with the keyboard ;)

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search


Check out some similar questions!

Why my hyperlinks in Excel do not open pdf & pic. Files ? [ 1 Answers ]

Dear Sirs, In MS-Excel I make some hyperlinks, for example in an Excel sheet I write "2007" and then by right click I select "hyperlink..." and make a hyperlink to open a file on my computer. When I click on my hyperlinked cell or word in mentioned Excel sheet, If hyperlinked file is PDF or...

Excel hyperlinks don't open in PDF [ 6 Answers ]

I have created some hyperlinks in an Excel preedsheet, when I convert the worksheet to a PDF, the hyperlinks are not active. What do I need to do to activate them in the PDF or what is it that I need to do in Excel before converting to a PDF? What am I doing wrong?


View more questions Search