Using arrow keys to move between cells

  • Thread starter Thread starter sandeep.patel79
  • Start date Start date
S

sandeep.patel79

Hey guys,

Sorry for dumb question, but how do I move between cells w/o using my
mouse and rather using arrow keys? Do you have use any of shift, alt,
ctrl keys at same time?

Thanks.
 
If pressing the arrow keys are not moving you between cells, check and see
if scroll lock is on on the key board, here is some info from help

Arrow keys
Move one cell up, down, left, or right.
CTRL+arrow key
Move to the edge of the current data region.
HOME
Move to the beginning of the row.
CTRL+HOME
Move to the beginning of the worksheet.
CTRL+END
Move to the last cell on the worksheet, in the bottom-most used row of the
rightmost used column.
PAGE DOWN
Move down one screen.
PAGE UP
Move up one screen.
ALT+PAGE DOWN
Move one screen to the right.
ALT+PAGE UP
Move one screen to the left.
F6
Switch to the next pane in a worksheet that has been split (Window menu,
Split command).
SHIFT+F6
Switch to the previous pane in a worksheet that has been split.
CTRL+BACKSPACE
Scroll to display the active cell.
F5
Display the Go To dialog box.
SHIFT+F5
Display the Find dialog box.
SHIFT+F4
Repeat the last Find action (same as Find Next).
TAB
Move between unlocked cells on a protected worksheet.


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Most people kind of learn these things by trying it. Did you get results
other than what you expected. If you got strange results you might have
your scroll lock key on.

If you want to use combinations of keys you might take a look at
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
it is the keyboard shortcuts from Help, but you can use Find because
everything is on one page.
 
Back
Top