Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto complete not working
Thanks in advance for your help.
I have Enable Autocomplete for cell values checked in Options/Edit. If I am entering in the next blank row in the column that has the text it auto completes. If i skip a row or go to another column it does not do the auto complete. Doesn't it look at the entire worksheet when it auto completes? Thanks, Sarah |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto complete not working
Hi!
Doesn't it look at the entire worksheet when it auto completes? No. As you've experienced, it only works on contiguous ranges. Biff "Sarah" wrote in message ... Thanks in advance for your help. I have Enable Autocomplete for cell values checked in Options/Edit. If I am entering in the next blank row in the column that has the text it auto completes. If i skip a row or go to another column it does not do the auto complete. Doesn't it look at the entire worksheet when it auto completes? Thanks, Sarah |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto complete not working
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto complete not working
If you selected A1:A200, then applied data|filter|autofilter, you'd see all the
items in A1:A200--no matter if you had blanks or not. But if you leave the range to filter up to excel, it'll guess that your data stops when it sees that blank row. (I never let excel guess at those kinds of ranges.) wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTO COMPLETE FOR CELL VALUES | Excel Discussion (Misc queries) | |||
Auto complete | Excel Discussion (Misc queries) | |||
How do I attach data to auto complete | Excel Worksheet Functions | |||
Auto Complete not completing | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |