How to Use AutoFill in Excel 2010

In this article I am going to explain about AutoFill in Excel 2010.
  • 4707

AutoFill in Excel 2010

AutoFill is the properties in excel by which automatic fill next value in next cell. To create  auto fill we have to move cursor horizontally or vertically until release button. There are some AutoFill that already defined by excel such as month, day, number etc. we can also create our custom AutoFill.

How to create AutoFill

Step 1

Firstly we write month name, day name, number in the cell.


Step 2

Then after we move cursor horizontally or vertically.


Step 3

Finally next month name will be automatic fill.


Create custom AutoFill

To create custom AutoFill we have to fallow following steps.

Step 1

In File tab Click on option then a Excel options dialog box will be open.


Step 2

In Excel Options click on Advanced.


Step 3

In Advanced option click on Edit Custom Lists. Then a second dialog box will be open where we defined our custom AutoFill.



Step 4

After defined custom AutoFill list click on Add. Here we can Delete our old AutoFill by the Delete option. And click Ok.


Step 5

Write the first value and move cursor horizontally or vertically.


Step 6

Finally Custom AutoFill will be created.


Ask Your Question 
Got a programming related question? You may want to post your question here


More Articles

© 2020 DotNetHeaven. All rights reserved.