how to use cursor to move tables around in excel?

[Guest]

I can't move/choose the box by using cursor (right, left, up, down). I have
to click the box to choose one with mouse. when i use the cursor, the only
thing that move was the view and not the box.

 

[Guest]

Turn off the Scroll Lock on your keyboard |:>)

 

[Gord Dibben]

Turn off your Scroll Lock.

ScrLk button at top right of Function Keys.

BTW a "box" is commonly referred to as a "cell".


Gord Dibben Excel MVP

 

[Earl Kiosterud]

Gord,

Not sure, but I think OP means the active cell pointer.

 

[Gord Dibben]

Earl

I assumed the left, right, up and down part meant the arrows keys.

Scroll lock enabled would move the sheet view not the cell selection whereas
he says he can point to a cell and select it.


Gord

 

[Earl Kiosterud]

Gord,

So did I. If more folks would "talk the talk," they'd probably find it
easier to walk the walk!

 

[Guest]

Thank you for posting this. I have been struggling with this for days.
Thank you for the answers as well.

Why couldn't I find any reference to this in Help in the app itself?

Thanks again,
Tom

 

[Gord Dibben]

Tom

The Scroll Lock key is a global keyboard setting for all application, not just
Excel.

I guess the Excel developers never thought of adding it to the Help files.

Kinda like hitting the Caps Lock and everything is typed in UPPER CASE or
having the NumLock off and entering numbers on the NumPad moves the cursor
around or you pageup or pagedown.

Users are expected to notice things like that on their own.


Gord Dibben Excel MVP