Results 1 to 4 of 4

Thread: Can't insert cells in Excel

  1. #1
    Join Date
    Jun 2009
    Posts
    199

    Can't insert cells in Excel

    Hi, i am using MS office 2003. I have a worksheet on which i am trying to insert some column and rows. But excel is not allowing me to do so.It gives me a message saying, To prevent possible loss of data, Excel cannot shift non-blank cells off the worksheet. What is that ? How can i insert cells in this worksheet ?

  2. #2
    Join Date
    Feb 2009
    Posts
    455

    Re: Can't insert cells in Excel

    This error occurs when the option Nothing (hide objects) is selected in the Display options for this workbook section in the Excel Options dialog box. try this: Go to Advanced option and Scroll down to the Display options for this workbook section, and then click All under For objects, show and then click OK. Hope this will work and if not than it sound like the worksheet is in sharing. Just unshare it and try inserting cell. You can make it unshare, from Tools > Share Workbook.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,644

    Re: Can't insert cells in Excel

    it may be the cause of hidden cells in the worksheet.When you insert a column then Excel shifts columns right to the new column rightward deleting the last column because the total No of columns has to remain 256Excel cannot shift non-blank cells off the worksheet.Excel 2003 has a 65K row capacity and in Excel 2007 they pushed it up to 1M rows. This error means you insert rows, existing rows will have to be pushed off the maximum limit. This is done to prevent you from losing rows by mistake. Try to locate the last non-blank cell by pressing CTRL+END and delete or clear all cells in between the last cell and the end of your data. Then select cell A1 and save your workbook to reset
    the last cell used.

  4. #4
    Join Date
    May 2008
    Posts
    4,348

    Re: Can't insert cells in Excel

    Follow these steps:If you have used 4000 rows then clear the contents of row 1000 to 4000, Excel still thinks you are using 4000 rows. If the object is a cell comment, select the cell that contains the comment, right-click the cell, and then click Show Comment or Show/Hide Comments. Move the pointer to the edge of the object until the pointer changes into a white arrow with four small black arrows on the pointer. Then, click the object name on the Format menu.In the Format dialog box, click the Properties tab. Click Move and size with cells, and then click OK.

Similar Threads

  1. Format cells in Excel 2010
    By Morag T in forum MS Office Support
    Replies: 2
    Last Post: 17-03-2012, 11:17 AM
  2. How to add similar characters in Excel Cells
    By $horizon$ in forum MS Office Support
    Replies: 4
    Last Post: 08-02-2012, 03:10 PM
  3. How to renumber cells in Microsoft Excel
    By Weslee in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 04:25 PM
  4. Delete all Even cells in Excel
    By CAILYN in forum Windows Software
    Replies: 4
    Last Post: 24-06-2009, 11:26 PM
  5. Excel Numbering of identical cells
    By Bullnettles in forum Windows Software
    Replies: 6
    Last Post: 07-04-2009, 10:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •