---
title: How to change the query cell range in your spreadsheet
description: Do you need to adjust your query's cell range? Follow this step-by-step guide to ensure your data appears exactly where you want it.
---
[Skip to content](https://support.dataslayer.ai/how-to-change-the-cells-range-on-your-spreadsheet#main-content)
- [English](https://support.dataslayer.ai/how-to-change-the-cells-range-on-your-spreadsheet)
- [Español](https://support.dataslayer.ai/es/cómo-cambiar-el-rango-de-celdas-de-la-consulta-en-la-hoja-de-cálculo)
English
Show submenu for translations
[](https://www.dataslayer.ai/)
Open main navigation
Close main navigation
- - [English](https://support.dataslayer.ai/how-to-change-the-cells-range-on-your-spreadsheet)
- [Español](https://support.dataslayer.ai/es/cómo-cambiar-el-rango-de-celdas-de-la-consulta-en-la-hoja-de-cálculo)
English
Show submenu for translations
Hello. How can we help you?
- There are no suggestions because the search field is empty.
1. [Knowledge base](https://support.dataslayer.ai/?hsLang=en)
2. [Spreadsheets](https://support.dataslayer.ai/spreadsheets?hsLang=en)
March 14, 2025
# How to change the query cell range in your spreadsheet
## Do you need to adjust your query's cell range? Follow this step-by-step guide to ensure your data appears exactly where you want it.
When working with queries in spreadsheets, it's common to realize after setting them up that the selected cell range isn't quite right. Fortunately, adjusting the range is a straightforward process. Follow these steps to modify the query’s placement efficiently!
#### **1. Locate the query in your spreadsheet**
Before you begin making any changes, take a moment to determine the location of the generated query. Understanding where it has been created will assist you in locating it within the DataslayerQueries sheet in the next step if you've several queries on your document.
#### **2. Open the DataslayerQueries sheet**
Dataslayer stores query configurations in a dedicated sheet called **DataslayerQueries**.
If you're unsure where to find it, refer to [our guide](https://support.dataslayer.ai/how-to-find-the-query-sheet?hsLang=en) for quick access.
#### **3. Remove the Query ID and Range address**
At this point, you must **close the extension**, and we will provide instructions on when to reopen it.
Once inside the DataslayerQueries sheet:
- Identify the row that contains your query.
- In the designated column, remove both the **Query ID** and the **Range Address** where it was initially created.
When making adjustments on this sheet, please **be careful**.
**Altering any cells** outside of those specified in this guide **may disrupt the functionality** of your queries. If you encounter any issues with the queries not running smoothly, we recommend checking [this article](https://support.dataslayer.ai/why-should-i-not-modify-the-dataslayerqueries-sheet-and-what-is-it-for?hsLang=en) for assistance.
#### **4. Delete the previously created table**
Return to the sheet where your query was displayed. Locate the table that was generated by the query and **remove it** by selecting the table and pressing the **"Delete" key** or the **Backspace key** on your keyboard.
Deleting the table does **not** remove your query's configuration—it remains securely stored in the DataslayerQueries sheet.
#### **5. Enter the new range address**
Return to the DataslayerQueries sheet and input the new range address where you want the query to appear.
**Considerations** when selecting the range address:
- If you enter the range address asA1:A1, the tool will automatically determine the appropriate ending cell based on the data size. This ensures that the table starts at A1 and expands dynamically as needed.
- You can also specify a **custom range** if you want the query to appear elsewhere.
- *Example:* If you want the query to appear in C5:E5, simply enter C5:E5 as the range address, and the data will be placed accordingly.
- The ending cell of the table is always updated automatically based on the amount of data retrieved.
- *Example:* If your query initially returns only three columns (A1:C1), but you've selected a larger range (A1:F1), the tool will adjust the range dynamically upon refresh. If the query still only returns three columns, the range will update to reflect A1:C1 instead of A1:F1.
#### **6. Refresh the query in the Dataslayer extension**
While opening the Dataslayer extension, you’ll notice some details have been automatically updated. Nevertheless, to ensure the changes take effect, click the **Refresh** button.
#### **7. Verify the query placement**
Once the refresh is complete, go back to your spreadsheet. The query should now be positioned correctly within the new range.
**Done! You've successfully modified the query range address.**
As always, please do not hesitate to contact us via our live chat on [our website](https://dataslayer.ai/?__hstc=205882892.6526bb15cfac7d661ffbfd3c4281267e.1709723421854.1710260696573.1710325530529.16&__hssc=205882892.10.1710325530529&__hsfp=1885414922) or via [e-mail](mailto:info@dataslayer.ai) if you still have doubts or questions. We are happy to help!
- [General](https://support.dataslayer.ai/general?hsLang=en)
- [Billing & Pricing](https://support.dataslayer.ai/billing-pricing?hsLang=en)
- [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en)
- [Blended Connectors](https://support.dataslayer.ai/blended-connectors?hsLang=en)
- [Google Sheets](https://support.dataslayer.ai/google-sheets?hsLang=en)
- [Microsoft Excel](https://support.dataslayer.ai/microsoft-excel?hsLang=en)
- [Spreadsheets](https://support.dataslayer.ai/spreadsheets?hsLang=en)
- [Looker Studio](https://support.dataslayer.ai/looker-studio?hsLang=en)
- [Big Query](https://support.dataslayer.ai/big-query?hsLang=en)
- [API Query Manager](https://support.dataslayer.ai/api-query-manager?hsLang=en)
- [Power BI](https://support.dataslayer.ai/power-bi?hsLang=en)
- [Amazon S3](https://support.dataslayer.ai/amazon-s3?hsLang=en)
- [Amazon Redshift](https://support.dataslayer.ai/amazon-redshift?hsLang=en)
- [Snowflake](https://support.dataslayer.ai/snowflake?hsLang=en#main-content)
- [Marketplace](https://support.dataslayer.ai/snowflake?hsLang=en#marketplace)
- [Google Cloud Storage](https://support.dataslayer.ai/google-cloud-storage?hsLang=en)
- [Database](https://support.dataslayer.ai/database?hsLang=en)
- [Azure SQL](https://support.dataslayer.ai/azure-sql?hsLang=en)
- [Azure Storage](https://support.dataslayer.ai/azure-storage?hsLang=en)
- [Dataslayer Atlas](https://support.dataslayer.ai/dataslayer-atlas?hsLang=en)
- [Morpheus](https://support.dataslayer.ai/morpheus?hsLang=en)
- [AI Looker Studio Analyzer](https://support.dataslayer.ai/ai-looker-studio-analyzer?hsLang=en)
- [Dataslayer MCP](https://support.dataslayer.ai/dataslayer-mcp?hsLang=en)
- [Dataslayer GPT](https://support.dataslayer.ai/dataslayer-gpt?hsLang=en)
- [Dataslayer AI Chat](https://support.dataslayer.ai/dataslayer-ai-chat?hsLang=en)
[](https://dataslayer.ai/)
Dataslayer.ai: Digital Marketing Reporting Made Easy
Copyright © 2026, DATASLAYER SL