Results 1 to 3 of 3

Thread: Turn off auto increment in excel

  1. #1
    Join Date
    Mar 2009
    Posts
    60

    Turn off auto increment in excel

    I want turn off auto increments in excel when i copy data from one cell in to another cell (below that cell) by dragging it to the end of the line. It autoincrement the number unless i hold control key.I want turnoff this autoincrement.Any help will be extremely appreciated.

  2. #2
    Join Date
    May 2008
    Posts
    4,834

    Re: Turn off autoincrement in excel

    The $ locate reference to the column or row in excel sheet into the absolute reference and that reference never change when you copy a formula down or across.

    =CONCATENATE(J29,$H29,"mmm") If you want to copy across, but always refer to H29.
    =CONCATENATE(J29,H$29,"mmm") If you want to copy down, but always refer to H29.
    =CONCATENATE(J29,$H$29,"mmm")If you want to copy down and across, but always refer to H29.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,089

    Re: Turn off autoincrement in excel

    You can disable autoincrement in excel. Go to Edit tab under option there you can see the check box which Allow cell drag and drop. If you uncheck that box then it won't allow user to drag and drop. That means it stop auto increment.

Similar Threads

  1. Replies: 2
    Last Post: 17-02-2012, 07:05 PM
  2. How to turn off auto screen dim in HTC Vivid
    By Muktheswara in forum Portable Devices
    Replies: 3
    Last Post: 13-11-2011, 05:17 AM
  3. Use Of Auto Increment field In Access database
    By Pony in forum Software Development
    Replies: 5
    Last Post: 03-02-2011, 09:24 PM
  4. Replies: 6
    Last Post: 16-12-2009, 05:31 PM
  5. [Excel] no increment date
    By Florian in forum Windows Software
    Replies: 3
    Last Post: 15-10-2008, 05:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •