Need to use spell-check so that the LANGAUGE columns can be fixed! Also, are sub-languages supported so that I can, for example translate from Spanish to English(UK) for appropriate spelling? I hope the detect language feature is similarly tuned to user's profile settings. The original Language Auto Detect had a bug (which I detected, reported and got fixed) that always switched English text to English(US), irrespective of template and other settings. Now dealing with similar broken language settings in Microsoft Loop which (as has been reported by people in multiple languages) just ignores your language presets, thus breaking spell-check and date formats.
Love the Focus Cell, but why oh why did they not make it so it stays highlighted when you click out of Excel. Would love to see where I was at if I checking it with another document.
The translate formula doesn't appear to be working on my access to web excel or the desktop version. Is there something I can do to upgrade? I'm in Australia if that matters.
I see the Focus Cell option in my desktop excel but it is grayed out. Is it because it's not fully released or is there something else I need to enable in Excel?
Focus Cell doesn't work for me if "Freeze Panes" is enabled on a tab. It'll only work for me if I turn off Freeze Panes, but I personally want Freeze Panes on so I can have the header row data displayed when scrolling down
@@christophermiles6828 Great insight Christopher, thank you! Now it is enabled. Most of the other functions Mike presented are not yet released, at least for my version, but this one is. I agree with you that Freeze Panes is essential. The only option to not have to enable it but still see the titles is by making your array a table.
@@claudiat.8508 Most of the other features aren't on mine yet either! Yeah I guess you can have data in a table to still see the headings while scrolling down. Hopefully they work on it to make it work with freeze panes as this will be very handy! 😊
Thank you for this video, I dont think that all features are enabled as of today, i tried all of them but not all worked, fyi, I have the latest version of microsoft, say translation, and line draw, I am now trying the web excel :) :) :)
@@MikeTholfsen nor the line draw worked with me, but I will wait for the updates by end of the year, so it could be that all features are released globally. Thanks
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
Nicely done: Fast with no fluff
Useful information and best part is to provide a tutorial task for learning
Microsoft is the BEST for translating! All the products are amazing at helping people with many different languages
Need to use spell-check so that the LANGAUGE columns can be fixed! Also, are sub-languages supported so that I can, for example translate from Spanish to English(UK) for appropriate spelling? I hope the detect language feature is similarly tuned to user's profile settings. The original Language Auto Detect had a bug (which I detected, reported and got fixed) that always switched English text to English(US), irrespective of template and other settings.
Now dealing with similar broken language settings in Microsoft Loop which (as has been reported by people in multiple languages) just ignores your language presets, thus breaking spell-check and date formats.
Very useful insights. Thank you
I really like that focus function. Does that work on ipad?
Not yet
Love the Focus Cell, but why oh why did they not make it so it stays highlighted when you click out of Excel. Would love to see where I was at if I checking it with another document.
Just change the format?
Good question.
wow and peace be upon you sir from me
The translate formula doesn't appear to be working on my access to web excel or the desktop version. Is there something I can do to upgrade? I'm in Australia if that matters.
Can I ask how to get the sheet tab interface like yours? Hope to receive a response from you
Is Translate now available in General Release are are we still waiting for it to be released?
I think TRANSLATE rolls out to global production in December
I have an Excel table and a pivot table. Focus cell works in the pivot table but not the data table. Why?
I'm unable to see in my excel 365 updates. How to get it?
I see the Focus Cell option in my desktop excel but it is grayed out. Is it because it's not fully released or is there something else I need to enable in Excel?
Focus Cell doesn't work for me if "Freeze Panes" is enabled on a tab. It'll only work for me if I turn off Freeze Panes, but I personally want Freeze Panes on so I can have the header row data displayed when scrolling down
@@christophermiles6828 Great insight Christopher, thank you! Now it is enabled. Most of the other functions Mike presented are not yet released, at least for my version, but this one is. I agree with you that Freeze Panes is essential. The only option to not have to enable it but still see the titles is by making your array a table.
@@claudiat.8508 Most of the other features aren't on mine yet either! Yeah I guess you can have data in a table to still see the headings while scrolling down. Hopefully they work on it to make it work with freeze panes as this will be very handy! 😊
On excel if you have so much data and you want to jump to the last empty row where you want to continue with your work ,best tell me the easy trick?
CTRL + Down Arrow
I’d like to see a picture of your 18 string guitar!!!
Thank you for this video, I dont think that all features are enabled as of today, i tried all of them but not all worked, fyi, I have the latest version of microsoft, say translation, and line draw, I am now trying the web excel :) :) :)
I think TRANSLATE rolls out to global production in December
@@MikeTholfsen nor the line draw worked with me, but I will wait for the updates by end of the year, so it could be that all features are released globally. Thanks
did he really call a triangle, a rectangle?