Sunday, January 27, 2013

How to create a number series quickly/easily in Excel

Creating a series of numbers is very quick and easy in Excel without having to manually type them out one by one.

  1. Enter some data as like in the below screen shot

  2. Select B4 and B5 cells
  3. Pull down the mouse pointer from B5 cell with + sign up to B18 (right hand side corner)

No comments: