Can I disable this automatic number advance thing?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm talking about dragging a cell's contents to a cell below it by using that
little plus sign in the corner, and it automatically advances a number in the
cell (or date in this case) to the next higher one. It can be handy, but can
I turn it off? Thanks.
 
If you right-click and drag, when you release the mouse button you'll ge
a popup that allows you to choose Copy cells (or Fill Series, etc).

Depending on your version of XL, you may also get a "smart button" that
allows you to modify how the fill is done.
 
One way

Right click and copy down and when you release the mouse button select copy
cells


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: mouse cant find cell handle to drag/move 1
enable/disable auto-convert a NUMBER to DATE 4
automatic time formatting 3
Automatic Sequential numbers 7
Why doesn't this work?? 1
Excel Vba to change displayed year automatically. 14
Numbers change to a date format 3
1, 2, 3, 4, ... 1a, 1b, 1c, ... 5

Back
Top