What would you like to do?

What is the autofill feature in Excel?

already exists.

Would you like to merge this question into it?

already exists as an alternate of this question.

Would you like to make it the primary and merge this question into it?

exists and is an alternate of .

Autofill is used to copy things, normally in a constant pattern, like copying a formula or putting in the days of the week or months of the year automatically, or putting in a set of numbers with an equal gap between them. If you open an Excel spreadsheet you can try the following examples.

In cell A1 type 5. In cell A2 type 10. Now select both cells. Click on the fill handle at the bottom corner of A2, and press and hold the mouse button and drag down. IF you do it right, when you stop 15 will be in A3, 20 in A4, 25 in A5 and so on.

Now type Sunday in B1. Put the cursor on B1 and click on the fill handle at the bottom corner of B1 and start to drag down. Monday will go into B2, Tuesday in B3, Wednesday into B4 and so on. You can do the same trick with months. Even if you just type the first 3 letters of a month or a day and drag down, it will put the first 3 letters of the subsequent months and days in the other cells. These are all examples of Autofill.
It is entirely boring to tye in the same data over and over.and it certainly is not intersecting to number lines 1,2,3-----or fill in months of the year or days of the week.execel's auto fill features are just the thing to handle these repetitious action
C.It automatically populates data into cells that reference other cells :)
10 people found this useful
Thanks for the feedback!

What are the design features of an excellent logo?

  The logo has to reflect the personality of the company it represents. It will usually be the first thing anyone will come across that will be associated with the company

What is AutoFill?

AutoFill is a process used by Microsoft Word and other text editors. AutoFill tries to correct common mistakes, such as forgetting to capitalize a letter or adding end quotati

What are the features use in Microsoft Excel?

Excel is a spreadsheet application, which is classed as being for numerical analysis and manipulation. That can cover a huge range of features, too many to list in detail. In

What does autofill do in Microsoft Excel?

It enables you to automatically fill out common lists, such as days of the week. If you put the word Sunday into a cell, and then drag down from it, it will put in the rest of

What are the feature Microsoft Excel?

Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithme

What is features of MS Excel?

There are many feature like as you create own database in sheet, you excel work mathematics function, create own directory.

When do you need to create a Custom List for use with Excel's Autofill feature?

You would use them for convenience more than actually need. Built-in ones include the days of the week and the months of the year. So if you type in a day or a month and dra

What are formatting features of Excel?

There are lots of formatting features in Excel. You have thestandard ones on fonts, like size, colour, bold, italics, underlineetc. Then you have ones for values, such as form
In Uncategorized

What does autofil feature do?

It is used to copy things ,like copying a formula or putting in the days of week or months of the year automatically ,or putting in a set of numbers with an equal gap between

What does the sort feature do in Excel?

It puts data into order, such as date order, numerical order,alphabetical order and so on. You can do it for individual columns,or use one column to sort a range of others.