Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How come it say "Microsoft Excel cannot find any data to replace"? | Excel Discussion (Misc queries) | |||
Error message "cannot shift nonblank cells off the worksheet" | Excel Discussion (Misc queries) | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
Standard font in a "New Microsoft Excel Worksheet.xls" wont change | Excel Discussion (Misc queries) | |||
Would like to change all "yes" cells in a worksheet with "logged" | Excel Programming |