Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows 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 reinstallExcel usually refuses to add cells for one of two reasons: formatting has expanded the worksheet’s stored used range to its limits, or hidden objects such as comments, charts, shapes, and pictures would be pushed beyond the sheet. Identify the message, clean only the affected area, save and reopen the workbook, then retry the insertion.
Which Excel error are you seeing?
The wording determines the repair path. Excel may report that it cannot insert cells because doing so would push non-empty cells off the end of the worksheet. That is a used-range problem. A different alert says Cannot shift objects off sheet; that points to an object anchored in the area Excel must move.
As an Amazon Associate I earn from qualifying purchases.
| Message or symptom | First check | Main remedy |
|---|---|---|
| Cannot add or insert cells; non-empty cells would be pushed off the sheet | Press Ctrl+End and compare the selected cell with your real data | Clear unused rows and columns, save, close, and reopen |
| Cannot shift objects off sheet | Check hidden objects and the object-display setting | Show all objects, then adjust object placement if necessary |
Why Excel thinks the sheet is full
Every worksheet has a fixed maximum of 16,384 columns and 1,048,576 rows. Excel also stores a “last cell” that includes formatting, not just visible values. A cell can look empty while retaining a fill color, border, number format, or other formatting. Microsoft explains that empty cells may contain formatting that causes the last cell in a row or column to fall outside the range containing data.
Free tools Windows power users keep installed
One-click scans. No signup required.
When Excel tries to insert a row, column, or individual cells, existing content and formatting must shift. If the stored last cell is already at (or effectively reaches) the sheet boundary, Excel cannot move that range farther, even when the visible table occupies only a small area. Excess formatting can also increase workbook size and contribute to slower operation.
#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
Back up the workbook before changing its range
Save a separate copy before clearing cells or running cleanup. Use File > Save As, give the copy a new name, and keep the original closed. This matters because clearing a large range can remove formatting you intended to keep, and the Inquire cleanup described below cannot be undone in some cases.
Diagnose an inflated used range with Ctrl+End
- Open the backup copy and activate the worksheet where insertion fails.
- Click any cell.
- Press Ctrl+End.
- Compare the selected cell with the actual bottom-right cell of your data.
If Ctrl+End lands immediately after your real data, the used range may be normal and the problem may involve objects or a different worksheet. If it jumps far below the last record or far to the right of the final populated column, Excel has retained data or formatting in those unused areas.
Rank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
Repeat the test on other sheets if the workbook contains several tabs. The failure may occur only on the active sheet, and cleaning a different tab will not change the insertion limit.
Clear unused rows and columns
This is the targeted manual fix when Ctrl+End reveals an inflated range.
Rank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
- Identify the last column that genuinely belongs to your table or report. Select every column to its right through the current used-range boundary. You can select a whole column by clicking its letter, then extend the selection with Shift or by dragging across the column headers.
- On the ribbon, choose Home > Clear > Clear All. “Clear All” removes contents and formatting from the selected unused columns.
- Identify the last real row. Select every row below it through the bottom of the inflated range by clicking and extending the row-number selection.
- Choose Home > Clear > Clear All again.
- Save the workbook.
- Close Excel completely, reopen the saved workbook, and run Ctrl+End again.
Excel recalculates the last cell after the save-and-reopen cycle. Ctrl+End should now land near the genuine bottom-right edge of your data. If it still lands in the old location, inspect for remaining formatting, formulas, or objects in the supposedly unused area and repeat the selection carefully. Do not clear columns or rows that contain data, formulas, print-layout elements, or intentionally formatted report sections.
Why deleting content alone may not work
Pressing Delete removes values in many cases but can leave formatting behind. That retained formatting is enough to keep the stored used range expanded. Use Home > Clear > Clear All for the unused rows and columns, then save, close, and reopen.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
Use Inquire to clean excess formatting (supported Windows editions)
Some supported Excel for Windows enterprise editions include the Inquire COM add-in, which has a command specifically for excess cell formatting. Availability depends on your Excel edition; it is not a universal feature in every installation.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
- Open File > Options > Add-ins.
- At the bottom beside Manage, select COM Add-ins, then choose Go.
- Enable Inquire and select OK. An Inquire tab should appear on the ribbon.
- Save a backup before continuing, even if you already made one.
- On the Inquire tab, choose Clean Excess Cell Formatting.
- Read the confirmation carefully and run the cleanup only on the workbook and sheets you intend to change.
- Save, close, and reopen the workbook, then test Ctrl+End and the insertion again.
Microsoft warns that this operation cannot be undone in some cases. If the add-in is unavailable, use the targeted Clear All procedure instead; do not install an unverified add-in solely to obtain this command.
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
Retry the insertion using Excel’s supported commands
After cleaning the range, use one of these insertion methods rather than typing into the sheet boundary.
Insert complete worksheet rows or columns
- Select the row number or column letter where the new space should appear.
- Choose Home > Insert > Insert Sheet Rows or Insert Sheet Columns.
- Enter or paste your data into the new row or column.
Insert individual cells and shift existing cells
- Select the cell or range where the space is needed.
- Right-click the selection and choose Insert.
- Select Shift cells right or Shift cells down.
- Confirm the choice and check nearby formulas and formatting.
These commands are documented for Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016. Names can vary slightly by platform language, but the row, column, and shift-cell choices perform the same operation.
Fix “Cannot shift objects off sheet”
Microsoft says this variant commonly involves objects that can be inserted into a worksheet, including cell comments, graphs or charts, drawing shapes, and pictures. The objects may be hidden, so a sheet that appears empty can still contain something anchored at the edge.
Recommended Free Tools
Show every object
- Choose File > Options > Advanced.
- Scroll to the Display options for this workbook section.
- Under For objects, show, select All.
- Choose OK, then retry the row, column, or cell insertion.
If the insertion succeeds, inspect the newly visible comments, charts, shapes, and pictures. Move or remove only the objects that are no longer needed, and save the workbook.
Change an object’s placement
For an object that must remain, select it and open its formatting or properties dialog. Set its placement to Move and size with cells, as documented by Microsoft, then retry the insertion. This lets the object move with the cells instead of remaining anchored in a position that blocks the shift. Because the exact dialog name differs between charts, pictures, and shapes, right-click the object and look for Format, Size and Properties, or an equivalent properties command.
Quick Recap
If insertion still fails
- Test another worksheet: Insert a temporary row or column on a new, blank sheet. If that works, the issue is confined to the original sheet’s range or objects.
- Check both directions: A table may have unused formatted columns to the right and unused formatted rows below. Clear both areas; cleaning only one direction may leave the stored last cell unchanged.
- Look for hidden content: Turn on object display, unhide rows and columns, and inspect the far edges of the sheet.
- Confirm the active sheet: The insertion command applies to the selected sheet. Make sure you cleaned and tested the same tab that produced the error.
- Reopen after every cleanup: Excel may not recalculate the stored last cell until the file is saved, closed, and opened again.
- Preserve a fallback copy: If a cleanup changes a report’s layout or formatting unexpectedly, close without overwriting the original and restore from the backup.
Choosing the safest remedy
| Situation | Recommended action | Risk or limitation |
|---|---|---|
| Ctrl+End is far beyond the real data | Clear unused rows and columns with Home > Clear > Clear All; save, close, reopen | Do not include intentional report formatting or data |
| Supported Windows enterprise edition with extensive excess formatting | Use Inquire > Clean Excess Cell Formatting after making a backup | Microsoft warns that the operation may not be undoable |
| Alert specifically says Cannot shift objects off sheet | Set For objects, show to All; inspect object placement | Objects may become visible and require manual repositioning |
| Normal used range and no visible objects | Check hidden objects, other sheets, and the exact insertion command | The cause may be confined to a single worksheet |
Prevent the problem from returning
- Apply formatting only to the rows and columns your report uses, rather than formatting entire columns or the entire worksheet.
- When deleting old report sections, clear their formatting as well as their values if the area will no longer be used.
- Keep charts, pictures, shapes, and comments within the active report area, and review their placement after major row or column changes.
- Save and reopen after a substantial cleanup so Ctrl+End reflects the revised used range.
- Keep a dated backup before any range-wide cleanup or add-in operation.
As an optional shortcut after the manual checks, Outbyte PC Repair can look for common Windows issues, clean temporary and cache files, review settings and vulnerabilities, and record app crashes. It complements an antivirus rather than replacing one; results vary, and no utility repairs every Excel crash. It runs on Windows 11, 10, 8, and 7, with a free trial by category of at least two days followed by a subscription.
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.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →
