Nov 16 2021 05:09 AM - edited Nov 16 2021 07:50 AM
I have excel pro plus 2019, how to show the rest of the data preview options?! which version of excel has it?
Nov 16 2021 05:59 AM
I assume you refer to these checkboxes, right?
It's available in Microsoft 365 / Office 365 (I'm not sure if it's also in Excel 2019)
Nov 16 2021 12:32 PM
SolutionColumn quality interface and Power Query editor M-Intellisense were introduced for 365 couple of years ago. I'm almost sure they shall not be in 2019 since the latest is not feature updated. But most probably it is in 2021.
Nov 17 2021 07:06 AM
Nov 16 2021 12:32 PM
SolutionColumn quality interface and Power Query editor M-Intellisense were introduced for 365 couple of years ago. I'm almost sure they shall not be in 2019 since the latest is not feature updated. But most probably it is in 2021.