copy to every second line

  • Thread starter Thread starter officegirl
  • Start date Start date
O

officegirl

how do I copy to every other line at once in a column( not by holding down
ctrl and clicking on every other cell)
 
how do I copy to every other line at once in a column( not by holding down
ctrl and clicking on every other cell)
Click to expand...

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.
 
daaa , ;) thanks

Cortez said:
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.
Click to expand...
 
how do i stop it from increasing the number?

Cortez said:
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.
Click to expand...
 
Two possible solutions...
1. Hold down the Ctrl key while dragging to keep from incrementing.
2. Hold down the right mouse button (instead of the left) while dragging.
When you release the button you will be shown a list of choices. Select
Copy...
 
Select the data cell and a blank cell below.

Right-click and drag then release button and "Copy Cells"


Gord Dibben MS Excel MVP
 
Back
Top