spacer spacer spacer
  arrow Sample Dialog
  arrow Key Facts
  arrow Solutions
  arrow Forum Help
  arrow Vendor Summary
  arrow Research this Issue
  help Solutions Help
Fix-It Utilities
Make your PC run like new! Includes Anti-Virus, Anti-Spyware, hardware diagnostics, registry fixer, and more!
  PC Mover
Move applications, files and settings from one PC to another. Handles Windows upgrades too, even XP 32-bit to Windows 7 64-bit!
Ensures you have the latest drivers and software updates to make your PC run better and safer.
Application Solutions

Microsoft Office Excel

To prevent possible loss of data, Excel cannot...

  Sample Dialog  
Microsoft Office Excel screen shot
Dialog may appear differently depending on Windows style options and where it occurs.
  Key Facts  
Full Title
  Microsoft Office Excel 

Body Text
  To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet. Select another location in which to insert new cells, or delete data from the end of your worksheet.

If you do not have data in cells that can be shifted off of the worksheet, you can reset which cells Excel considers nonblank. To do this, press CTRL+End to locate the last nonblank cell on the worksheet. Delete this cell and all cells between it and the last row and column of your data then save.


Typical location
  C:\Program Files\Microsoft Office\Office12\

Issued By

  Windows XP

occurance meter

  Microsoft Corporation    
  Solutions and Fixes  
Formatting Causes
    Add    Flag
solution icon

There are quite a few solutions on other forums that reference official Microsoft help. None of that worked for me but I found a different solution - I was able to find out that it can occur due to formatting (i.e. if formatting is not standard, excel will think the cell is in use). So, in a nutshell, this problem can be solved by going row by row or column by column and testing different things.

My solution was that all of row 1 was merged into one cell so excel thought that the entire possible column with of the sheet was in use. Un-merging row 1 allowed me to add columns.

I discovered this because I thought, as a test, I'll wipe one column and see what happens. I selected all of column H (at random) and clicked Clear > Clear All (Home tab on the ribbon) and got the error 'cannot change part of a merged cell'. My sheet had no gridlines and the horizontal scroll bar wasn't tiny (as is the case when there are loads of columns) so it was not obvious that row 1 was merged but this test revealed that.

So, look for accidental/intentional changes in formatting that may cause the right-most column or bottom-most row to be 'activated'.

solves it indicator
risk indicator
effort indicator
Posted: 25-Jun-2012
Solutions Created: 1
  Forum Help  
Forums on topic

Check out what others say about this issue and review or add your own comments and solutions!

Go to Forums on topic.
  Vendor Summary  
  Microsoft Corporation (more info...)

Microsoft Corporation Logo



  Research this Issue  
Getting search results...
  While we believe this information up to date and accurate, FAQware is not responsible for any inaccuracies. If you find something that is out of date or inaccurate, please let us know at so we can correct it.  
Last update: 27-Jun-2011 3:25 pm