FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Put the mouse pointer over the bottom right-hand corner of the cell until it’s a black plus sign. 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.

Detailed explanation-2: -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-3: -What is AutoFill? Excel has a feature that helps you automatically enter data. If you are entering a predictable series (e.g. 1, 2, 3…; days of the week; hours of the day) you can use the AutoFill command to automatically extend the sequence.

Detailed explanation-4: -Thus autocomplete is a feature in MS-Excel that automatically enters the remaining characters, if the first few characters entered the match with an existing entry in that column.

Detailed explanation-5: -AutoFill in excel can fill a range in a specific direction by using the fill handle. The range is filled with values (numerical, textual or a mix) which are either copied from the initially selected cell or based on the pattern of the selected cells.