1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Fill Handle Tutorials

How to Use the Fill Handle in Excel

By

The Fill Handle has many uses. It can be used to copy data, copy formulas, add pre-set list of data to a spreadsheets, and add a series of numbers as well. These tutorials include step by step examples of using the Fill Handle to complete these tasks in Excel.

1. Fill Handle Definition

Excel Fill Handle Tutorials
Excel Fill Handle Tutorials

Definition of the Excel Fill Handle.

2. Copy Data and Formulas with the Fill Handle

Excel Fill Handle Tutorials
Excel Fill Handle Tutorials

The Fill Handle can be used to copy data or formulas to adjacent cells in a worksheet. This step by step tutorial shows you how to use the Fill Handle to copy data and formulas in an Excel worksheet.

3. Auto Filling Pre-Set Lists with the Fill Handle

Excel Fill Handle Tutorials
Excel Fill Handle Tutorials

The Fill Handle can be used to add lists of pre-set data such as the days of the week or the months of the year to a worksheet. This step by step tutorial shows you how to use the Fill Handle to add lists of pre-set data to a worksheet.

4. Customizing the Fill Handle

Excel Fill Handle Tutorials
Excel Fill Handle Tutorials

In addition to using the Fill Handle to add the days of the week or months of the year to a worksheet, the Fill Handle can be customized to add your own lists of frequently used data - such as department names or group members. This step by step tutorial shows you how to customize the Fill Handle to add addition lists of pre-set data to a worksheet.

5. Adding Custom Lists of Data with the Fill Handle

Excel Fill Handle Tutorials
Excel Fill Handle Tutorials

Once you have added your customized list of data to the Fill Handle you need to add it to a worksheet. This step by step tutorial shows you how to add custom list of data to a worksheet using the Fill Handle in Excel.

6. Adding a Series of Numbers with the Fill Handle

Excel Fill Handle Tutorials
Excel Fill Handle Tutorials
The Fill Handle can also be used to add a series of numbers to a worksheet. This tutorial includes a step by step example of how to add a series of numbers to a worksheet with the Fill Handle.
Top Related Searches
  • spreadsheets
  • ©2014 About.com. All rights reserved.