PC Review


Reply
Thread Tools Rate Thread

Dragging to copy increments by one

 
 
Hank
Guest
Posts: n/a
 
      31st May 2006
I frequently drag a cell to copy it to the cells below. If there is a
number in the cell, it is automatically incremented by one in the new
cells. How do I stop this "incrementing" behavior"?

Thanks!

Hank

 
Reply With Quote
 
 
 
 
Paul Lautman
Guest
Posts: n/a
 
      31st May 2006
Hank wrote:
> I frequently drag a cell to copy it to the cells below. If there is a
> number in the cell, it is automatically incremented by one in the new
> cells. How do I stop this "incrementing" behavior"?
>
> Thanks!
>
> Hank


Instead of dragging from the corner, mark the cells including the filled one
and use Ctrl-D


 
Reply With Quote
 
Nick Hodge
Guest
Posts: n/a
 
      31st May 2006
Hank

Try holding the Ctrl key while dragging

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"Hank" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I frequently drag a cell to copy it to the cells below. If there is a
> number in the cell, it is automatically incremented by one in the new
> cells. How do I stop this "incrementing" behavior"?
>
> Thanks!
>
> Hank
>



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      31st May 2006
I like to rightclick on the fill handle and drag.

When I let go, I'll see a bunch of options--including Copy cells.

And it's nice to see what else can be used--sometime, I may need one of those
other options.

Hank wrote:
>
> I frequently drag a cell to copy it to the cells below. If there is a
> number in the cell, it is automatically incremented by one in the new
> cells. How do I stop this "incrementing" behavior"?
>
> Thanks!
>
> Hank


--

Dave Peterson
 
Reply With Quote
 
Nick Hodge
Guest
Posts: n/a
 
      1st Jun 2006
Dave

Only from XL2002 though (Smarttags)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I like to rightclick on the fill handle and drag.
>
> When I let go, I'll see a bunch of options--including Copy cells.
>
> And it's nice to see what else can be used--sometime, I may need one of
> those
> other options.
>
> Hank wrote:
>>
>> I frequently drag a cell to copy it to the cells below. If there is a
>> number in the cell, it is automatically incremented by one in the new
>> cells. How do I stop this "incrementing" behavior"?
>>
>> Thanks!
>>
>> Hank

>
> --
>
> Dave Peterson



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      1st Jun 2006
I didn't mean smarttags.

I meant the little popup that you get when you rightclick and drag on the fill
handle.

The one that has:
Copy Cells
Fill Series
Fill Formatting only
Fill without formatting
fill days
fill weekdays
....
Series



Nick Hodge wrote:
>
> Dave
>
> Only from XL2002 though (Smarttags)
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> (E-Mail Removed)HIS
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I like to rightclick on the fill handle and drag.
> >
> > When I let go, I'll see a bunch of options--including Copy cells.
> >
> > And it's nice to see what else can be used--sometime, I may need one of
> > those
> > other options.
> >
> > Hank wrote:
> >>
> >> I frequently drag a cell to copy it to the cells below. If there is a
> >> number in the cell, it is automatically incremented by one in the new
> >> cells. How do I stop this "incrementing" behavior"?
> >>
> >> Thanks!
> >>
> >> Hank

> >
> > --
> >
> > Dave Peterson


--

Dave Peterson
 
Reply With Quote
 
Nick Hodge
Guest
Posts: n/a
 
      1st Jun 2006
gotcha...sorry...I thought I'd found 'the' person who liked smart tags

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I didn't mean smarttags.
>
> I meant the little popup that you get when you rightclick and drag on the
> fill
> handle.
>
> The one that has:
> Copy Cells
> Fill Series
> Fill Formatting only
> Fill without formatting
> fill days
> fill weekdays
> ...
> Series
>
>
>
> Nick Hodge wrote:
>>
>> Dave
>>
>> Only from XL2002 though (Smarttags)
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> www.nickhodge.co.uk
>> (E-Mail Removed)HIS
>>
>> "Dave Peterson" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >I like to rightclick on the fill handle and drag.
>> >
>> > When I let go, I'll see a bunch of options--including Copy cells.
>> >
>> > And it's nice to see what else can be used--sometime, I may need one of
>> > those
>> > other options.
>> >
>> > Hank wrote:
>> >>
>> >> I frequently drag a cell to copy it to the cells below. If there is a
>> >> number in the cell, it is automatically incremented by one in the new
>> >> cells. How do I stop this "incrementing" behavior"?
>> >>
>> >> Thanks!
>> >>
>> >> Hank
>> >
>> > --
>> >
>> > Dave Peterson

>
> --
>
> Dave Peterson



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      1st Jun 2006
I think you're gonna be like Diogenes--searching for that honest man who will
admit that he likes smarttags.

<vbg>

Nick Hodge wrote:
>
> gotcha...sorry...I thought I'd found 'the' person who liked smart tags
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> (E-Mail Removed)HIS
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I didn't mean smarttags.
> >
> > I meant the little popup that you get when you rightclick and drag on the
> > fill
> > handle.
> >
> > The one that has:
> > Copy Cells
> > Fill Series
> > Fill Formatting only
> > Fill without formatting
> > fill days
> > fill weekdays
> > ...
> > Series
> >
> >
> >
> > Nick Hodge wrote:
> >>
> >> Dave
> >>
> >> Only from XL2002 though (Smarttags)
> >>
> >> --
> >> HTH
> >> Nick Hodge
> >> Microsoft MVP - Excel
> >> Southampton, England
> >> www.nickhodge.co.uk
> >> (E-Mail Removed)HIS
> >>
> >> "Dave Peterson" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> >I like to rightclick on the fill handle and drag.
> >> >
> >> > When I let go, I'll see a bunch of options--including Copy cells.
> >> >
> >> > And it's nice to see what else can be used--sometime, I may need one of
> >> > those
> >> > other options.
> >> >
> >> > Hank wrote:
> >> >>
> >> >> I frequently drag a cell to copy it to the cells below. If there is a
> >> >> number in the cell, it is automatically incremented by one in the new
> >> >> cells. How do I stop this "incrementing" behavior"?
> >> >>
> >> >> Thanks!
> >> >>
> >> >> Hank
> >> >
> >> > --
> >> >
> >> > Dave Peterson

> >
> > --
> >
> > Dave Peterson


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy/Fill Down in increments Helen B Microsoft Excel Worksheet Functions 1 19th Aug 2009 07:53 AM
Copy/Fill increments tcidawn Microsoft Excel Worksheet Functions 8 27th Jun 2009 07:56 AM
How do I copy formulas down a sheet using increments? Linda Microsoft Excel Misc 1 6th May 2009 09:49 AM
How do I copy a formula with the cell increasing by increments dgb82 Microsoft Excel Programming 1 22nd Aug 2008 09:41 PM
Re: insert field which increments by 1 on each printout. copy 1, 2, 3 Stefan Blom Microsoft Word Document Management 0 8th Dec 2006 11:43 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:06 PM.