spacer spacer spacer
 
 
  arrow Sample Dialog
  arrow Key Facts
  arrow Solutions
  arrow Forum Help
  arrow Vendor Summary
  arrow Research this Issue
  help Solutions Help
 
 
box_image
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!
 
  Fix-It Utilities
Make your PC run like new! Includes Anti-Virus, Anti-Spyware, hardware diagnostics, registry fixer, and more!
box_image  
 
 
box_image
RadarSync
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.

100184 

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

 
Issued By
  EXCEL.EXE

 
OS
  Windows XP

occurance meter
 
Type
  error 

   
Vendor
  Microsoft Corporation    
 
   
  Solutions and Fixes  
     
 
Formatting Causes
8
    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'.

 
   
 
transparent
transparent
solves it indicator
risk indicator
effort indicator
 
  grenvold
Posted: 25-Jun-2012
Solutions Created: 1
 
Avatar
 
 
 
  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  
     
 
Vendor
  Microsoft Corporation (more info...)

Microsoft Corporation Logo
Phone
1-425-882-8080
1-800-642-7676

Web
Global
USA

Assistance
Support
Downloads

 
   
  Research this Issue  
     
 
Getting search results...
 
     
  Notes  
     
  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