Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How to add 10000 numbers in a list without dragging down How to add 10000 numbers in a list without dragging down
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2015, 03:55 AM
Pleasehelpmewithexcel Pleasehelpmewithexcel is offline How to add 10000 numbers in a list without dragging down Windows XP How to add 10000 numbers in a list without dragging down Office 2003
Novice
How to add 10000 numbers in a list without dragging down 		 
Join Date: Dec 2015
Posts: 2
Pleasehelpmewithexcel is on a distinguished road
Default How to add 10000 numbers in a list without dragging down

We often need to create a long list of serial numbers e.g. 0001 - 9000 Is there a quick way of creating the whole list of numbers without having to drag down column to create?
Reply With Quote
  #2  
Old 12-18-2015, 04:53 AM
xor xor is offline How to add 10000 numbers in a list without dragging down Windows 10 How to add 10000 numbers in a list without dragging down Office 2013
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Write 1 i A1 (for example)
Click Fill, then Series
Step value = 1, Stop value = 9000
Put a dot at Series in Columns
OK.
Reply With Quote
  #3  
Old 12-18-2015, 05:11 AM
Pleasehelpmewithexcel Pleasehelpmewithexcel is offline How to add 10000 numbers in a list without dragging down Windows XP How to add 10000 numbers in a list without dragging down Office 2003
Novice
How to add 10000 numbers in a list without dragging down 		 
Join Date: Dec 2015
Posts: 2
Pleasehelpmewithexcel is on a distinguished road
Default
Thank you very very much. This is great help!
Merry Christmas !
Reply With Quote
  #4  
Old 12-18-2015, 06:46 AM
xor xor is offline How to add 10000 numbers in a list without dragging down Windows 10 How to add 10000 numbers in a list without dragging down Office 2013
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
You're welcome.
Reply With Quote
Reply

Tags
numbering and formatting

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatic numbers, like a list, inside a paragraph olivio Word 3 06-23-2015 08:51 AM
Numbers in Numbered List Insist on Being Bold peytontodd Word 2 09-19-2014 11:01 AM
How to add 10000 numbers in a list without dragging down Creating a merged list with added numbers Dbruhns Excel 7 07-25-2014 04:48 PM
How to add 10000 numbers in a list without dragging down Dragging Pictures into Placeholders simville02 Drawing and Graphics 1 09-29-2013 06:33 PM
How to add 10000 numbers in a list without dragging down Drop down list of numbers returning colours michaelvw Excel 1 09-06-2013 09:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:33 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft