Forgive the newbie question. I am looking to perform an action on a
range of rows (ex. - COPY the contents of cell A1 to Cells K1 through
K21,777 or DELETE Rows 2 through 10,801).

Is there an easier way to do this than dragging the cursor down the
column to the ending location?

Thanks in advance...JohnB

Y sure
1. copy A1
2. select K1
3. click in upper left corner there is a little white box with active
celladress
- is now populated with K1 - change to K1:K21777 and hit return
4. Hit Return

"JohnB" skrev:

Forgive the newbie question. I am looking to perform an action on a
range of rows (ex. - COPY the contents of cell A1 to Cells K1 through
K21,777 or DELETE Rows 2 through 10,801).

Is there an easier way to do this than dragging the cursor down the
column to the ending location?

Thanks in advance...JohnB

goto the block to the left of the formula bar.
(if you have selected Cell A1, it will say A1)
if you want to select cells A2:B57
just type in A2:B57 and hit enter

if you want to select rows 2 through 10281
type in 2:10281 and hit enter


"JohnB" wrote:

Forgive the newbie question. I am looking to perform an action on a
range of rows (ex. - COPY the contents of cell A1 to Cells K1 through
K21,777 or DELETE Rows 2 through 10,801).

Is there an easier way to do this than dragging the cursor down the
column to the ending location?

Thanks in advance...JohnB