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"

"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"

PS....

"JoeU2004" wrote:
Much faster than dragging down so many cells.

Someone is sure to mention an alternative for that particular use of the
Name Box, namely simply double-clicking on the drag handle. That works if
B2:B20000 (in my example) is filled, or if there are pre-existing values or
formulas in A2:A20000.


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

"JoeU2004" wrote in message
...
"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"