FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells. Note: This article explains how to automatically fill values into other cells.

Detailed explanation-2: -Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature. Or, say you have information in Excel that isn’t formatted the way you need it to be, such as this list of names.

Detailed explanation-3: -In Microsoft Excel, AutoFill is a feature that allows the user to extend a series of numbers, dates, or even text to the necessary range of cells. This little option gives you plenty of possibilities. Use Flash Fill in Excel, autofill dates and numbers, populate numerous cells, and get custom list values.

Detailed explanation-4: -For example, if entering shipping information for an online purchase, the user can begin entering a name and the associated information will populate the remaining fields automatically, including a street address, town, state and zip code.

Detailed explanation-5: -Step 2c: The first option is “copy cells, ” as shown in the following image. This option copies the value of the initially selected cell to the entire selected range. Step 2d: The second option is “fill series.” This option works with numerical values or a mix of numerical and textual values.