Name suggestions

Barrowlad

New Member
Joined
Apr 4, 2019
Messages
18
Hi all,,, Please could you help me with this.
When I start to type a name in a cell, I type the first letter and it shows the rest of
the name, for example If I type J J it will give the rest as J Jones, but if I carry on
and type the rest e,g, J Ja it does not give me Jackson as the rest, can I do something
about this and why does it not even give me any in another workbook?.
Its not important but if it can be done done I would like to.
Thanks in advance.
len
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,640
If you have J Jackson and J Jones in your data, typing J J shouldn't offer any autofil (assuming they're all in the same table and column)

What does the data look like?
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,763
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
If the data is in the same column, it will auto fill if the name if....spelled EXACTLY the same AND has appeared in the column previously
 

Barrowlad

New Member
Joined
Apr 4, 2019
Messages
18
Its not even giving me a suggestion in my other workbook, is there somewhere to turn in on and alter the options?.
Len
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,763
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows

Barrowlad

New Member
Joined
Apr 4, 2019
Messages
18
Thankyou Michael, I will make do with that for now, Thanks for taking the trouble.
Len
 

Watch MrExcel Video

Forum statistics

Threads
1,123,104
Messages
5,599,746
Members
414,333
Latest member
willfrederick

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
Top