Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Horizontal Scroll in Power Query Editor

Is there a shortcut for horizontal/sideways scroll in the Power Query editor? For example, in Power BI Data view, we can just hold shift when scrolling. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Edit: went and tested and learnt this one new for today. CTRL + ARROW will allow you to select columns and not lose the selection, whether than selection be adjacent or not. Also checked the docs again and apparently it is in there already which I missed first time around.

 

AlexBr_0-1698056279059.png

 



I don't think that behaviour is possible, see all the shortcuts here: Keyboard shortcuts in Power Query - Power Query | Microsoft Learn

View solution in original post

5 REPLIES 5
mlsx4
Super User
Super User

Hi @Anonymous 

 

I don't know if this is what you need but...

You first select some columns using Shift. Then, you scroll with nothing pressed.
When you want to continue selecting, press first Ctrl and click on the first column of the new range. Now press Shift and select until the end of your new range. 

 

I mean, I think you can achieve it with a combination of Ctrl and Shift

watkinnc
Super User
Super User

I'm pretty sure the arrow keys do that.

 

--Nate


I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!
Anonymous
Not applicable

That isn't really scrolling though. You couldn't select a couple columns to keep, scroll for a bit then add more columns to the selection. Pressing an arrow key immediately clears the selection.

 

Edit: thanks for replying though. Appreciate arrow keys are good enough for most scenarios.

Anonymous
Not applicable

Edit: went and tested and learnt this one new for today. CTRL + ARROW will allow you to select columns and not lose the selection, whether than selection be adjacent or not. Also checked the docs again and apparently it is in there already which I missed first time around.

 

AlexBr_0-1698056279059.png

 



I don't think that behaviour is possible, see all the shortcuts here: Keyboard shortcuts in Power Query - Power Query | Microsoft Learn

Anonymous
Not applicable

This is great, thank you! Bonus to this is that one can then press CRTL + SPACE to select the highlighted column, makes moving around much faster. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors