Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallWhen Excel will not delete a row, the cause is usually a specific restriction: the worksheet is protected, a filter hides the row, merged cells interfere with the operation, the data comes from a table or Power Query, or Excel believes used cells extend to the worksheet edge.
Start with protection and filtering, then check the worksheet structure and use the correct row-deletion command. If Excel says it cannot shift nonblank cells off the worksheet, clean up unused rows, columns, and formatting beyond your actual data.
1. Check whether the worksheet is protected
Worksheet protection can prevent row deletion. In desktop Excel, select the affected worksheet and look for one of these commands:
- Review > Changes > Unprotect Sheet
- File > Info > Protect > Unprotect Sheet
If Excel asks for a password, enter it and select OK. You should then be able to select the row heading, right-click it, and choose Delete.
#1 Best Overall
- Reliable Plug and Play: The USB receiver provides a reliable wireless connection up to 33 ft (1), so you can forget about drop-outs and delays and you can take it wherever you use your computer
- Type in Comfort: The design of this keyboard creates a comfortable typing experience thanks to the low-profile, quiet keys and standard layout with full-size F-keys, number pad, and arrow keys
- Durable and Resilient: This full-size wireless keyboard features a spill-resistant design (2), durable keys and sturdy tilt legs with adjustable height
- Long Battery Life: MK270 combo features a 36-month keyboard and 12-month mouse battery life (3), along with on/off switches allowing you to go months without the hassle of changing batteries
- Easy to Use: This wireless keyboard and mouse combo features 8 multimedia hotkeys for instant access to the Internet, email, play/pause, and volume so you can easily check out your favorite sites
If you do not know the password, ask the workbook owner or administrator. Worksheet protection is separate from a password required to open the Excel file.
Allow row deletion while keeping the sheet protected
To allow users to delete rows without leaving the worksheet unprotected:
- Select Review > Protect Sheet.
- Set or confirm the protection password, if required.
- In the Allow all users of this worksheet to list, enable Delete rows.
- Enable Insert rows separately if users also need to add rows.
- Select OK.
Delete rows and Insert rows are separate permissions. A protected sheet can allow row insertion while blocking row deletion.
Excel for the web
In Excel for the web, go to Review > Manage Protection. Turn off Protect sheet to disable protection, or choose Review > Pause Protection to suspend it for the current editing session. If the sheet uses a password, enter it when prompted. Restore protection with Review > Resume Protection.
Worksheet protection restricts changes to locked worksheet elements, but Microsoft says it is not intended as a security feature. Use file- or workbook-level protection when your goal is to secure the workbook itself.
2. Clear a filter that is hiding the row
A filter can make a row appear to be missing because it is hidden from the current view. A filtered column displays an Applied filter icon in its heading.
Rank #2
- Dependable wireless connection: Enjoy the reliability and convenience of 2.4 GHz connectivity with your logitech wireless keyboard and mouse combo, wireless range up to 10 meters away at home, or work.
- Full-Size Wireless Keyboard: Comfortable, quiet typing on a familiar keyboard layout with palm rest, spill-resistant design, and media keys. This wireless keyboard and mouse logitech has easy-access to media keys
- Plug and Play: MK345 works seamlessly with Windows, macOS, and ChromeOS. Experience hassle-free setup with the logitech mk345 wireless combo and wireless keyboard mouse combo for various operating systems.
- Long-lasting Battery: The MK345 combo offers a full size keyboard battery life of up to 3 years and a mouse battery life of 18 months (1); batteries included
- Comfortable Right-handed Mouse: This wireless USB mouse with dongle works well for this wireless mouse and keyboard combo, featuring a contoured shape for all-day comfort and smooth, precise tracking and scrolling for easier navigation.
To clear one column’s filter, select its filter icon and choose Clear Filter from <Column Name>. To clear all filter criteria while keeping the filter controls in place, select Data > Clear.
These actions are different:
| Command | Result |
|---|---|
| Data > Clear | Removes the current filter criteria but leaves filtering enabled. |
| Data > Filter | Removes the filter controls from the range. |
The keyboard sequence for removing filter controls in desktop Excel is Alt+D+F+F. Filtering applies to the entire range, so you cannot remove filtering from only one column while leaving the range filtered. Clear the criteria or turn filtering off for the range to work with every row.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →3. Look for merged cells
Merged cells can cause operations on rows or columns to fail or behave unexpectedly. This is common in sheets with title bands, report headers, or forms where cells have been combined.
Find merged cells in desktop Excel
- Go to Home > Find & Select > Find.
- Select Options.
- Select Format.
- Open the Alignment tab.
- Select Merge cells, then select OK.
- Select Find All.
Selecting an item in the results selects the corresponding merged cell. Unmerge cells that overlap the affected area, then try deleting the row again. The unmerge command is available from Home > Merge & Center.
Find merged cells in Excel for the web
Select a cell in the relevant area and inspect the Alignment group. If Merge and Center is highlighted, the cell is merged. Unmerge affected cells before trying the row operation again.
4. Check whether you are working inside an Excel table
Deleting worksheet rows and deleting an Excel table are different operations. Selecting a row heading and choosing Delete removes worksheet rows; it does not necessarily remove the table structure or its formatting.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →Rank #3
- 【Ergonomic Wireless Keyboard Mouse 】: Wireless ergonomic keyboard is equipped with adjustable height tilt legs to increase comfort and prevent your wrists injury when typing for a long time. The full size wireless keyboard with numeric keypad and 12 multimedia shortcut keys, such as play/ pause, volume increase and decrease, and email, to help you improve work efficiency
- 【Stable & Reliable Wireless Connection】: This wireless keyboard and mouse combo share the same USB receiver(stored in the mouse), and they can also be used separately. Plug & play, no need to download any software, 2.4 GHz wireless provides a powerful and reliable connection up to 33 feet(10m) without any delays.You can enjoy the convenience and freedom of wireless connection at home or at work
- 【Comfortable Optical Mouse】: This compact lightweight wireless mouse features a hand-friendly contoured shape for all-day comfort, and smooth, precise tracking.1600 DPI to meet your daily needs. Perfect for home & office work and entertainment
- 【Long Battery Life】: Up to 365 Days of battery life for keyboard and mouse wireless, say goodbye to the hassle of charging cables and replacing batteries. After 10 minutes of inactivity, the wireless keyboard mouse combo will automatically go into sleep mode to save energy. The wireless keyboard requires one AAA battery, and the wireless mouse requires one AA battery.
- 【Less Noise, More Quiet Keys】: Soft membrane keys provide a quiet and comfortable typing experience, So you can type with confidence on a wireless keyboard crafted for comfort, precision and fluidity. The wireless mouse adopts silent micro-motion technology, which is almost completely silent when clicked. No more concerns about disturbing others.
If you want to remove the entire table, select its cells and choose Clear > Clear All, or select the table and press Delete. These actions remove the table contents and formatting; they are not the way to delete just one worksheet row.
If you want to keep the data but remove the table behavior, convert the table to a normal range in desktop Excel. Excel for the web does not support converting a table to a normal data range while retaining the data without the table format; open the workbook in the desktop application for that operation.
5. Check whether the rows came from Power Query
Rows loaded by Power Query are query output, not ordinary worksheet records. To change the output, edit the query rather than deleting a result row directly.
To remove error rows from the query:
- Select a cell in the query output.
- Select Query > Edit.
- In Power Query Editor, select Home > Remove Rows > Remove Errors.
- Close and load the query again.
This changes the query transformation and its output. It does not delete or repair corresponding records in the external data source. If the source record must be removed, change it in the source system or adjust the query to exclude it.
Free tools Windows power users keep installed
One-click scans. No signup required.
6. Fix the “cannot shift nonblank cells off the worksheet” error
If Excel displays the message “To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet,” it has detected content or formatting near the worksheet boundary. Examples include formulas copied across a worksheet, formatting applied to a complete row or column, or residual formatting beyond the real data.
Deleting a row requires Excel to shift cells. If that shift would push cells beyond the last available row or column, Excel blocks the operation.
Rank #4
- Precision Typing: An instantly familiar experience, type with ease and comfort on this full-size wireless keyboard, featuring reduced noise, palm rest, spill-resistant design (1), adjustable tilt legs
- Built For Comfort: The sleek combo's wireless mouse features an ambidextrous shape and soft rubber side grips that fit comfortably in your palm, as well as enhanced tracking and precise cursor control
- Long-Lasting Autonomy: The wireless keyboard and mouse set come with long-lasting battery life, with the keyboard lasting up to 36 months and the wireless mouse for up to 18 months (3)
- Customized Control: Enhanced productivity at your fingertips, the computer keyboard comes built with convenient, essential hotkeys providing direct access to media, calculator, battery check functions
- Wireless Freedom: Plug-and-play your keyboard and mouse with the mini Logitech Unifying USB receiver, for a reliable wireless connection up to 33 ft away from your PC or laptop (2)
Remove unused formatted rows and columns
- Find the last genuinely used column in the worksheet.
- Select the first blank column immediately to its right, then select through the final worksheet column.
- Delete the selected columns, not just their contents.
- Find the first blank row immediately below the real data, then select through the final worksheet row.
- Delete those rows.
- Save the workbook, close it, and reopen it before testing again.
The documented legacy method is to select the first blank column to the right of the data, press Ctrl+Shift+Right Arrow, and use Edit > Delete. For excess rows, select the first blank row below the data, press Ctrl+Shift+Down Arrow, and use Edit > Delete. That Edit menu path is for older Excel versions; current Windows Excel uses the ribbon or row and column context menus.
If the used range remains abnormally large, remove residual formatting. Do not delete rows or columns containing real data, formulas, named-range dependencies, or required formatting.
Recommended Free Tools
7. Use the correct deletion command
Click the row number on the left to select the entire worksheet row, then use one of these methods:
- Right-click the row heading and select Delete.
- Select Home > Delete > Delete Sheet Rows.
- Press Ctrl+- after selecting the row.
If you select only cells in the row, Excel may offer Shift cells up instead of deleting the complete worksheet row. Choose the full-row option when the entire row must disappear.
Quick diagnosis table
| What you see | Likely cause | What to try |
|---|---|---|
| Delete is unavailable or Excel says the sheet is protected | Worksheet protection | Use Review > Changes > Unprotect Sheet, or pause protection on the web. |
| Some rows are missing from view | Filter criteria | Use the column filter’s clear command or Data > Clear. |
| Deleting a row causes an unusual range or column error | Merged cells | Find and unmerge cells overlapping the affected area. |
| The data has table styling and structured headers | Excel table | Use the row deletion command to delete one row, or clear all contents and formatting to remove the entire table. |
| The data refreshes from another source | Power Query output | Edit the query and remove rows in Power Query Editor. |
| Excel says it cannot shift nonblank cells off the worksheet | Used range extends to the worksheet boundary | Delete unused rows and columns beyond the real data, then save and reopen. |
Recommended order when nothing works
- Save a backup copy of the workbook.
- Check Review for worksheet protection.
- Clear or remove filters so hidden rows are visible.
- Check the affected area for merged cells.
- Determine whether the data is an Excel table or Power Query output.
- If Excel reports a worksheet-boundary error, remove excess rows, columns, and formatting.
- Retry by selecting the row heading and using Delete Sheet Rows.
These checks help identify whether the problem is with the worksheet structure rather than the row itself. A protected sheet needs permission changes, a filtered sheet needs its view restored, and query output needs to be changed at the query stage.
FAQ
Why can I insert rows in Excel but not delete them?
On a protected worksheet, Insert rows and Delete rows are separate permissions. The sheet owner may have enabled insertion while leaving deletion disabled. Use Review > Unprotect Sheet, or have the owner reprotect the sheet with Delete rows enabled.
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Clear out junk files and repair common Windows errors3Scan for outdated or missing drivers - takes under a minuteBest Value
- The things you do most are right at your fingertips with one-touch controls for instant access to play/pause, volume, mute and the Internet.
- Comfortable low-profile keys: Enjoy fast, fluid quiet typing on a familiar standard layout, including number pad.
- High-definition optical mouse: Smooth, responsive cursor control from a comfortable sculpted mouse.
- Sleek and durable design: Thin profile, spill-resistant design, durable keys and sturdy adjustable tilt legs. Tested under limited conditions (maximum of 60 ml liquid spillage). Do not immerse keyboard in liquid.
- Plug-and-play PC compatibility: Simple USB connection. Works with Windows XP, Windows Vista, Windows 7, Windows 8 or later or Linux kernel 2.6 or later.
How do I delete a row that is hidden by a filter?
Clear the relevant column filter by selecting its filter icon and choosing Clear Filter from <Column Name>. To clear all criteria, use Data > Clear. To remove filter controls entirely, use Data > Filter.
Why does deleting a row not remove the Excel table?
A table is a separate worksheet structure. Deleting worksheet rows does not delete the table itself. To remove the entire table and its formatting, select its cells and use Clear > Clear All, or select the table and press Delete.
Can I delete rows directly from Power Query results?
Change Power Query output in Power Query Editor. Select a query-output cell, choose Query > Edit, then use Home > Remove Rows and the appropriate removal command. This changes the query result, not the external source data.
What does “Excel cannot shift nonblank cells off the worksheet” mean?
Excel believes cells or formatting extend to the final row or column, so deleting a row would push content beyond the worksheet boundary. Delete unused rows below the real data and unused columns to its right, remove residual formatting, save, close, and reopen the workbook.
Is worksheet protection the same as protecting an Excel file?
No. Worksheet protection restricts changes to locked worksheet elements. It is separate from a password required to open a file or protection applied to the workbook structure, and Microsoft says worksheet protection is not intended as a security feature.
The Bottom Line
The fastest fix is usually to unprotect the sheet or clear an active filter. If neither applies, inspect merged cells, determine whether the data belongs to a table or Power Query, and clean up excess formatting or used cells at the worksheet boundary. Once the structural restriction is removed, select the row heading and choose Delete Sheet Rows.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
