Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to stop auto-increment in Excel

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 272

PostPosted: Sun Nov 05, 2017 1:12 pm    Post subject: How to stop auto-increment in Excel Reply with quote

In Excel if you have a cell that contains a number, and you drag it down, the number increases by one in every next cell. This is normal. Here cell B3 contains me1. When you drag it down the columns, the number increases by one.





But if you have a situation where you want your number to remain same throughout the cells while you are dragging it down, how to get it?

The easiest and best way is to hold down the Ctrl key while you are dragging cell B3 (which contains me1 in the example) down your column. Nothing more Smile





Have fun Smile




*Recommended:


Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.


For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group