Excel power query-Data preview

Occasional Contributor

I have excel pro plus 2019, how to show the rest of the data preview options?! which version of excel has it?




4 Replies


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)

best response confirmed by NoorAlfar (Occasional Contributor)


Column 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.

I hope the feature is in 2021 version. thank you