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

On Dec 6, 4:33 pm, officegirl <officeg...@discussions.microsoft.com>
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.

daaa , thanks

"Cortez" wrote:

> On Dec 6, 4:33 pm, officegirl <officeg...@discussions.microsoft.com>
> 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.
>

how do i stop it from increasing the number?

"Cortez" wrote:

> On Dec 6, 4:33 pm, officegirl <officeg...@discussions.microsoft.com>
> 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.
>

i got it

"officegirl" wrote:

> daaa , thanks
>
> "Cortez" wrote:
>
> > On Dec 6, 4:33 pm, officegirl <officeg...@discussions.microsoft.com>
> > 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.
> >

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 <officeg...@discussions.microsoft.com>
> > 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.
> >

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
<(E-Mail Removed)> wrote:

>how do i stop it from increasing the number?
>
>"Cortez" wrote:
>
>> On Dec 6, 4:33 pm, officegirl <officeg...@discussions.microsoft.com>
>> 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.
>>