View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
officegirl officegirl is offline
external usenet poster
 
Posts: 20
Default copy to every second line

i got it

"officegirl" wrote:

daaa , ;) thanks

"Cortez" wrote:

On Dec 6, 4:33 pm, officegirl
wrote:
how do I copy to every other line at once in a column( not by holding down
ctrl and clicking on every other cell)


Select the cell(s) and the empty cells below, then drag the box down
by the bottom right corner. If you select two rows, then it will drag/
copy two at a time.