View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
 
Posts: 695
Default Performing Action on a Range of Rows

Y sure
1. copy A1
2. select K1
3. click in upper left corner there is a little white box with active
celladress
- is now populated with K1 - change to K1:K21777 and hit return
4. Hit Return

"JohnB" skrev:

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