auto-complete

  1. B

    Excel text-based auto-complete works for some items, doesn't for others

    Excel 365 on Windows 10 I have an Excel sheet with about 2000 rows. In one column, there are names, repeating from a few hundred individual values. Expected: when I type a name in a new row, in this column, auto-complete should find the matching name and fill it in. Observed: for some names it...
  2. W

    Excel Ghost Behaviour

    Hi all, I have a macro enabled spreadsheet that has multiple auto-complete drop-down lists. When the file is shared the drop-down list did not appear from the selected cell but instead appeared in another cell (see screenshot from the link below). I have also attached the spreadsheet if someone...
  3. B

    Drop Down with Autocomplete help

    Hi all - new to the message board, need a little help. I have some experience with VBA, but I am far from a master. I essentially have a sheet where for each line (maybe 100 lines to a sheet) a reviewer selects a value from a very long drop down list to provide the status for the individual...
  4. K

    Attach Setting to Document, Not Excel Program on Computer

    Hi all, Sorry if this is already out there and I missed it (in which case, please feel free to share the useful link:) ), but I was wondering if there was anyway to tie settings to a shared document. The details are as follows: I have an excel shared on a server with many other people. To...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top