From the course: Excel Power Query Tips and Techniques

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Prevent table from resizing

Prevent table from resizing

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial

Prevent table from resizing

“

- [Instructor] One thing that can be annoying about working with Power Query in Excel is the resulting table from a query resizes on us. Look at this transaction days column. I'm going to adjust this because we don't need it to be that wide. Okay, that's better, but now look at this. I'm going to change this to 20 and then data, refresh. The table resized. How do we fix that? I'm going to click inside the table, right click, table, external data properties. Uncheck adjust column width, okay. Now let's go back and fix it again, close it a bit, then double click, all right. That's exactly what we want. Now I'm going to look at a different parameter, say 500, enter, refresh, beautiful. We got the new data and that table did not resize on us.

Contents