Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I store frequently used text in Excel for auto-complete?
Hi,
How do I store frequently used text in Excel for auto-complete? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I store frequently used text in Excel for auto-complete?
Autocomplete uses the cells directly above the cell.
Here are a couple of links: XL97: AutoComplete Fails After 102 Rows Past Last Occurrence http://support.microsoft.com/default.aspx?id=177423 XL2000: AutoComplete Works Differently After 102 Rows Past Last Occurrence http://support.microsoft.com/default.aspx?id=212069 KeithyBX wrote: Hi, How do I store frequently used text in Excel for auto-complete? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I store frequently used text in Excel for auto-complete?
Care to be a little more specific?
You can type it in a cell and then copy/paste it to your desired location, but I don't think that's what you're after... -- -SA "KeithyBX" wrote: Hi, How do I store frequently used text in Excel for auto-complete? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I store frequently used text in Excel for auto-complete?
Ooops... just re-read your post and it clicked... my bad :)
I'm not sure you can add words to the auto-complete. I only know how to add them to the auto-correct. Good luck! -- -SA "KeithyBX" wrote: Hi, How do I store frequently used text in Excel for auto-complete? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I store frequently used text in Excel for auto-complete
Hi SA:
You can use AutoCorrect instead..For example, enter qu should be replaced by question and its just as good autocomplete. -- Gary''s Student - gsnu200795 "StumpedAgain" wrote: Ooops... just re-read your post and it clicked... my bad :) I'm not sure you can add words to the auto-complete. I only know how to add them to the auto-correct. Good luck! -- -SA "KeithyBX" wrote: Hi, How do I store frequently used text in Excel for auto-complete? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return text value found most frequently in a column | Excel Worksheet Functions | |||
Auto Complete (???) in Excel | Excel Worksheet Functions | |||
How do I get a field in excel to auto complete with a check mark | Excel Discussion (Misc queries) | |||
Can you enable auto complete from a custom list in Excel? | Excel Discussion (Misc queries) | |||
Vlookup did cell auto formating but not displaying complete text.. | Excel Worksheet Functions |