another "to prevent possible loss of data, Microsoft Excel cannotshift nonblank cells off the worksheet."
I know many people have had similar issues in Excel. I tried
recommendations that I have found posted here, but I still cannot get this to work. I have a pretty large excel file with columns out to EM (but no where near the IV limit). If I either try to insert columns, or if I try to take a column and cut and past it to another location on the sheet I get the message saying Excel cannot do it because of the possible loss of data. I do not have any objects or comments in any of my cells, or anywhere on the sheet for that matter. I do have some formatting in the very last column. However, if I select the entire last column (or even the last several columns) and right click on them and hit delete and completely delete the entire column(s) I still get the message. I don't understand why even having data in the last column would prevent cutting and insert columns on the same sheet because nothing would actually shift off of the sheet, it should only shift between where the one column is cut and where it is inserted into. Thanks for your help, David |
another "to prevent possible loss of data, Microsoft Excel cannotshift nonblank cells off the worksheet."
However, if I select the entire last column (or even the
last several columns) and right click on them and hit delete and completely delete the entire column(s) I still get the message. What if instead of right click delete you Edit|Clear All? Ken Johnson |
another "to prevent possible loss of data, Microsoft Excel cannotshift nonblank cells off the worksheet."
On Feb 21, 4:14 pm, Ken Johnson wrote:
However, if I select the entire last column (or even the last several columns) and right click on them and hit delete and completely delete the entire column(s) I still get the message. What if instead of right click delete you Edit|Clear All? Ken Johnson I do not see "Clear All" under the edit menu. However, if I right click there is a "Clear Contents". I have tried this as well and I still get the error. I'm using Excel 2003 |
another "to prevent possible loss of data, Microsoft Excel cannotshift nonblank cells off the worksheet."
I do not see "Clear All" under the edit menu. That's odd, when I pull down the Edit menu then go to Clear, four options become available... All Formats Contents Del Comments I too am using xl2003. Ken Johnson |
All times are GMT +1. The time now is 08:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com