Performing an Action on a Range of Rows

J

JohnB

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
 
G

Gord Dibben

Copy A1.

Click in NameBox to left of formula bar.

Type K1:K21777 and ENTER.

Edit>Paste.

To delete rows enter the range A2:A10801 in the NameBox then Edit>Delete>Entire
Row


Gord Dibben MS Excel MVP
 
Top