You are right.To add to that
Autocomplete works only on rows and not on columns
Autofilter alos does not work on balnks
For example,when you have values from a1:a10 and then
form a150:a200,when you use autofilter, the values from
a1:a10 is only displayed
Also,you cannot cut and paste data in autofilter mode
For more queries and answers visit
http://groups.google.co.in/group/answers-for-everything