To close the Queries & Connections pane in Excel for Microsoft 365 on Windows, click the X in the pane’s upper-right corner. This hides the pane; it does not delete queries, remove workbook connections, or change the worksheet data.
Close the pane on Windows
The pane usually appears along the right side of the Excel window. Its close button is at the top of the pane, separate from the controls that close the workbook or Excel itself. Click that small X to dismiss the side panel and give the worksheet more room.
- Find the Queries & Connections pane on the right side of the Excel window.
- Move to the pane’s upper-right corner and click its X.
- Continue working in the worksheet. The pane can be opened again later.
If you do not see the pane, there is nothing to close. If you have several panes open, make sure you click the X belonging to Queries & Connections rather than another panel, such as the Clipboard or Format Shape pane. The workbook window’s own close button is also different; clicking that closes the workbook window, not just the side pane.
What the pane shows
Queries & Connections is a workbook management pane for data brought into Excel or linked to it. Depending on the workbook, it can list Power Query queries and data connections. A query might import and transform a file, combine tables, or prepare data for loading into a worksheet or the Data Model. A connection can represent a link to an external data source or another workbook data feature.
The pane is useful when you need to inspect, edit, refresh, or manage those items. It is not the data itself, and it is not a required part of the worksheet display. Closing it simply hides this management interface. For example, if a query named “Monthly Sales” loads a table onto a sheet, closing the pane does not remove that table or erase the query definition.
Some Excel versions show tabs such as Queries and Connections within the pane. The available items and commands depend on how the workbook was built and which Excel features or data sources it uses. A workbook with no queries or connections may show an empty list or may not need the pane at all.
Closing the pane does not delete queries
A common worry is that closing the panel will break a refresh or remove the data. It does not. The X is a display control, not a delete command. The query definitions, connection settings, and already loaded results remain part of the workbook unless you take a separate action to change or remove them.
Keep these actions distinct:
- Close the pane: Hides the pane from view. It leaves the workbook’s queries and connections in place.
- Refresh data: Requests updated results from a source. Refresh controls are separate from the pane’s close button.
- Edit a query: Opens the query for changes to its source or transformation steps.
- Delete a query or remove a connection: Changes the workbook’s data setup. This is not what the pane’s X does.
If a refresh is already running, closing the pane is not a way to cancel it. The refresh may continue, and Excel may still display progress or an error when it finishes. To stop or troubleshoot a refresh, use the relevant refresh or query controls rather than treating the pane’s close button as a cancel command.
Reopen Queries & Connections
To bring the pane back in Excel for Microsoft 365 on Windows, select Data > Queries & Connections on the ribbon. Excel opens the pane again, typically at the right side of the window. If you do not see the command immediately, check the Data tab’s ribbon groups; the exact spacing and grouping can vary with window width and ribbon layout.
Opening the pane again does not refresh the data by itself. It gives you access to the listed queries and connections. To update results, choose an appropriate refresh command, such as Data > Refresh All when you intend to refresh all eligible workbook data. Be aware that refreshing can contact external sources and may take time or require access credentials.
If the pane opens but seems empty, check whether you are viewing the Queries or Connections list, and whether the workbook actually contains either item. A normal worksheet table is not automatically a Power Query query. Similarly, closing the pane and reopening it will not create a connection that the workbook does not have.
How the pane differs from related commands
Excel’s Data tab includes several commands with similar-sounding purposes. Choosing the right one helps avoid changing more than you meant to. The pane is a place to view and manage workbook data items; commands such as refresh, edit, and load affect or operate on those items.
- Queries & Connections: Opens the management pane so you can review the queries and connections in the workbook.
- Refresh All: Refreshes eligible data in the workbook; it does not just hide or show the pane.
- Get Data: Starts the process of connecting to or importing data. It is not the command for dismissing an already open pane.
- Close & Load: In the Power Query Editor, applies the query output and returns to Excel. It is different from closing the Queries & Connections pane.
In particular, do not choose a delete or remove option just to clear the screen. If your only goal is to see more of the worksheet, use the X on the pane. If your goal is to stop future refreshes or remove a query, that is a separate workbook-management decision and may affect other sheets or reports that rely on it.
When the pane will not close or keeps appearing
If clicking the X does not seem to work, first check that you clicked the pane’s X rather than the workbook’s window controls. The pane may also be inactive or partly obscured by another Excel window. Click inside the workbook, bring the correct window to the front, and try the pane’s close control again.
If the pane closes but reappears later, consider what action opened it. Selecting Data > Queries & Connections will open it again, as can choosing a command that needs the query or connection list. Excel may also restore parts of a previous workspace when a workbook or application session is reopened, depending on the setup. If it returns after you deliberately close it, note which ribbon command or workflow you used just before it appeared.
For an unresponsive Excel window, give an active refresh or other operation time to finish before repeatedly clicking controls. If Excel remains frozen, save any recoverable work if possible, then use normal application recovery steps. Restarting Excel can restore responsiveness, but it is not a special method for deleting or repairing a query. If the pane is blank or displays an error, closing it only hides that display; investigate the source, credentials, permissions, or refresh error separately.
Make more room for the worksheet
Closing the pane is especially helpful on a laptop, when a sheet has many columns, or when you are presenting a worksheet and do not need its data-management controls. It can expose more of the grid without changing column widths, zoom, print settings, or the workbook’s data model.
If the sheet still feels cramped, you can also adjust the Excel window size, use the zoom control, or hide the ribbon temporarily. Those are independent display choices. Closing Queries & Connections does not permanently save a particular screen layout as part of the worksheet’s data, and it does not change what another person’s Excel window displays when they open the workbook.
Excel for Mac and Excel for the web
The steps above are for Excel for Microsoft 365 on Windows. In Excel for Mac, the pane and ribbon organization can differ by release. If your Mac version displays a Queries & Connections pane, use the close control on that pane; do not assume every Windows ribbon grouping or command location is identical. Power Query and available data-source features can also vary between Windows and Mac versions.
Excel for the web has a different interface and does not provide every desktop Power Query management feature. A workbook may contain queries created in desktop Excel even when the web app cannot offer the same editing or connection controls. If you cannot find the pane or the needed query command in a browser, open the workbook in the desktop Excel app and use the Windows steps there, if available.
Frequently Asked Questions
Does closing Queries & Connections delete my query?
No. Clicking the pane’s X hides the panel only. The query and any loaded results remain in the workbook unless you separately edit, delete, or otherwise change them.
How do I get the Queries & Connections pane back?
In Excel for Microsoft 365 on Windows, select Data > Queries & Connections. The pane should reopen so you can review the workbook’s listed queries and connections.
Will closing the pane stop a data refresh?
No. Closing the pane is not a cancel command. A refresh that is already underway may continue; use the appropriate refresh controls or address the underlying operation if you need to manage it.
Why is Queries & Connections missing from the Data tab?
The ribbon may be compressed, the command may be arranged differently in your Excel build, or you may be using Excel for Mac or the web. Maximize the desktop window and inspect the Data tab; if the feature is unavailable in your current app, try desktop Excel.
Can I close the pane with Escape?
Escape is not the dependable close control for this pane. Click its X instead. That makes clear which panel you are dismissing and avoids accidentally closing the workbook or another window.
Related
- Can You Merge Excel Spreadsheets? Methods That Work
- Can You Merge Two Excel Spreadsheets? Methods Explained
- Password Protect a Tab in Excel: What Actually Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- CAGR Return in Excel: Calculate Investment GrowthTo calculate CAGR in Excel, divide the ending value by the beginning value, raise the result to the…
- Excel Budget Spreadsheet Free? Find Templates and TipsYes. You can download a free Excel budget spreadsheet template, or create and edit a basic budget in…
- Excel Conditional Formatting: 5-Color Scale GuideExcel for Microsoft 365 does not include a built-in five-color scale: its color-scale rules support two or three…
- Insert Rows in Excel Multiple Times: A Step-by-Step GuideTo insert several rows in Excel at once, select the same number of row headers as the number…
- Create a Number List in Excel: Easy Steps and MethodsTo create a numbered list in Excel, enter 1 in the first cell and 2 in the cell…
- Excel Data Validation List Limit and Practical WorkaroundsIn Excel, a list typed directly into the Data Validation Source box is limited to 255 characters in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.