Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Use the Excel Fill Handle Easily? (Top 3 Uses with Examples)

How to Use the Excel Fill Handle Easily? (Top 3 Uses with Examples)


Note: This tutorial on how to use the fill handle in Excel is suitable for all Excel users. 

The “fill handle” option in Excel is very useful for completing lists of data in an Excel sheet. You must have used the Excel fill handle at least once in your Excel journey.

They come in handy when you have a large Excel Sheet that needs to be filled with long lists of sequential data.

But, many useful features of the fill handle, are not popular with the average Excel user. 

Related: 

How To Find Duplicates In Excel? The Best Guide

Excel Goal Seek—the Easiest Guide (3 Examples)

Excel Quick Analysis Tool – The Best Guide (5 Examples)

In this guide, I will throw light on these features and teach you how to use the fill handle in Excel effectively. 

I’ll cover: 

Table Of Contents
  1. Fill Handle in Excel – An Overview
  2. How to Use the Excel Fill Handle ? 
  3. Fill Handle in Excel – Examples
    • Example 1 – Use Fill Handle to AutoFill Numbers in Excel
    • Example 2 – Use Fill Handle to AutoFill Dates in Excel
    • Example 3 – Use Fill Handle to AutoFill Weekdays in Excel
  4. Excel Fill Handle — AutoFill Options 
    • AutoFill Options for Sequential Numbers 
    • Auto Fill Options for Dates
    • Auto Fill Options for Week Days
  5. FAQs
    • How do I AutoFill in Excel using the keyboard?
    • How do I AutoFill in Excel without dragging the fill handle?
  6. Let’s Wrap Up


Fill Handle in Excel – An Overview

The fill handle is part of the AutoFill feature in Excel. It automatically fills rows of data, based on a pattern found in the last few cells of the data.

For example, the Excel fill handle can fill dates in chronological order, if you enter the first few dates in the column. 

Excel Fill handle
Excel Fill Handle

How to Use the Excel Fill Handle ? 

The fill handle can be used by clicking on the small “plus” button visible whenever you select a series of data. 

The “plus” icon is visible at the bottom right corner of your data selection.

Click and Drag on the “Plus” icon to use the fill handle

Click on the fill handle icon and drag it to the end of the list. You can also double click on the icon if there is an adjacent column. Excel will automatically identify the pattern in the first few cells of your data and fill in the remaining cells based on it. 

Keep in mind that the fill handle can work in all directions. That is you can drag it upwards, downwards or sideways.  

Fill Handle in Excel – Examples

The Excel fill handle feature is used predominantly for three types of data lists. Here, I’ll cover them with illustrations. 

Example 1 – Use Fill Handle to AutoFill Numbers in Excel

The fill handle can be used to fill sequential numbers that increase or decrease by 1.

Just type in the first few numbers and drag them using the fill handle to the remaining cells. 

Drag the fill handle to autofill numbers
Drag the fill handle to autofill numbers

Example 2 – Use Fill Handle to AutoFill Dates in Excel

The fill handle can be used to autofill sequential dates. Only valid date formats recognised by Excel can be used. Just enter the first few dates and drag the fill handle to the rest of the cells. 

Drag the fill handle to autofill dates
Drag the fill handle to autofill dates

Example 3 – Use Fill Handle to AutoFill Weekdays in Excel

You can use the fill handle to automatically fill weekdays in your lists. Just type in the first few weekdays and drag the fill handle to the rest of the cells. You can use both the long and short forms of the weekdays. 

Drag the fill handle to autofill weekdays
Drag the fill handle to autofill the weekdays

Excel will automatically start from Monday after Sunday. 

Also Read: 

How To Use Excel Countifs: The Best Guide

Excel SUMIF vs SUMIFS – The Complete Guide

The Best Excel Project Management Template In 2021

Excel Fill Handle — AutoFill Options 

Once you fill the lists using the fill handle, you will get an option to edit or modify them using the autofill options. This list of autofill options varies according to the type of selected data. 

Now, I’ll show you how these autofill options differ and their purpose. 

AutoFill Options for Sequential Numbers 

After you use the fill handle for sequential numbers click on the autofill options button to view them. 

AutoFill Options for Sequential Numbers
AutoFill Options for Sequential Numbers

Now let’s look at them in detail. 

Copy Cells: Use this just to copy the first few cells 

Fill Series: Use this to fill the remaining cells based on the pattern in the first few cells. 

Fill Formatting Only: Use this to copy only the formatting and not the values of the first few cells. 

Fill without format: Use this to fill the remaining cells based on the pattern in the first cells, but not apply their formatting. 

Flash Fill: Use this to determine advanced patterns & auto-fill the remaining cells.(Available only in Excel 2013 and later versions).

Auto Fill Options for Dates

After you use the fill handle for dates click on the autofill options button to view them

AutoFill options for Dates
AutoFill options for Dates

Now let’s look at them in detail. 

Fill Days: Use it to increment your data by a day. 

Fill Week Days: Use it to increment your data by a weekday, skipping the weekends. 

Fill Months: Use it to increment your data by a month, fixing the day of the month. 

Fill Years: Use it to increment your data by a year. 

Auto Fill Options for Week Days

After you use the fill handle for weekdays, click on the autofill options button to view them

AutoFill Options for WeekDays
AutoFill Options for WeekDays

Now let’s look at them in detail. 

Copy Cells: Use this just to copy the first few cells 


Fill Series: Use this to fill the remaining cells based on the pattern in the first few cells. 

Fill Formatting Only: Use this to copy only the formatting and not the values of the first few cells. 

Fill without format: Use this to fill the remaining cells based on the pattern in the first cells, but not apply their formatting. 

Fill Days: Use it to increment your data by a day. 

Fill Week Days: Use it to increment your data by a weekday, skipping the weekends. 

Flash Fill: Use this to determine advanced patterns & auto-fill the remaining cells. (Available only in Excel 2013 and later versions)

Suggested Reads: 

Create An Excel Dashboard In 5 Minutes – The Best Guide

Dynamic Dropdown Lists In Excel – Top Data Validation Guide

Predict Future Values Using Excel Forecast Sheet – The Best Guide

FAQs

How do I AutoFill in Excel using the keyboard?

The keyboard shortcut for autofill is Alt+I+E+S + Enter. This is set by default for numeric values. You can change it to dates or weekdays in the autofill options. 
Alternatively, you can use Ctrl+Down/Right Arrow keys to select the range you want to fill and Ctrl+D/Ctrl+R to fill down/right respectively. 

How do I AutoFill in Excel without dragging the fill handle?

To auto-fill cells without dragging the fill handle, you can either use the keyboard shortcuts or use the Fill option under the Home tab. 

Let’s Wrap Up

In this guide, I have covered everything about using fill handle in Excel. I showed you how to use them for numbers. dates and weekdays.  I also talked about the various other auto-fill options for each of these data types. If you have any doubts regarding the Excel fill handle or any other Excel feature, please let us know in the comments section below.  

If you need more high-quality Excel guides, please check out our free Excel resources centre.

Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Adam Lacey

Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats. When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

Introduction to Using Layers in Photoshop Elements 15 – Part 1

How to Use Cell Styles in Excel: A Step-by-Step Guide

Using Microsoft PowerPoint 2010 – Walk Before You Run

Top 5 Free Microsoft Project Alternatives in 2022

How to Make a Flowchart in PowerPoint? 2 Easy Methods

Getting Started with Power Pivot: Advanced Excel

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)