View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Performing Action on a Range of Rows

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