copy to every second line
 

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

copy to every second line
 

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.

copy to every second line
 

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.

copy to every second line
 

how do i stop it from increasing the number?

"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.

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.

copy to every second line
 

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...
--
HTH...

Jim Thomlinson


"officegirl" wrote:

how do i stop it from increasing the number?

"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.

copy to every second line
 

Select the data cell and a blank cell below.

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


Gord Dibben MS Excel MVP

On Thu, 6 Dec 2007 14:55:01 -0800, officegirl
wrote:

how do i stop it from increasing the number?

"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.