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 :)
Thanks for the feedback!

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 main features OF Microsoft Excel?

AutoSum - helps you to add the contents of a cluster of adjacent cells. 2 List AutoFill - automatically extends cell formatting when a new item is added to the end of a list.

Features of excel?

main functions of excel is to do everything such as-i donno

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 is the difference autofit and autofill?

Autofit is usually used to adjust the size of something, like a column width in a spreadsheet, so that it can fit the values into it fully. Autofill is used to copy things, no

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.

How do you turn off autofill on your iPhone?

    Follow these steps:     1. Go into the menu "Settings"     2. Then "General"     3. From there you go into the menu "Keyboard"     4. T

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 do you mean by autofill in iTunes?

its basically when you lets say updated your music from iTunes with new songs........... but the new songs don't show up in your iPod so you press auto-fill it will delete all

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 is the significance of Autoformat feature in Excel?

It allows you to quickly format things or automatically change certain things that you do wrong, making it easier for you to work.

What are the features of Microsoft Excel?


What does autofill mean on the iPhone?

When you choose autofill for the i-Phone, it randomly chooses songs from your i-tunes to put on your i-Phone. If you go to settings, you can choose how many GBs you want of mu