ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Performing Action on a Range of Rows (https://www.excelbanter.com/excel-discussion-misc-queries/150931-performing-action-range-rows.html)

JohnB[_2_]

Performing Action on a Range of Rows
 
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


JMay

Performing Action on a Range of Rows
 
You can select a range by typing directly into the Rangename box above cell A1:

To select a range just type in C1:K21 and press the enter key

to select rows 5 thru 10,000 type into (the same box) 5:10000 and press
return

HTH

Jim

"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




All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com