Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to use cursor to move tables around in excel?
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. |
#2
|
|||
|
|||
Turn off the Scroll Lock on your keyboard |:)
"orangeisnice" wrote: 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. |
#3
|
|||
|
|||
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 On Tue, 22 Feb 2005 15:35:05 -0800, orangeisnice wrote: 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. |
#4
|
|||
|
|||
Gord,
Not sure, but I think OP means the active cell pointer. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... 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 On Tue, 22 Feb 2005 15:35:05 -0800, orangeisnice wrote: 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. |
#5
|
|||
|
|||
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 On Tue, 22 Feb 2005 19:54:59 -0500, "Earl Kiosterud" wrote: Gord, Not sure, but I think OP means the active cell pointer. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . 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 On Tue, 22 Feb 2005 15:35:05 -0800, orangeisnice wrote: 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. |
#6
|
|||
|
|||
Gord,
So did I. If more folks would "talk the talk," they'd probably find it easier to walk the walk! :) -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... 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 On Tue, 22 Feb 2005 19:54:59 -0500, "Earl Kiosterud" wrote: Gord, Not sure, but I think OP means the active cell pointer. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Gord Dibben" <gorddibbATshawDOTca wrote in message . .. 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 On Tue, 22 Feb 2005 15:35:05 -0800, orangeisnice wrote: 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. |
#7
|
|||
|
|||
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 "orangeisnice" wrote: 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. |
#8
|
|||
|
|||
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 On Wed, 16 Mar 2005 14:21:02 -0800, "tyoungs" wrote: 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 "orangeisnice" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
most effective way to link ms word tables to excel | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |