Embark on a journey of knowledge! Take the quiz and earn valuable credits.
Take A QuizChallenge yourself and boost your learning! Start the quiz now to earn credits.
Take A QuizUnlock your potential! Begin the quiz, answer questions, and accumulate credits along the way.
Take A QuizIn Microsoft Excel, a fill handle is a feature to extend (and fill) several numbers, dates, or even text to other cells. In the active cell of the SPREADSHEET, the fill handle is a small black box at the bottom-right corner, as shown in the image.
Example of USING the fill handleIf you enter the number "1" in cell A1 and the number "2" in cell A2, you could extend that numbering sequence down through as many cells as you want. You can do this by selecting both cells, then clicking the fill handle (the small black box) with the left mouse button. While holding the left mouse down, drag the mouse down the spreadsheet in column A. If you dragged down to cell A50 and release the mouse button, cells A1 through A50 would now be sequentially numbered 1 to 50 without having to type each number individually.
Another example of the fill handle is to enter "5" in cell A1 and "10" in cell A3. After that, drag a box AROUND cells A1 though A4 and then drag the fill handle down as far as you want. These actions make column A have 5, 10, 15, 20, 25, etc., with spaces between each cell.
The video below shows different examples of how to use Excel's AutoFill feature.
Your browser does not support the <video> tag.Turn Your Knowledge into Earnings.
Ever curious about what any word really means? Dictionary has got them all listed out for you to explore. Simply,Choose a subject/topic and get started on a self-paced learning journey in a world of word meanings and translations.
Write Your Comments or Explanations to Help Others