Office Settings & Configuration

How to Disable Continue with the Current Selection in Excel Sorting

Camila Milosovich Oct 10, 2026 870 views

Question details

The user wants to know if it is possible to remove or disable the 'Continue with the current selection' prompt when sorting data to prevent users from accidentally corrupting data relationships.

How to Disable 'Continue with the Current Selection' in Excel Sorting

Product: Microsoft Excel
Device & OS: not provided
Scenario: Multiple users are sorting data in a shared online Excel workbook and incorrectly choosing the partial sort option.
Observed behavior: When users select a single column to sort, Excel prompts them. If they choose 'Continue with the current selection', only that column sorts, which misaligns the row data across the workbook.

Before you start

Before applying these structural changes to your workbook, ensure that all collaborators have saved their work and temporarily exited the shared file to prevent editing conflicts.

Solution 1Recommended

Convert the Data Range to an Excel Table

Converting your data into an official Excel Table binds the rows together as single records, which automatically forces Excel to expand the sort and eliminates the prompt entirely.

This is the most reliable workaround because it inherently changes how Excel treats the data structure. Once converted, sorting a single column via the header dropdowns will always sort the entire row, protecting data integrity.

Select your data

Click on any single cell containing data within your dataset.

Insert Table

Go to the 'Insert' tab on the Excel ribbon and click 'Table', or press the 'Ctrl + T' keyboard shortcut.

Confirm table range

Ensure the range selected in the popup dialog covers all your data and that the 'My table has headers' box is checked. Click 'OK'.

Sort without prompts

Use the filter arrows that now appear in your header row to sort your data. Excel will no longer prompt you to expand the selection.

Convert the Data Range to an Excel Table

Data Integrity Protected: Excel Tables automatically lock row data together, preventing accidental single-column sorting errors.

Solution 2

Protect the Worksheet Structure

If you cannot use Excel Tables, you can restrict users from sorting the worksheet altogether by using Excel's built-in protection features.

Solution 3

Pre-select the Entire Range

Train users to manually select the entire data range before initiating a sort, which bypasses the warning prompt.

Free Microsoft Office alternative

Experience Seamless Data Management with WPS Office

While Microsoft Excel lacks a direct toggle to disable this specific sorting prompt, you can explore WPS Office as a free, lightweight, and highly compatible alternative. WPS Spreadsheet provides intuitive data management tools and a familiar interface that makes training your team straightforward and efficient.

1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install WPS Office: Run the downloaded installer and follow the on-screen instructions to complete the setup.
3. Open your workbook: Launch WPS Spreadsheet and seamlessly open your existing Excel workbooks to enjoy familiar sorting and data management features.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Free to use with a lightweight installation packageIntuitive user interface for easier data sorting and team collaborationBuilt-in table formatting tools to safeguard data integrity natively

microsoft office alternative - wps office

Frequently Asked Questions

Can I use a VBA macro to disable the 'Continue with the current selection' warning?

No, VBA cannot intercept or disable this specific built-in Excel warning dialog directly. However, you can create a custom sorting macro that automatically expands the selection and assign it to a custom button, instructing users to use that button instead of the default Excel sort feature.

Why does Excel ask to expand the selection in the first place?

Excel detects adjacent data next to the column you are attempting to sort. The prompt is a built-in safety feature designed to ensure you do not accidentally scramble your rows by sorting only one column while leaving related data in adjacent columns untouched.

How do I submit a feature request to Microsoft to make this optional?

You can submit your feedback directly to the Microsoft Excel development team through the official Microsoft Feedback Portal. Providing detailed use cases, such as the difficulty of managing shared online workbooks, helps prioritize the request.

Office App Problems