word-excel-access-help.com logo
Excel for Dummies
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
Page 2

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...
How to use AutoFill
Turn on AutoFill

Turn On AutoFill

If the selected cell or range does not have a fill handle, it means that this feature is turned off.

To turn AutoFill on, follow these steps:

1. Choose Tools Options from the menu bar.
2. Click the Edit tab.
3. Make sure there is a check mark in the checkbox labeled "Allow Cell Drag and Drop".
  Excel for Dummies: Turn AutoFill on

You can't use AutoFill when you've made a multiple selection of different commands.

Excel for Dummies will show you how to do it separately for each command.
Back to Top
See also... How to use AutoFill
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