Excel Performance Problems

Fix Excel’s Cannot Insert Cells Error Caused by the Used Range

Kushani NimanthikaKushani Nimanthika Nov 22, 2026 868 views

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.

Fix Excel’s Cannot Insert Cells Error Caused by the Used Range
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.
Before you start

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.

Solution 1Recommended

Delete unused rows and columns beyond your data

Use this method when Excel’s used range extends far beyond the actual worksheet data.

1
Select unused rows

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.

2
Delete the rows

Right-click the selected row headers and choose Delete. Do not use the Delete key alone, which only clears cell contents.

3
Delete unused columns

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.

4
Save and reopen

Select File > Save, close the workbook, and reopen it. Press Ctrl+End to check the used range, then try the insertion again.

Delete unused rows and columns beyond your data
Check before deleting: Deleting rows or columns removes any hidden data and formulas within them. Confirm that the selected areas contain nothing you need.
Free Microsoft Office alternative

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.

Insert and delete spreadsheet rows and columns in a familiar interfaceOpen and edit Microsoft Excel XLS and XLSX filesUse a free, lightweight office suiteMove between office applications with a familiar layout
microsoft office alternative - wps office

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.