Excel for Dummies
 |
 |
 |
 |
 |
 |
 |
Excel for Dummies
Additional Resources
Excel for Dummies
Excel for Dummies
Excel for Dummies - AutoComplete | 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 AutoComplete to automatically complete your typed text for you.
 |
What's on this page... Using AutoComplete Pick from List Turn Off AutoComplete |
Turn Off AutoComplete
If you don't like this feature, you can always turn it offTo turn off the AutoComplete function, follow these steps:
| 1. | Choose Tools ► Options from the menu bar. |
| 2. | Click the Edit tab. |
 |
|
| 3. | Remove the checkmark from the check box labeled Enable AutoComplete for cell values option. |
| Back to Top |
| See also... Using AutoComplete | Using Pick From List |
| Return to Excel XP from Excel for Dummies - 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