Performing an Action on a Range of Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnB - 23 Jul 2007 23:55 GMT

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

Reply to this Message

Gord Dibben - 24 Jul 2007 00:24 GMT

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

>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
[quoted text clipped - 4 lines]
>
>Thanks in advance...JohnB

Reply to this Message

JohnB - 24 Jul 2007 20:24 GMT

Thanks, Gord. You've saved me a bunch of time and work.

JohnB

> Copy A1.
>
[quoted text clipped - 17 lines]
>
> >Thanks in advance...JohnB

Reply to this Message

Rate this thread: