Autofill

The auto fill feature of excel allows you to enter a predefined series of text or numbers quickly. To create a numeric data series:

• Place the pointer in the first cell from where the data series has to begin.
• Enter the first value in the first cell for example 1.
• Enter the next value in the next adjoining cell foe example 2.
• Select both the cell
• Place the pointer at the corner on the border of selected range ( The pointer changes to a + sign)
• Drag it to cover the area where you want the cells to be filled with the series.

The cells covered are filled with a series of number;similarly a text series can also be entered for example January, February, March and so on.

Tags: ,

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS

Leave a Reply