Forum Discussion
Selecting multiple sheets at once-Power query navigator
Hello, I have one excel workbook with multiple sheets in it. i want to import all the sheets into power query, but the problem is that in power query navigator it won't let me choose all the sheet...
AbbasG
Memorable Member
Memorable MemberGal1234 Hi, I was simply able to select them all and import them as your desired outcome.
Below are screenshots for your reference.
Hope it helps.
Thanks for the reply but that's not what I meant.
in your example, you import 3 sheets that you needed to choose one by one.
But imagine that you have 200 sheets that you need to import, you don't want to waste 1 hour picking them one by one right?
What I asked if there a way to choose all the sheets at once, without choose them one by one in the Power query navigator like you did.