I have no idea what a section header is. If you try to select from a list
in the column above your entry, Excel will show you the entries above but
stop if a cell is empty. For example if cell A1 contains abc and cell A2
contains def and cell A4 contains ghi and cell A5 contains jkl if I enter in
cell A3 a, Excel will show abc to choose from. If I enter in A6 g, Excel
will show ghi to choose from. In other words. Excel shows all cells above
that meet the beginning letters of the entry, but terminates when a cell
above is empty.

Tyro

"Timma" wrote in message
...
I have a customer (I'm in tech support) that wants to know why sometimes in
Excel he can enter the first few characters of a word and Excel will
AutoComplete the rest of the word for him but sometimes it won't. I've
determined that he is having this problem because of section headers. As
long as the word he wants to AutoComplete already exists within a section,
AutoComplete will work in that section; if the word does not yet exist in
that section, AutoComplete isn't going to work.

My question is, does anyone know any tips or tricks or better formatting
methods to get around this? This is a rather lengthy spreadsheet and
there
are section headers galore.

Thank You!!