View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Dumb question # 32,345..Moving Around On A Spreadsheet

"HpyTrvlr69" wrote:
I would like to know the easiest way to move the cursor wround
in the a spreadsheet in order to change the focus of the cursor.


In Excel 2003, I find it helpful sometimes to enter the cell name or range
in the Name Box. In my worksheets, that's the field on the left and just
above the worksheet itself.

This is especially useful when I want to propagate a formula in A1, for
example, through A2:A20000. Right-click copy A1, enter A2:A20000 into the
Name Box, then position the cursor to the first selected cell and
right-click paste. Much faster than dragging down so many cells.


----- original message -----

"HpyTrvlr69" wrote in message
...
I would like to know the easiest way to move the cursor wround in the a
spreadsheet in order to change the focus of the cursor. I am trying to
move
the sursor to a location determined by an 'if' statement and do some
formatting. Not having any "Logic Luck"