Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Paul
 
Posts: n/a
Default Can I disable this automatic number advance thing?

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.
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.


In article ,
"Paul" wrote:

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.

  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

One way

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


Regards,

Peo Sjoblom

"Paul" wrote:

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.

  #4   Report Post  
Paul
 
Posts: n/a
Default

That works. Thanks for the help.

"Paul" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04:21 AM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"