word-excel-access-help.com logo
Excel for Dummies
Home
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Excel for Dummies
Additional Resources



Excel for Dummies


Excel for Dummies

Excel for Dummies - AutoFill | Microsoft Excel XP

Microsoft Excel XP logo
Excel for Dummies will teach you step-by-step how to use the AutoFill feature of Microsoft Excel XP.

This feature will make entering data into your worksheet very easy and much quicker. No more retyping the same old redundant data.

Just use AutoFill to make it easier for you.

Excel Office Helper What's on this page...
Using AutoFill
Turn on AutoFill

Excel for Dummies - AutoFill

AutoFill is a handy feature that has several uses (mouse required). You can use this function to complete a series of weeks, months, years, etc.

Almost anything that has a progressive series to it can be used in AutoFill.

AutoFill automatically fills your range of cells with your choice.

To fill cells with AutoFill, follow these steps:

1. Type the starting contents of the first cell.
   
  For example, let's say you want to fill a range of adjacent cells with "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" and "Sunday".
   
  Type "Monday" in the first starting cell.
   
2. Place the mouse pointer on the fill handle located at the bottom-right corner of the selected cell.
   
  Excel for Dummies: AutoFill - Fill Handle Fill Handle
   
  Once the mouse pointer is over the Fill Handle, it will change into a thin black cross.
   
  Excel for Dummies: AutoFill - Fill Handle' Mouse Pointer Mouse Pointer over Fill Handle
   
3. Right-click and drag the fill handle down or across, depending on which direction you want to fill.
   
  Excel for Dummies: AutoFill - Dragging the Fill handle Dragging the Fill Handle
   
4. Once you are at the cell to which you want to fill, release the mouse button.
   
  A list of options to fill with will be displayed, depending on what you have typed in the first cell.
   
  Excel for Dummies: AutoFill pop-up menu AutoFill pop-up menu
   
5. From the pop-up menu, choose the option to which you want to fill the cells to.

Excel office helper
You can also type the first two occurrences of the series that you want to fill.

For example,
if you want to fill the cells incrementing in 5's, then type 5 in the first cell and 10 in the second cell.

When you select to drag, make sure you select both cells and then drag the fill handle.

Excel office helper
If the values in the cells that you enter do not have equal increments, Excel completes the series by calculating a simple linear regression.  This feature is handy for performing simple forecasts.

Note: Excel calculates a simple linear regression or progression, depending on the direction (negative or positive) of the series.
 
Back to Top
 
See also... Turn AutoFill On
 
Return to Excel XP from Excel for Dummies - AutoFill & AutoComplete
 
Microsoft Excel XP
- Tips
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter