Dumb question # 32,345..Moving Around On A Spreadsheet

  • Thread starter Thread starter HpyTrvlr69
  • Start date Start date
H

HpyTrvlr69

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 said:
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.
Click to expand...

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 -----
 
PS....

JoeU2004 said:
Much faster than dragging down so many cells.
Click to expand...

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 -----
 
Back
Top