Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

The Excel Fill Handle: How to Quickly Add Data

June 29, 2016 by Tyrone Pernsley

The Excel fill handle is one of the most convenient tools available to enter data quickly and easily. Using the fill handle, you can enter repeating or sequential content across multiple cells at a time.

This quick guide will provide you with how to use the fill handle to fill in data on your spreadsheet.

First, you need to know where and how to start with the Excel fill handle. On the bottom right corner of any Excel cell, you will see a large square:

Excel Fill Handle Image 1

When you hover your cursor right over that square, the cursor changes into a bold + mark:

Excel Fill Handle Image 2

Once your cursor shows that icon, you can click and drag the cell horizontally or vertically to fill in the data. The content of the first cell will determine what will be filled in across the other cells.

Filling In Dates

You can start with a single date or month and use the Excel fill handle to fill in the remaining months:

Excel Fill Handle GIF 1

Filling in Sequences

If you use several cells in a row with related data, you can highlight all the cells and use the Fill Handle on the remaining cell to fill in the sequence:

Excel Fill Handle GIF 2

Copy and Paste:

If you have a single piece of content and need to copy across cells, then you would use the fill handle on the first cell and it will copy it across all cells:

Excel Fill Handle GIF 3

As you can see, the Excel fill handle is an ideal tool to quickly fill in data.

We here at Learn Excel Now hope you enjoyed this week’s tips on the Excel Fill Handle. Hopefully this will save you some time as you build your spreadsheets.

Like Learn Excel Now? Subscribe above to receive our weekly tips and special offers.

Getting Social with Excel – Follow us on social media and share our content with your networks!

Kevin – Learn Excel Now

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In