how to load the power query table into existing work cell without adding any columns

Question

how to load the power query table into existing work cell without adding any columns

Chaturvedi, Santosh 450

how to load the power query table into existing work cell without adding any new columns

riny 21,520 Reputation points Volunteer Moderator

2026-10-02T12:31:31.53+00:00

@Chaturvedi, Santosh

What do you mean by "into existing work cell without adding any new columns"?

PS: I deleted your own answer that just repeated the original question. No need for repetition here :)

3 answers

Your answer

riny 21,520 Reputation points Volunteer Moderator

2026-10-02T12:31:31.53+00:00

@Chaturvedi, Santosh

What do you mean by "into existing work cell without adding any new columns"?

PS: I deleted your own answer that just repeated the original question. No need for repetition here :)

Answer 1

Dear Chaturvedi, Santosh,

I hope you’re having a good day.

Power Query can load the result to an existing worksheet location by using:

Home > Close & Load To... > Existing Worksheet

However, Power Query cannot load a multi-column table into a single existing cell without expanding into the required rows and columns. A query result is always loaded as a table or data range and will use as many columns as the query returns.

If your goal is to avoid creating additional columns, you would first need to transform the data in Power Query (for example, merge multiple columns into a single column) before loading it back to the worksheet.

Could you provide a small example of your source data and the desired output? That would help determine the best approach.

Please understand that our initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.

Looking forward to hearing back from you with any updates or additional details.

Warm regards,

If the answer is helpful, please select "Yes, accept answer". If you have any questions or new updates, please feel free to comment below.

Liora 2,080 Reputation points Independent Advisor

2026-10-05T07:59:48.84+00:00

Hi,

I hope you're having a great day.

I'm following up to see if you've made any progress with this issue or if there are any updates you'd like to share.

Wishing you all the best, and I look forward to hearing from you.

Kind regards.

Answer 2

Chaturvedi, Santosh 450

I want to down load the power qry data in cell 124 onwards..which is already have formated for usage. Add data in sheet cell 124 without adding and shifting columns and any exting format

User's image

with

Liora 2,080 Reputation points Independent Advisor

2026-10-02T12:44:26.41+00:00

Hi Santosh,

Thank you for the screenshot. I understand your requirement now.

If you want the Power Query output to start at row 124 and keep your existing report formatting intact, unfortunately Power Query cannot load data into pre-formatted cells without creating its own output table/range. When refreshed, it will expand as needed and may overwrite formatting within its output area.

For your scenario, I would recommend loading the Power Query result to a separate worksheet and then linking the values into your formatted template starting at row 124 using formulas. This keeps your "Stress Spectrum" layout and formatting untouched while still allowing the data to refresh automatically.

If you choose Close & Load To > Existing Worksheet and select the cell at row 124 as the starting point, Power Query will still use as many rows and columns as required by the query result and cannot be restricted to load only into existing formatted cells.

From the screenshot, your worksheet appears to be a report template rather than a raw data area, so I would strongly recommend keeping the Power Query output separate from the presentation sheet.

Kind regards.
Ashish Mathur 102.5K Reputation points Volunteer Moderator

2026-10-02T22:49:30.94+00:00

No, you cannot.

Answer 3

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more