Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autocomplete function
Help! I use excel to enter patients and type of procedure (consultation, xray, capd, etc). I like it when the autocomplete function works to automatically type the word just above, but if I leave a cell empty, the next cell won't autocomplete. What can I do to make autocomplete work even if there are empty cells above after other entries in the same column? I hope someone can understand my explanation and help me! -- Drsally ------------------------------------------------------------------------ Drsally's Profile: http://www.excelforum.com/member.php...o&userid=24097 View this thread: http://www.excelforum.com/showthread...hreadid=377046 |
#2
|
|||
|
|||
You have two options, as I see it. The way Autocomplete (AC) works, if you have data in an adjoining column, AC will work the entire length of the blank column. Therefore, you could insert a column next to your AC column and fill will dummy data (enter 'a' and copy down). You can then Hide the dummy column if you want. Option two is to enter a space in your empty cells. They will still look empty, but will allow the AC to continue to work as you go down the column. Does one of these work for you? -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=377046 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |