Excel Basics Calculations Special Features
Format Cells Sum, Average, Countif Functions Excel Charts (Graphs)
Worksheets Quick Functions Sort Data
Edit Cells The IF Statement Filter Data
Rows and Columns VLOOKUP Function Conditional Formatting
Find and Replace Sumif Function Pivot Table
The Fill Handle Excel Formulas Create a Drop Down List
Excel Keyboard Shortcuts First Aid
Excel Training
Microsoft Word Training
Excell Books
About
Questions & Answers
Guestbook
Office 2007 Books
A Full Excel Course

Fun Maths Games
Learning Place Value
Rounding Number Games

microsoft word training

Using the Fill Handle

The fill handle - with numbers
The fill handle - with text
The fill handle - with text & numbers
The fill handle - with dates

You are welcome to have a look at my Free Math Games.


When should you use the fill handle?

Every time you want to get a series of data.

For example, you might want to number rows in the regular format of 1, 2, 3, 4… or maybe 10, 20, 30, 40… or maybe choose only to have even numbers: 2, 4, 6, 8…

The fill handle is very useful for creating lists of consecutive dates: either every day, every week, every month, year, or whatever difference between dates you want.





Recommended Excel 2007 Books:



Website Statistics