auto complete in cells

C

Cindy

I have the auto complete function enabled, but it does not
seem to be working on my spreadsheet. Any ideas why or
what I can do to fix it?
 
G

Gord Dibben

Cindy

You are quite sketchy on details here, but AutoComplete requires contiguous
data in the cells above the entry cell.

Gord Dibben Excel MVP
 
T

Tom Culp

Gord,

So any blank cell in the column will defeat Autocomplete? It seems the pick
list works on the same principal. Any way to get this to work with blanks?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto populate value from one task to another in MS PROJECT 0
Auto-complete Typing 1
Hyperlinking automatic?? 1
Automatic indexing in footnotes - solved 0
auto complete 1
Global Template Network and saving auto texts & macros 2
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Text duplication question 0

Top