Nov12
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.
Second, let's name this column, "Sort". That'll do for our purposes.
Third, let's enter "1" in the row 2 and "2" in row 3 under the "Sort" column.
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!
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.)
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!
How To Unprotect An Excel Workbook
Comments
There are 2 comments (Add your comment)
1 TJwww.SiteDesignUSA.com- / +
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.