Solved

to prevent possible loss of data, excel cannot shift nonblank cells off the worksheet.

Posted on 2013-02-06
1
9,232 Views
Last Modified: 2013-02-11
When I go to insert cells I often get an error message saying:

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

I am using 2010. When I was using 2003 this never happened.

If I select End/Down Delete and then save the workbook it lets me insert the row.

Is there a way to stop this?

Thanks
0
Comment
Question by:Jagwarman
1 Comment
 
LVL 24

Accepted Solution

by:
Steve earned 500 total points
ID: 38859005
It would appear that you have "something" which excel seems to think is in all cells.

If you go to the end of the data and then highlight the next row down (first blank row).
then [ctrl]+[down]
then [ctrl]+[minus]

This will delete all blank rows (making sure that the rows are blank)
This should stop the behaviour.

If it doesn't, you may need to post a copy of the file for us to diagnose.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question