• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Fill Handle in Excel

April 27, 2021 by Andrew Childress
Use fill handle Excel

The fill handle is a quick and easy way to automatically list data in Excel. Let's learn how to use the fill handle in Microsoft Excel.

The fill handle is a quick and easy way to automatically list data in Excel. It saves you time, because you can avoid entering data manually. Let’s learn how to use the fill handle in Microsoft Excel.

How to Use the Fill Handle in Excel

Imagine that you need to list out numbers in a column or row, from 1 to 50. Or, you need to list the same word many times over. In the first case, you might think that you have to type out each number. In the second, you might feel that you’ll have to copy and paste over and over.

This is where Excel’s fill handle is ready to help you. The fill handle is a smart Excel tool that analyzes a selection of data, and attempts to continue on the sequence. It’s as easy as clicking and dragging.

Let’s look at a number list. Now, Excel will need a sequence to analyze. It’s usually best to use at least three inputs to help it properly capture the desired input.

Working in column C, type 1 into cell C1. Type 2 into cell C2, and 3 into cell C3. Then, click and drag your cursor to select those three cells. Notice a small green square box in the lower right corner of the lowermost cell in your selection.

Fill handle Excel

Hover over that box, and you’ll see a + sign appear. Clicking and dragging again, pull your selection downward. You’ll see Excel previewing the input as you scroll past each cell.

When you’ve reached the desired ending cell for your sequence, simply release your mouse. Excel will auto-fill the sequence – no additional typing required!

Use fill handle Excel

For a repeating word sequence, you’d want to type in the same word three times, and then repeat the steps.

Excel fill handle

The fill handle works with other types of data as well, including dates. Give it a try next time you need to quickly input a sequence in Excel.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Delta symbols in ExcelDelta Symbol in Excel
Next Post:Track Changes in ExcelTrack changes Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top