Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Turn off auto increment in excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-05-2009
Member
 
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.

Reply With Quote
  #2  
Old 16-05-2009
Member
 
Join Date: May 2008
Posts: 4,828
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.
Reply With Quote
  #3  
Old 16-05-2009
Member
 
Join Date: Apr 2008
Posts: 4,086
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Turn off auto increment in excel"
Thread Thread Starter Forum Replies Last Post
Is it possible to set auto-refesh for column which has a auto filter in Excel RopeME MS Office Support 2 17-02-2012 08:05 PM
How to turn off auto screen dim in HTC Vivid Muktheswara Portable Devices 3 13-11-2011 06:17 AM
Use Of Auto Increment field In Access database Pony Software Development 5 03-02-2011 10:24 PM
Comparing the post increment and pre increment operators in C Programming Hebrew Software Development 6 16-12-2009 06:31 PM
[Excel] no increment date Florian Windows Software 3 15-10-2008 06:28 PM


All times are GMT +5.5. The time now is 04:13 PM.