Excel for Dummies
 |
 |
 |
 |
 |
 |
 |
Excel for Dummies
Additional Resources
Excel for Dummies
Excel for Dummies
Excel for Dummies - AutoFill | Microsoft Excel XP
|
 |
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.
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.
 |
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". |
 |
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
- 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