Stuck spreadsheet

K

Kathy

I have a spreadsheet that is shared and someone has
dragged up so high you can't get a hold of it to drag it
back down to make it all visionable. Any ideas on how to
do this. Thanks
 
M

Myrna Larson

Use the keyboard commands. Click on the visible part of the worksheet. Press
ALT+- (hyphen), then M to access the Move command, then use the down arrow key
to move the workbook down.
 
M

Myrna Larson

Another approach, if you can handle VBA, is to click on the visible part of
the sheet, then go to the VB editor (ALT+F11), make sure the Immediate window
is open (press CTRL+G if not), and type

ActiveWindow.Top = 0
 
D

Doug Kanter

ALT-dash ("-") followed by X will maximize it so it completely fills the
Excel window.

or:

ALT-dash followed by M invokes the "move" feature. You'll see a 4-way arrow
on the screen, which you can move with the arrow keys on the keyboard.

When you're done moving the sheet, hit your Esc key.

The move method doesn't work if the sheet is maximized.
 
K

Kathy

Thanks everyone all of them worked for me.
-----Original Message-----
Use the keyboard commands. Click on the visible part of the worksheet. Press
ALT+- (hyphen), then M to access the Move command, then use the down arrow key
to move the workbook down.



.
Click to expand...
 
D

Doug Kanter

Check the Excel help file for more keyboard shortcuts. Print out the list,
play with them, and you'll find you can do your work 99% faster than with
the mouse. Your wrist will thank you.
 
M

Myrna Larson

Hi, Doug:

I would "move" it. Problem with just maximizing is that the next time you
"restore" it, it will be off the screen again.
 
D

Doug Kanter

I *think* that if you hit File, Save, but hold down shift when clicking
save, it'll make the position permanent. This is in the dustiest corners of
my memory, but it may be correct.
 
D

Doug Kanter

.....and....if you want to get ambitious, you could attach an auto-run macro
to the sheet which sizes and positions it just the way you want it.
Unfortunately, you can't program a macro to flog the other user with a
rusty, salty chain and leave him/her in the woods to be tortured by ants.
:)
 
M

Myrna Larson

You may be correct. I just tried maximizing, then restoring again, without
closing or saving the workbook.
 
M

Myrna Larson

Follow-up: With the worksheet's title bar off-screen, I maximized, saved in
that state and closed, then reopened and restored the sheet. It came back
off-screen.
 
D

Doug Kanter

Did you hold down Shift when you hit Save?

Myrna Larson said:
Follow-up: With the worksheet's title bar off-screen, I maximized, saved in
that state and closed, then reopened and restored the sheet. It came back
off-screen.
Click to expand...
 
Top