high

Sunday, September 30, 2007

 

Generating sequential numbers in Excel

Can't believe how I enter numbers one by one in the past.
Always google your problems before doing anything stupid.

Here is the link to the function, which is dead easy!

http://office.microsoft.com/en-us/excel/HP011542321033.aspx

Simply enter a few numbers in a row or column with the kind of pattern you need, e.g. 1, 2, 3 or 2, 4, 6

Then drag down or across to cover the range of numbers you need

go to Edit --> Fill --> Series --> (choose column/row first) Autofill

Done!

Archives

October 2004   July 2006   August 2006   May 2007   June 2007   September 2007   October 2007   November 2007   January 2008   March 2008   January 2009   February 2009   March 2009   May 2009   November 2009   April 2010   May 2010   October 2010   December 2010   September 2012   June 2013   August 2013  

This page is powered by Blogger. Isn't yours?

Subscribe to Posts [Atom]