Skip to content

TechRepublic

  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • Accounting
  • CRM
  • Academy
Resources
  • TechRepublic Premium
  • TechRepublic Academy
  • Newsletters
  • Resource Library
  • Forums
  • Sponsored
Go Premium
Popular Topics
  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • Accounting
  • CRM
  • Academy
  • Project Management
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
View All Topics
Go Premium
Software

Excel fill handle tricks

By Bill Detwiler October 20, 2005, 5:00 AM PDT Bill Detwiler on Twitter billdetwiler

Image
1
of 10

Excel fill handle tricks

Figure A
rnWe’ll experiment with four types of entries and fill them across and down.

Excel fill handle tricks

Figure B
rnIn the first selection, we dragged each entry’s fill handle across to column E. In the second selection, we dragged each entry’s fill handle down to row 12. As you can see, Excel copied the sample text and value. But because it recognized Saturday and 11/1/2005 as part of a series, it entered each successive value belonging to those series.

Excel fill handle tricks

Figure C
rnYou can tell Excel to increment a value by 1. Just hold down [Ctrl] as you drag the fill handle either across or down. As you drag, you’ll see a tiny plus sign beside the mouse pointer.

Excel fill handle tricks

Figure D
rnIf you want Excel to increment a number by a specific interval, select two adjacent cells that establish that interval. Here, we’ve selected cells containing the values 5 and 10. When we dragged the fill handle for this selection, Excel extended the series by increments of 5.

Excel fill handle tricks

Figure E
rnIf you right-click on an entry’s fill handle and drag, Excel will display a shortcut menu when you release the mouse button. Selecting the Series command brings up the options shown in the next figure.

Excel fill handle tricks

Figure F
rnThe Series dialog box offers context-specific options. In this case, the selection contained a numeric value, so Excel defaulted to the Linear option.

Excel fill handle tricks

Figure G
rnHere, we right-clicked on the fill handle for a date entry–the last day of November–and dragged across three adjacent cells. We then selected Series from the shortcut menu and chose Month under Date Unit. When we clicked OK, Excel entered the last day of the subsequent three months.

Excel fill handle tricks

Figure H
rnWhen you need to copy a formula down through a column, you can use the fill handle to do it automatically. In this example, we entered the formula =PRODUCT(A2,0.05) into cell B2 to return five percent of the value in cell A2. To fill that formula down column B for every value in column A, we just double-clicked the fill handle. Of course, this technique is more impressive when you’re copying the formula down through, say, several hundred cells.

Excel fill handle tricks

Figure I
rnExcel lets you create a custom fill list containing items you need to routinely insert in your worksheets. Choose Tools | Options, click the Custom Lists tab, and select New List. Then, just type your list in the List Entries box. Click Add and Excel will create your list, as shown here. An alternate approach is to create your list in a worksheet and select it. In the Custom Lists tab, use the Import button to create the list.

When you need to insert entries from your your custom list, just type the item you want to start with and drag that cell’s fill handle down or across through as many cells as necessary.

Excel fill handle tricks

Figure J
rnHere’s one last trick. You can quickly delete all the entries in a selection by clicking the fill handle and dragging up and to the left. Excel will gray out the cells that you drag across, as shown here. When you release the mouse button, the entries will be gone.

  • Software
  • Account Information

    Share with Your Friends

    Excel fill handle tricks

    Your email has been sent

Share: Excel fill handle tricks
Image of Bill Detwiler
By Bill Detwiler
Bill Detwiler is the Editor for Technical Content and Ecosystem at Celonis. He is the former Editor in Chief of TechRepublic and previous host of TechRepublic's Dynamic Developer podcast and Cracking Open, CNET and TechRepublic's popular online show.
  • Account Information

    Contact Bill Detwiler

    Your message has been sent

  • |
  • See all of Bill's content

Daily Tech Insider

If you can only read one tech story a day, this is it.

TechRepublic TechRepublic
  • TechRepublic on Facebook
  • TechRepublic on X
  • TechRepublic on LinkedIn
  • TechRepublic on YouTube
  • TechRepublic on Pinterest
  • TechRepublic RSS
Services
  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information
  • Careers
Explore
  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • Editorial Policy
  • Legal Terms
  • Privacy Policy
© 2025 TechnologyAdvice. All rights reserved.
CLOSE

Create a TechRepublic Account

Get the web's best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let's start with the basics.

Already registered? Sign In
Use Facebook
Use Linkedin

* - indicates required fields

CLOSE

Sign in to TechRepublic

Not a member? Create an account
Use Facebook
Use Linkedin

Lost your password? Request a new password

CLOSE

Reset Password

Please enter your email adress. You will receive an email message with instructions on how to reset your password.

Check your email for a password reset link. If you didn't receive an email don't forgot to check your spam folder, otherwise contact support.

Back to login
1 Finish Profile
2 Newsletter Preferences
CLOSE

Welcome. Tell us a little bit about you.

This will help us provide you with customized content.

No thanks, continue without
1 Finish Profile
2 Newsletter Preferences
CLOSE

Want to receive more TechRepublic news?

Newsletter Name
Subscribe
Daily Tech Insider
Daily Tech Insider AU
TechRepublic UK
TechRepublic News and Special Offers
TechRepublic News and Special Offers International
Executive Briefing
Innovation Insider
Project Management Insider
Microsoft Weekly
Cloud Insider
Data Insider
Developer Insider
TechRepublic Premium
Apple Weekly
Cybersecurity Insider
Google Weekly
Toggle All
No thanks, continue without

You're All Set

Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add [email protected] to your contacts list.

Back to Home Page
×