Fix Excel’s Cannot Insert Cells Error Caused by the Used Range
Question details
The user needs to insert cells, rows, or columns in an Excel worksheet without triggering a warning about non-empty cells being pushed off the sheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet may have formatting or used-range information extending beyond its visible data.
- Observed behavior
- Excel blocks the insertion because it considers cells near the worksheet boundary to be in use.
Find the last row and column that contain data you need, including hidden cells and formulas. Press Ctrl+End to see where Excel currently considers the used range to end.
Delete unused rows and columns beyond your data
Use this method when Excel’s used range extends far beyond the actual worksheet data.
Click the row number immediately below your last needed data row, then press Ctrl+Shift+Down Arrow to select through the bottom of the worksheet.
Right-click the selected row headers and choose Delete. Do not use the Delete key alone, which only clears cell contents.
Click the column letter immediately to the right of your last needed data column, press Ctrl+Shift+Right Arrow, then right-click the selected column headers and choose Delete.
Select File > Save, close the workbook, and reopen it. Press Ctrl+End to check the used range, then try the insertion again.

Remove excess table formatting with the Normal cell style
Try this if lingering table banding or other formatting still extends beyond the data.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets for an easy transition, though it does not repair an Excel-specific insertion error.

Frequently Asked Questions
Why does Excel say non-empty cells would be pushed off the worksheet?
Excel may consider cells near the worksheet boundary used because they contain data or formatting. Press Ctrl+End to check where Excel considers the used range to end.
Is clearing blank cells the same as deleting unused rows?
No. Pressing the Delete key clears contents but does not delete rows. Select the unused row headers, right-click them, and choose Delete.
Will applying the Normal cell style remove formulas?
No, applying Home > Cell Styles > Normal does not delete formulas. It can remove date, currency, and other formatting, so those formats may need to be reapplied.
What happens when I convert an Excel table to a range?
Table Design > Convert to Range keeps the worksheet data but removes table-specific features. Existing table formatting may remain until you change the cell styles.




