Excel Workbook Window Problem

Topic

New Reply

I am attaching a graphic of a problem I am having with a workbook that I have helped a gentlemen with several times over. This time I do not know what he has done, and find it laughable that I can’t figure this one out.

1. The workbook window has been made very small (It is a rather large workbook)
2. It is not password protected in any way
3. The check boxes for everything to be visible are on (formula bar, scroll bars, headings etc…)
4. Restore does nothing (and I only have access to the Excel Window itself anyway, not the control box for the workbook)
5. There are no resizing handles that appear in any portion of the workbook to stretch it back out.
6. I can’t get my hands on the title bar to drag it back out even after minimizing the ribbon etc…
7. Full screen doesn’t help, (nor any other view I’ve tried)
8. Tiling the windows doesn’t help (to try and get the title bar)
9. What detail is that I can only scroll to column D on the left side of the worksheet. Trying to unhide A-C but can’t.
I’m insane looking at this spreadsheet. Any clues or keyboard shortcuts to get my hands on the title bar OR to get the sizing arrows around the window.

Reply | Quote

Replies

I am attaching a graphic of a problem I am having with a workbook that I have helped a gentlemen with several times over. This time I do not know what he has done, and find it laughable that I can’t figure this one out.

1. The workbook window has been made very small (It is a rather large workbook)
2. It is not password protected in any way
3. The check boxes for everything to be visible are on (formula bar, scroll bars, headings etc…)
4. Restore does nothing (and I only have access to the Excel Window itself anyway, not the control box for the workbook)
5. There are no resizing handles that appear in any portion of the workbook to stretch it back out.
6. I can’t get my hands on the title bar to drag it back out even after minimizing the ribbon etc…
7. Full screen doesn’t help, (nor any other view I’ve tried)
8. Tiling the windows doesn’t help (to try and get the title bar)
9. What detail is that I can only scroll to column D on the left side of the worksheet. Trying to unhide A-C but can’t.
I’m insane looking at this spreadsheet. Any clues or keyboard shortcuts to get my hands on the title bar OR to get the sizing arrows around the window.

Did you check to see if there are macros in the workbook?

Reply | Quote

I don’t see a graphic. Could you post a copy of the workbook?

Reply | Quote

I don’t see a graphic. Could you post a copy of the workbook?

Reply | Quote

Try the following:

[*]Press Ctrl+F7 to enter Move mode.[*]Use the arrow keys on the keyboard to move the window around until you see the title bar, minimize/maximize buttons etc.[*]Press Enter to exit Move mode and leave the window in the new position.

Reply | Quote

It is over 2 mg

Reply | Quote

If you unprotect the workbook, you’ll be able to move its window, resize it etc.
To do this:

[*]Activate the Review tab of the ribbon.[*]In the Changes section, click Unprotect Workbook

That’s it!

Reply | Quote

If you unprotect the workbook, you’ll be able to move its window, resize it etc.
To do this:

[*]Activate the Review tab of the ribbon.[*]In the Changes section, click Unprotect Workbook

That’s it!

I was working with the protect sheet ensuring it wasn’t protected…didn’t notice that the workbook was protected as I expected a password box to appear and because there was no password, did not notice that it “was” in fact protected. Gosh I hate days like this.

Thank you Hans…and believe it or not…I figured that out after screwing around with it here for a little…but thank you as you found the same result nearly at the same time as I did.

Reply | Quote