Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

auto-complete

Status
Not open for further replies.
snagger1234

snagger1234

Electrical
Joined
Apr 6, 2011
Messages
1
Location
GB
Hi,

Do you know how i can turn off auto-complete in cells in excel?
 
Sort by date Sort by votes
Try:

Tools --> Options --> Edit Tab --> Enable AutoComplete for cell values
 
Upvote 0 Downvote
or in 2007 or later:
Excel Options > Advanced > Editing Options; then deselect 'Enable AutoComplete for cell values'
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

phamENG
  • Locked
  • Question Question
Auto-Updating Template
Replies
11
Views
549
Tuckabag
Tuckabag
Histor
  • Locked
  • Question Question
Autogenerate Typical Rows based on input value
Replies
4
Views
429
SkipVought
SkipVought
TomBarsh
  • Locked
  • Question Question
Excel AutoCorrect ?
Replies
6
Views
641
davidbeach
davidbeach
dik
  • Locked
  • Question Question
Automating a Column
Replies
17
Views
558
SkipVought
SkipVought
d23
  • Locked
  • Question Question
Auto Run Macro
Replies
8
Views
298
davidbeach
davidbeach

Part and Inventory Search

Sponsor

Back
Top