Tagged in:, Comments:2 comments

Use Excel Fill Series Feature To Add Numbers

Ever get in a situation where you need to add a sequential column or row in Excel? I know I have. I'm not the sharpest knife in the drawer at times and that leads me to not plan out my data the way I should.

Thank the engineers at Microsoft for the quick fix (and a little trick with Excel)!

Let me show you how to add a column and add the numbers in sequence.

First, let's add a column. Click on the column letter you want to insert your column before, then right click and choose insert from the drop down menu.

make a new column

Second, let's name this column, "Sort". That'll do for our purposes.

Make a new column in excel

Third, let's enter "1" in the row 2 and "2" in row 3 under the "Sort" column.

Make a new column in excel and enter 1 and 2 in the rows

Fourth, select the "1" and "2" and... grab the lower right "handle" of the square around the "1" and "2" you've selected and pull it down as far as you need your sequential numbers to go!

enter 1 and 2 under sort

All done! This doesn't seem to work with letters, but will work with any numerical sequence. In other words, you can skip numbers (i.e. start at 100, lets say, and count upward to infinity.)

Excel Fill Series Feature To Add Numbers Sequentially

That's how to use the Excel fill series feature to add numbers sequentially. You can also count down using this technique too. Give it a try!



There are 2 comments (Add your comment)

+ / - all comments
  • 1 / +
    May 7, 2010 at 8:14 pm

    Art- Thanks for the heads up. In my haste I forgot to include the images for the tutorial.

  • 2 Art- / +
    May 7, 2010 at 8:11 pm

    Nice tutorial but pictures would be nice.

Leave a comment





Some things to think about...

  • Please keep comments related to topic. Please be nice. Please don't spam!
  • Basic HTML tags are allowed:
    <a href> <abbr> <acronym> <blockquote> <code> <em> <strike> <strong>
  • Add your comment and click "Preview". If you're satisfied, click "Submit"
  • Just A Note: un-related or spam comments will be deleted.
  • Thanks!


Back To Top

Download What?

Download Microsoft Excel of course! And all the stuff you need like worksheets and templates. How about discussion on formulas and cell tagging? Tutorials and lists of "how-to" for everything Excel. Oh yeah, there are Excel downloads too.