filling a number series in excel 2001

Posted on 2003-03-03
Medium Priority
Last Modified: 2011-04-14
I want to number a column from 1 to 200, but with one space between each number (increments of 1).  How do i do this without having to type in every other cell down the column?
Question by:tgrau
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

ID: 8088871
If you start it off (by typing 1 in the first cell and 2 in the second) and select those two cells you can just click in the little black box in the bottom right-hand corner and drag it down.  Excel will autofill the series for you.

Expert Comment

ID: 8088889
Alternatively you can edit 1 in the first cell, then go to Edit\Fill\Series and select Column, and a Stop value of 200.

Accepted Solution

becredclay earned 200 total points
ID: 8099201
To fill a series with an empty cell between each filled cell, do the following: Type "1" in cell 1, leave cell 2 blank, type a "2" in cell 3, highlight cell 1, cell 2, cell 3, and CELL 4, then grab the lower right corner of the highlight box and drag down.  You should get the desired effect.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi Folks, This article is intended to throw some light or basically give an idea towards taking the first step in the world of Systems Administration. This would in the real context of the word "Systems Administration" which would mean right from…
A lot of new and distinct gadgets are making their appearance every other day. The latest gadget that has wooed the attention of all gadget lovers and non gadget lovers alike is the Smartwatch. This tiny gadget is capable of offering live access to …
Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question