How do u add a running number in Excel. For instance 1000 to 2000 running in a single column of Excel instead of typing them out manually?
Thanks
2006-07-07 23:59:12 · 5 answers · asked by Niversphere 1 in Computers & Internet ➔ Software
type Two to tree numebers. For example 1001,1002 and 1003
Select all of them. Take ur mouse pointer to bottom-rightmost point of the selection and drag them down by holding left mouse button upto where u want the numbers to appear. This will solve ur problem.
2006-07-08 00:09:24 · answer #1 · answered by khem_2k786 2 · 6⤊ 3⤋
Good Exercise of mind but Answer is very simple.
Copy and Paste this Example To cell A2.
1001
=A2+1=A3+A2
=A3+1=B3+A4
Simply copy and Paste this formula in last two cells till row No. 1001 and the running sum will be displayed in in coloumn B. For more information contact me i will send u answer as the Excel WorkSheet.
2006-07-08 01:27:02 · answer #2 · answered by Piyush 2 · 0⤊ 0⤋
Using Edit->Fill->series
For instance type the number 1000 in a cell
select Edit->Fill->series
select step value = 1
stop value = 2000
type= growth
series i = columns
Click ok
Thats it
2006-07-08 00:09:31 · answer #3 · answered by Aswin Suriya 2 · 0⤊ 0⤋
enter 1 and 2 in 2 continus cell and then select those two and then drag till u want , it will automatically display the numbers
otherwise go to edit fill option and fill the numbers
2006-07-08 00:05:16 · answer #4 · answered by jyotimaned 1 · 0⤊ 0⤋
kind a million interior the 1st clean. kind 2 interior the 2d clean. spotlight the two blanks and place your cursor interior the backside actual corner of the call. you will see a + image. Drag down and the numbers will fill in. I did it merely now. It took decrease than 10 seconds. additionally you are able to kind a a million interior the 1st clean and use Edit, Fill, sequence. go with Columns and place one thousand in end fee. accomplished.
2016-12-08 17:08:13 · answer #5 · answered by ? 3 · 0⤊ 0⤋