Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto complete
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto complete
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 "arbuckle" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto complete not working | Excel Discussion (Misc queries) | |||
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) |