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
If all you have done is navigate to that screen, no columns will be selected.
You need to either click on multiple columns while holding down ctrl or shift (depending on
whether you want to select contiguous or non-contiguous columns), or use the Choose Columns button which is in the menu bar just above your data.
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
