Performing an Action on a Range of Rows

  • Thread starter Thread starter JohnB
  • Start date Start date
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
 
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
 
Back
Top