Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Tuesday, January 4, 2011 6:36 PM | 1 vote
Sometimes when I open an existing (or E-mail attached) Excel file it opens as a "window" but is outside of the area veiwed on screen. If I "Maximize" the sheet, I can then see the workbook on screen, but if I reduce to a window, it goes back off screen. I can see Data in the "Cell Location/Data Value" boxes and can change Cell Location using arrow, Home, & Page keys but cannot see the workbook. Is there a way to move the "window" size workbook to the visible screen area using the keyboard since I can't see it to mouse over and drag it to center screen. This problem seems to have started when I started using multible screens about a year ago. Some E-mails I send with attached files get returned saying there is no file. I have to open the Excel file, save in a "Maximize" view, and resend. I use "Office 2007" at work.
All replies (20)
Wednesday, January 5, 2011 8:06 PM âś…Answered | 9 votes
Hi
Did you try the Arrange All command in the View Tab?
Don't confuse it with the Tile, Cascade in Windows. You must use the one in Excel's menus/Ribbon.
G North MMI
Tuesday, January 4, 2011 7:17 PM
A tiny trick:
First maximize the file, then using the mouse, drag the corners back to create a visible, non-maximized window.
gsnu201011
Tuesday, January 4, 2011 7:41 PM
Can I grab the corner in a "Maximize" view?
Tuesday, January 4, 2011 7:54 PM | 2 votes
I think the problem is the screen size between the different users.
You should be able to rightclick on the icon on the taskbar and choose Move.
Then you can use the arrow keys on the keyboard to move the window where you can
see it (and resize it to what you want).
mickeyl1 wrote:
Sometimes when I open an existing (or E-mail attached) Excel file it opens as a "window" but is outside of the area veiwed on screen. If I "Maximize" the sheet, I can then see the workbook on screen, but if I reduce to a window, it goes back off screen. I can see Data in the "Cell Location/Data Value" boxes and can change Cell Location using arrow, Home, & Page keys but cannot see the workbook. Is there a way to move the "window" size workbook to the visible screen area using the keyboard since I can't see it to mouse over and drag it to center screen. This problem seems to have started when I started using multible screens about a year ago. Some E-mails I send with attached files get returned saying there is no file. I have to open the Excel file, save in a "Maximize" view, and resend. I use "Office 2007" at work.
--
Dave Peterson
Tuesday, January 4, 2011 8:00 PM | 1 vote
If not try to first minimze the window and then right-click the task bar and pick Cascade Windows.gsnu201011
Tuesday, January 4, 2011 8:17 PM | 6 votes
Hi
Press Alt + spacebar, then M. You can then use the up and left arrows to bring the window back on to your screen.
Once you get enough of it back you'll be able to use the window controls as normal.
If the window is too big you can also use Alt + spacebar, then S to resize the left side of the window.
Repeat until the window is restored to a suitable position.
Hope this helps
G North MMI
Tuesday, January 4, 2011 8:33 PM
Sorry. The "Move" command is "gray' and does not work. When the Workbook Icon shows up (usually lower left) in the Excel program window the "Move" command does work and I can work several open workbooks. But when the "Reduced size window opens out of site, or "Off Screen" the Excel Icon is only in the "START" Task Bar and the "Move' command is "Gray". Is the Dual Monitor or settings an issue?
Tuesday, January 4, 2011 9:02 PM
all of that Alt + spacebar, then M works to get the Icon back to a "Minimize" Icon at the Lower Left of the Excel Viewable program. I can open as "Maximize" and see data just fine. If I reduce to, or open to "Window Size" the workbook moves to outside the border of the Viewable (what I can see) screen. Therefore preventing me from working with that file in anything but "Maximize" opened workbook.
Wednesday, January 5, 2011 9:31 AM | 1 vote
Hi
It seems your not talking about the Excel window but the file window with it. If this is the case then look for the Arrange All command in the View menu. This will allow you to Tile, Cascade etc. the document windows.
G North MMI
Wednesday, January 5, 2011 2:35 PM
When the File window is in the "Restore Window" mode, it does not show (visible on screen) within the Excel Program. The Excel program can be "Maximize" on 1 screen or "Window Size" on 1 or across 2 screens. Cascade or Tile does not make the File visible when it is in the Window mode.
Thursday, January 6, 2011 2:18 PM
That did it. It brought the "Window Size" file back into view. I appreciate your time and suggestion.
Thanks G North MMI from Texas Gulf Coast
Tuesday, July 14, 2015 3:32 PM
I had a user with this same problem. I saved and closed the sheet, opened excel in Safe mode (by holding control key on launch), then opened the recent sheet. Opened fine then.
Thursday, September 15, 2016 3:35 AM
Just wanted to say you are a genius!! Use the ARROWS to move, that is the key! The mouse will not work, and I didn't think of using the arrows until I wasted a lot of time with other useless attempts including uninstalling and reinstalling (which didn't help anything). And after the problem is fixed once with the arrows, the problem is gone the next time Excel is opened.
Thanks!!!
Thursday, October 19, 2017 4:45 PM
D. Peterson, you misunderstood the question. On PC's, (not on Macs) Office 2010 Excel opens as a system window, and then opens files as sub-windows within that window. You should have caught on to this when the requester wrote "I can see Data in the 'Cell Location/Data Value' boxes ...," etc. This question has nothing to do with the windowing that is controlled by the task bar.
Thursday, October 19, 2017 11:17 PM
I don't think so.
If you look at the OP's response and compare it to what I wrote, you'll see that's what he did.
On the other hand, this post was started almost 8 years ago. I'm kind of surprised that anyone would continue the thread.
Thursday, July 19, 2018 8:03 PM
I had the same problem with an Excel sheet that was sent to me. G North MMI's solution (View/ArrangeAll/Cascade) worked for me. Many thanks for that solution from 7+ years ago.
Monday, August 6, 2018 7:53 PM
Thank you. This worked. I got the worksheet to reappear and I am able to Minimize and restore without it disappearing
Thursday, September 13, 2018 5:38 AM
There is no view/arrange all pull down in MACs.
Thursday, October 4, 2018 5:01 PM | 1 vote
This was perfect! TY!
My steps were:
[ Alt + Ctrl + Tab ] to see the open documents and programs
Select the problematic document
[ Alt + Space bar ] , then M or select "maximize"
Wednesday, June 17, 2020 6:45 AM
Thank you. This fixed our problem. Wow, we also had to save it after maximizing it then re-opening just to verify the setting set.