Fix Excel for the Web Cannot Insert or Delete Rows in SharePoint
Question details
The user is unable to insert or delete entire rows or columns in an Excel workbook hosted on SharePoint, receiving an error prompting them to try a smaller selection.

- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to modify the structure of a worksheet by inserting or deleting rows/columns while editing a SharePoint-hosted workbook in a web browser.
- Observed behavior
- Excel for the web displays a 'Try again with a smaller selection' message. In some cases, the workbook may appear locked, take a long time to synchronize, or show blue row numbers with the entire sheet highlighted.
Ensure your internet connection is stable and verify that no other users are currently co-authoring and locking the specific worksheet you are trying to modify.
Format Data as an Excel Table (Recommended Workaround)
Instead of attempting to delete or insert entire worksheet rows, format your data range as a Table and modify only the specific table rows and columns to bypass the browser limitation.
Excel for the Web sometimes struggles with memory limitations when applying structural changes to entire worksheet columns or rows (which contain millions of cells). By converting your data into an Excel Table, you restrict the insertion or deletion process strictly to the data boundaries.
Highlight the specific range of cells that contain your data. On the Home tab, click on 'Format as Table' and choose a style.
Right-click a cell within the newly created table row or column that you want to modify.
From the context menu, select 'Insert' or 'Delete', then choose 'Table Rows' or 'Table Columns'. This action updates your data structure without affecting the entire worksheet grid.

Check for Active Filters and File Locks
If row numbers appear blue or the sheet is entirely highlighted, active filters or background synchronization locks may be preventing structural changes.
Edit Spreadsheets Seamlessly with WPS Office
If browser-based limitations and SharePoint synchronization errors are disrupting your workflow, consider using WPS Office. It provides a lightweight, highly compatible desktop spreadsheet editor that handles massive datasets without the 'smaller selection' errors common to web-based applications.
- 1. Download the file from SharePoint: Select your problematic Excel file in SharePoint and choose 'Download' to save a local copy to your computer.
- 2. Open with WPS Spreadsheet: Launch WPS Office, open the downloaded .xlsx file, and freely insert or delete entire rows without web browser restrictions.

Frequently Asked Questions
Why does Excel for the Web ask me to try again with a smaller selection?
This error occurs because web browsers have strict memory and processing limitations. Selecting an entire row or column highlights over a million cells, which can overwhelm the browser's resources, especially in a cloud-synced SharePoint environment.
How do I know if my SharePoint Excel file is locked by another user?
If a file is locked, Excel for the Web will typically display a banner stating the file is locked for editing by another user. You may also notice synchronization delays, or you'll only have 'Viewing' permissions until the other user closes their session.
Why are the row numbers blue in my Excel worksheet?
Blue row numbers indicate that a filter is currently active on your dataset. When a filter is hiding certain rows, structural actions like deleting entire columns or rows are often restricted to prevent accidental data loss.




