Excel autocomplete/ suggestion list. Not a drop down Announcing the arrival of Valued...
Is there a spell that can create a permanent fire?
What does Sonny Burch mean by, "S.H.I.E.L.D. and HYDRA don't even exist anymore"?
Short story about astronauts fertilizing soil with their own bodies
"Destructive power" carried by a B-52?
How could a hydrazine and N2O4 cloud (or it's reactants) show up in weather radar?
What helicopter has the most rotor blades?
How to achieve cat-like agility?
How to make an animal which can only breed for a certain number of generations?
Understanding piped commands in GNU/Linux
How do I say "this must not happen"?
Was the pager message from Nick Fury to Captain Marvel unnecessary?
New Order #6: Easter Egg
Why is there so little support for joining EFTA in the British parliament?
Why can't fire hurt Daenerys but it did to Jon Snow in season 1?
Table formatting with tabularx?
Flight departed from the gate 5 min before scheduled departure time. Refund options
IC on Digikey is 5x more expensive than board containing same IC on Alibaba: How?
Fit odd number of triplets in a measure?
Getting representations of the Lie group out of representations of its Lie algebra
How to name indistinguishable henchmen in a screenplay?
Searching extreme points of polyhedron
How many time has Arya actually used Needle?
Why not use the yoke to control yaw, as well as pitch and roll?
Where and when has Thucydides been studied?
Excel autocomplete/ suggestion list. Not a drop down
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Excel, drop down listsConditional drop down listHow to change value in Excel drop down listExcel drop-down list with multiple criteriaCopy drop down list from excel 2007Use data from a drop down list to populate tableHow to make data shown on excel drop down list appear as numbers (shortcuts)?Excel - Using a drop-down list to populate other drop-down listsHow many entries can autocomplete in Excel 2013 handle?Excel autocomplete not working consistently
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am using Excel to record various data and some rows have more cells than others.
How can I make a list of words for Excel to use to autocomplete when I am entering data manually.
I don't need a drop down
Thanks
microsoft-excel autocomplete
asked Feb 3 '16 at 15:56
JackJack
62
add a comment |
I am using Excel to record various data and some rows have more cells than others.
How can I make a list of words for Excel to use to autocomplete when I am entering data manually.
I don't need a drop down
Thanks
microsoft-excel autocomplete
asked Feb 3 '16 at 15:56
JackJack
62
1
Welcome to Super User, Jack. This is not a service site, rather a site for specific Q&A when you have attempted something and get stuck. Please expound on what you have tried so far and we will try to help from there. How to Ask may be helpful to improve your question.
– CharlieRB
Feb 3 '16 at 16:43
Also, is AutoComplete enabled in your options?
– CharlieRB
Feb 3 '16 at 16:46
Agree with CharlieRB. As a solution, the only thing I can think of is making a predefined list, f.e. in column A and hide the rows that contain the data. You'll notice that in the cells in that column, you'll have autocomplete. Just make sure you don't have empty cells in between them, that will break autocomplete functionality.
– Terry
Feb 3 '16 at 16:48
1
Watch this Video: Autocomplete Entries With Excel Drop Down List. Is this what you're looking for?
– Maher Fattouh
Feb 3 '16 at 19:44
add a comment |
I am using Excel to record various data and some rows have more cells than others.
How can I make a list of words for Excel to use to autocomplete when I am entering data manually.
I don't need a drop down
Thanks
microsoft-excel autocomplete
asked Feb 3 '16 at 15:56
JackJack
62
I am using Excel to record various data and some rows have more cells than others.
How can I make a list of words for Excel to use to autocomplete when I am entering data manually.
I don't need a drop down
Thanks
microsoft-excel autocomplete
microsoft-excel autocomplete
asked Feb 3 '16 at 15:56
JackJack
62
asked Feb 3 '16 at 15:56
JackJack
62
asked Feb 3 '16 at 15:56
JackJack
62
asked Feb 3 '16 at 15:56
JackJack
62
asked Feb 3 '16 at 15:56
JackJack
62
62
1
Welcome to Super User, Jack. This is not a service site, rather a site for specific Q&A when you have attempted something and get stuck. Please expound on what you have tried so far and we will try to help from there. How to Ask may be helpful to improve your question.
– CharlieRB
Feb 3 '16 at 16:43
Also, is AutoComplete enabled in your options?
– CharlieRB
Feb 3 '16 at 16:46
Agree with CharlieRB. As a solution, the only thing I can think of is making a predefined list, f.e. in column A and hide the rows that contain the data. You'll notice that in the cells in that column, you'll have autocomplete. Just make sure you don't have empty cells in between them, that will break autocomplete functionality.
– Terry
Feb 3 '16 at 16:48
1
Watch this Video: Autocomplete Entries With Excel Drop Down List. Is this what you're looking for?
– Maher Fattouh
Feb 3 '16 at 19:44
add a comment |
1
Welcome to Super User, Jack. This is not a service site, rather a site for specific Q&A when you have attempted something and get stuck. Please expound on what you have tried so far and we will try to help from there. How to Ask may be helpful to improve your question.
– CharlieRB
Feb 3 '16 at 16:43
Also, is AutoComplete enabled in your options?
– CharlieRB
Feb 3 '16 at 16:46
Agree with CharlieRB. As a solution, the only thing I can think of is making a predefined list, f.e. in column A and hide the rows that contain the data. You'll notice that in the cells in that column, you'll have autocomplete. Just make sure you don't have empty cells in between them, that will break autocomplete functionality.
– Terry
Feb 3 '16 at 16:48
1
Watch this Video: Autocomplete Entries With Excel Drop Down List. Is this what you're looking for?
– Maher Fattouh
Feb 3 '16 at 19:44
1
1
Welcome to Super User, Jack. This is not a service site, rather a site for specific Q&A when you have attempted something and get stuck. Please expound on what you have tried so far and we will try to help from there. How to Ask may be helpful to improve your question.
– CharlieRB
Feb 3 '16 at 16:43
Welcome to Super User, Jack. This is not a service site, rather a site for specific Q&A when you have attempted something and get stuck. Please expound on what you have tried so far and we will try to help from there. How to Ask may be helpful to improve your question.
– CharlieRB
Feb 3 '16 at 16:43
Also, is AutoComplete enabled in your options?
– CharlieRB
Feb 3 '16 at 16:46
Also, is AutoComplete enabled in your options?
– CharlieRB
Feb 3 '16 at 16:46
Agree with CharlieRB. As a solution, the only thing I can think of is making a predefined list, f.e. in column A and hide the rows that contain the data. You'll notice that in the cells in that column, you'll have autocomplete. Just make sure you don't have empty cells in between them, that will break autocomplete functionality.
– Terry
Feb 3 '16 at 16:48
Agree with CharlieRB. As a solution, the only thing I can think of is making a predefined list, f.e. in column A and hide the rows that contain the data. You'll notice that in the cells in that column, you'll have autocomplete. Just make sure you don't have empty cells in between them, that will break autocomplete functionality.
– Terry
Feb 3 '16 at 16:48
1
1
Watch this Video: Autocomplete Entries With Excel Drop Down List. Is this what you're looking for?
– Maher Fattouh
Feb 3 '16 at 19:44
Watch this Video: Autocomplete Entries With Excel Drop Down List. Is this what you're looking for?
– Maher Fattouh
Feb 3 '16 at 19:44
add a comment |
1 Answer
1
active
oldest
votes
You need an add-in to complete that. I guess this video is what you exactly need Excel Autocomplete video
The website of the addin is https://www.excelautocomplete.com/. There are demonstrations on the site also.
This is how it works, you create a range which contain the list of items you want to appear in the suggestion list. Then, you select the cells which you want to enable the autocomplete feature and select the range you set up before. After this, all the selected cells now have drop down box appears on focus.
answered Nov 14 '17 at 10:36
codingpusscodingpuss
1214
Added. However, it is hard to fully describe how the add-in works with just text
– codingpuss
Nov 14 '17 at 10:52
Much better, merci for taking my avice!
– Pierre.Vriens
Nov 14 '17 at 11:03
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1035165%2fexcel-autocomplete-suggestion-list-not-a-drop-down%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You need an add-in to complete that. I guess this video is what you exactly need Excel Autocomplete video
The website of the addin is https://www.excelautocomplete.com/. There are demonstrations on the site also.
This is how it works, you create a range which contain the list of items you want to appear in the suggestion list. Then, you select the cells which you want to enable the autocomplete feature and select the range you set up before. After this, all the selected cells now have drop down box appears on focus.
answered Nov 14 '17 at 10:36
codingpusscodingpuss
1214
Added. However, it is hard to fully describe how the add-in works with just text
– codingpuss
Nov 14 '17 at 10:52
Much better, merci for taking my avice!
– Pierre.Vriens
Nov 14 '17 at 11:03
add a comment |
You need an add-in to complete that. I guess this video is what you exactly need Excel Autocomplete video
The website of the addin is https://www.excelautocomplete.com/. There are demonstrations on the site also.
This is how it works, you create a range which contain the list of items you want to appear in the suggestion list. Then, you select the cells which you want to enable the autocomplete feature and select the range you set up before. After this, all the selected cells now have drop down box appears on focus.
answered Nov 14 '17 at 10:36
codingpusscodingpuss
1214
Added. However, it is hard to fully describe how the add-in works with just text
– codingpuss
Nov 14 '17 at 10:52
Much better, merci for taking my avice!
– Pierre.Vriens
Nov 14 '17 at 11:03
add a comment |
You need an add-in to complete that. I guess this video is what you exactly need Excel Autocomplete video
The website of the addin is https://www.excelautocomplete.com/. There are demonstrations on the site also.
This is how it works, you create a range which contain the list of items you want to appear in the suggestion list. Then, you select the cells which you want to enable the autocomplete feature and select the range you set up before. After this, all the selected cells now have drop down box appears on focus.
answered Nov 14 '17 at 10:36
codingpusscodingpuss
1214
You need an add-in to complete that. I guess this video is what you exactly need Excel Autocomplete video
The website of the addin is https://www.excelautocomplete.com/. There are demonstrations on the site also.
This is how it works, you create a range which contain the list of items you want to appear in the suggestion list. Then, you select the cells which you want to enable the autocomplete feature and select the range you set up before. After this, all the selected cells now have drop down box appears on focus.
answered Nov 14 '17 at 10:36
codingpusscodingpuss
1214
edited 3 hours ago
answered Nov 14 '17 at 10:36
codingpusscodingpuss
1214
answered Nov 14 '17 at 10:36
codingpusscodingpuss
1214
answered Nov 14 '17 at 10:36
codingpusscodingpuss
1214
1214
Added. However, it is hard to fully describe how the add-in works with just text
– codingpuss
Nov 14 '17 at 10:52
Much better, merci for taking my avice!
– Pierre.Vriens
Nov 14 '17 at 11:03
add a comment |
Added. However, it is hard to fully describe how the add-in works with just text
– codingpuss
Nov 14 '17 at 10:52
Much better, merci for taking my avice!
– Pierre.Vriens
Nov 14 '17 at 11:03
Added. However, it is hard to fully describe how the add-in works with just text
– codingpuss
Nov 14 '17 at 10:52
Added. However, it is hard to fully describe how the add-in works with just text
– codingpuss
Nov 14 '17 at 10:52
Much better, merci for taking my avice!
– Pierre.Vriens
Nov 14 '17 at 11:03
Much better, merci for taking my avice!
– Pierre.Vriens
Nov 14 '17 at 11:03
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1035165%2fexcel-autocomplete-suggestion-list-not-a-drop-down%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Welcome to Super User, Jack. This is not a service site, rather a site for specific Q&A when you have attempted something and get stuck. Please expound on what you have tried so far and we will try to help from there. How to Ask may be helpful to improve your question.
– CharlieRB
Feb 3 '16 at 16:43
Also, is AutoComplete enabled in your options?
– CharlieRB
Feb 3 '16 at 16:46
Agree with CharlieRB. As a solution, the only thing I can think of is making a predefined list, f.e. in column A and hide the rows that contain the data. You'll notice that in the cells in that column, you'll have autocomplete. Just make sure you don't have empty cells in between them, that will break autocomplete functionality.
– Terry
Feb 3 '16 at 16:48
1
Watch this Video: Autocomplete Entries With Excel Drop Down List. Is this what you're looking for?
– Maher Fattouh
Feb 3 '16 at 19:44