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 - AutoComplete | Microsoft Excel XP

Microsoft Excel XP logo
Excel for Dummies will teach you step-by-step how to use the AutoComplete feature of 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.

Excel Office Helper What's on this page...
Pick from List

Turn Off AutoComplete

Excel for Dummies - AutoComplete

AutoComplete enables you to type the first few letters of a text entry into a cell, and Excel automatically completes the entry based on other entries that you've already made in the column.

You'll notice that as you start typing the same word, already used in the column, in a new cell, Excel enters the word in highlighted text.

To use AutoComplete, follow these steps:

1. Begin entering the text or value.
2. If Excel recognizes your entry, it automatically completes it in highlighted form.
  Excel for Dummies: AutoComplete example AutoComplete assumes your next move.
3. If, what Excel guesses is correct, press ENTER to accept it.
  If you want something else, just continue typing and ignore Excel's guess.

If Excel doesn't guess completely right, then you can choose to pick the correct entry from a list.

1. While Excel is showing its' guess, right-click in the highlighted text.
  Excel for Dummies: Pick from list example Right-click to go to Pick From List
2. From the shortcut menu choose Pick from List.
  Excel displays a drop-down list with all of the entries in the current column.
  Excel for Dummies: Autocomplete pick from list Pick an option from the list
3. Either click the option you want and press ENTER, or you can press ENTER TWICE with the option selected.
Back to Top
See also... Turn Off AutoComplete feature
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
- 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