auto complete

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way auto complete can be made to work when the column contains
blank cells?
In a continuous column of data it works fine, but when spaces appear it
doesnt seem to be able to read the entries past the blank cell?
 
arbuckle,

Excel will only select entries for auto-complete from the cell's current region. If you completely
fill in an adjacent column, then the auto-complete will work.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Help needed 0
Auto fill typing in cells problem 2
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
The next Grand Theft Auto title has been officially announced 0
SUMIF with criteria "<>" & "=" 4
Comparison of columns using Conditional Formatting 3
formula finds values in apparently blank cells 1

Back
Top