Forum Discussion
Not able to select multiple columns in power query
- 1 year ago
Hi KR300
You can select multiple columns by holding the CTRL key on the keyboard and selecting the column you need or using the choose column features in Power Query.
Note: the green box is selected columns using CTRL key, the red box is unselected column.
If you find this helpful, kindly mark my response as a solution.
Regards,
Mubar
I'm found the actual solution to this problem. You cannot select multiple columns only when you are in dark mode. It's not that it it looks like you haven't selected multiple columns, you actually cannot select multiple columns. Switch back to the normal theme and it will work. This is a bug Microsoft needs to fix for the dark theme.
- AFRenaud9 months agoNew Member
Thank you! I was desperately searching for a solution and this worked! I was using Dark mode and could not select multiple columns in power query. As soon as I switched it to "System Default," I gained the ability to select multiple columns (without restarting the app--just immediately able to multi-select).