User Profile
Bodrey
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Autocomplete has stopped working
I'm using the Office 365 (web version) of Excel to keep track of my paper trades. Until recently, I was able to populate the ticker name and symbol columns with previous entries by just starting to type their name. It would then "autosuggest" based on those previous ticker names/columns. Now, it doesn't do it anymore. I've tried to find a solution online but they often reference menu items that don't even exist. How do I fix this? I can always copy and paste but it's so much easier and convenient to be able to use this auto complete feature to populate with pre-existing entries.25Views0likes1CommentAnnoying "Convert To Stocks" popup
I've created an Excel spreadsheet in O365 to document my paper trades. Every time I click on the ticker column this "Convert To Stocks" popup appears. Unless I take the focus off of the cell first and put it back it ends up converting the cell's contents and then I have to Undo the change. Annoying to say the least. I've done a search and followed to the how-to's to stop it from popping up but it didn't help. How did I get rid of that **bleep** thing?60Views0likes2CommentsRe: How do I enable Autocomplete?
BodreyUpdate: I just had a Microsoft tech connect to my PC and I showed him the problem. Even he wasn't able to fix it. He claims it's a bug that exists in the web version. I disagree. I have 3 sheets and the Autocomplete feature works in one of them, but not the other two. I don't know why.1.1KViews0likes0CommentsHow do I enable Autocomplete?
I'm using the online version of Excel to keep track of my stock market trades. I'm not even sure what the actual function is called (AutoComplete or AutoSuggest?) but if I've previously entered the name of a stock and I want to add an entry for the same stock name I want Excel to pop up the list of suggestions as soon as I start typing. So, for example, I've opened a position in Roku. If I want to add a new entry for Roku I want Excel to pop up the list of all entries that start with 'R' as soon as I type the letter. It seems that sometimes it works and sometimes it doesn't. I've Googled many different articles on the subject but they're all related to the standalone version of Excel (the suite). How do I fix this? The only option available under File->Options is "Regional Format Settings". It shouldn't be this difficult to enable the feature but thus far I haven't been able to figure out how to do it. Frustrating.1.1KViews0likes1Comment
Recent Blog Articles
No content to show