Forum Discussion
Not able to select multiple columns in power query
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 did with Short Cuts + Holding the Control button + Shift button -- it didn't work.
Not sure what you mean by "Short Cuts".
To select a range of contiguous columns
- Select the first column in your range by clicking on it with the mouse
- Hold down ctrl+shift
- Select the last column in the range
- Release ctrl+shift
If that doesn't work, you may have a hardware problem.
Alternatively, select the Choose Columns button on the Home menu, then Choose columns from the dropdown and select the relevant columns.
Hi KR300,
Thank you ronrsnfld for addresing the issue.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
