Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » Turn off AutoComplete in Excel
Turn off AutoComplete in Excel
You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.
If you find this feature more annoying than useful, you can turn it off by:
1. Going to Tools - Options.
2. Select the Edit tab.
3. Remove the tick from next to the "Enable AutoComplete for cell values" option.
4. Click OK.
Added by Amanda on 26th November 2006
More Excel hints and tips, like:
- Manually wrapping text
- Converting an American date format to European using Formula
- Convert Text into Number
 |
Streamlining Excel To Save Time By its very nature Microsoft Excel sometimes requires the user to spend long periods of time at the keyboard. Because of this we should always incorporate or familiarise ourselves with as many time-saving functions as possible. This has the double benefit of making life easier for the user, while increasing productivity. This article explores short cuts. » Article: Excel software training |
» Forum post: Meetings |
» Tip: Shortcut move between sheets |
How to set a re-accuring meeting
Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:
