Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel cannot shift nonblank cells
I have an Excel sheet where I try to insert columns. I get the error that
says that Excel cannot shift nonblank cell off the worksheet. But there are tons of empty cells to the rigth of my data starting at column BC.... If I save my worksheet I can insert one, two, three columns before I get the same error again. I save again and I can insert one or two more.... It's painfull especially when I try to do this in a macro. I can't be saving between each column insertion !!! Excel 2002 (10.6501.6626) SP3 |
#2
|
|||
|
|||
The Microsoft KB offers a solution he
Error message: To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet http://support.microsoft.com/default.aspx?scid=305568 HTH Jason Atlanta, GA -----Original Message----- I have an Excel sheet where I try to insert columns. I get the error that says that Excel cannot shift nonblank cell off the worksheet. But there are tons of empty cells to the rigth of my data starting at column BC.... If I save my worksheet I can insert one, two, three columns before I get the same error again. I save again and I can insert one or two more.... It's painfull especially when I try to do this in a macro. I can't be saving between each column insertion !!! Excel 2002 (10.6501.6626) SP3 . |
#3
|
|||
|
|||
Have a read at this KB article for a possible solution.
http://support.microsoft.com/default...b;en-us;211769 BTW. Are you sure the columns are actually blank? Select all columns to the right of BC and EditDelete(note....delete, not clear contents). Save and close to reset the used range. Gord Dibben Excel MVP On Thu, 17 Mar 2005 13:01:02 -0800, "Mr. Maz." <Mr. wrote: I have an Excel sheet where I try to insert columns. I get the error that says that Excel cannot shift nonblank cell off the worksheet. But there are tons of empty cells to the rigth of my data starting at column BC.... If I save my worksheet I can insert one, two, three columns before I get the same error again. I save again and I can insert one or two more.... It's painfull especially when I try to do this in a macro. I can't be saving between each column insertion !!! Excel 2002 (10.6501.6626) SP3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting nonblank and non white space cells | Excel Worksheet Functions | |||
How do I get custom colors for filling cells in Excel? | New Users to Excel | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions |