Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Can't insert cells in Excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-06-2009
Member
 
Join Date: Jun 2009
Posts: 197
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 ?

Reply With Quote
  #2  
Old 06-06-2009
Member
 
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.
Reply With Quote
  #3  
Old 06-06-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
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.
Reply With Quote
  #4  
Old 06-06-2009
Member
 
Join Date: May 2008
Posts: 4,339
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Can't insert cells in Excel"
Thread Thread Starter Forum Replies Last Post
Format cells in Excel 2010 Morag T MS Office Support 2 17-03-2012 12:17 PM
How to add similar characters in Excel Cells $horizon$ MS Office Support 4 08-02-2012 04:10 PM
How to renumber cells in Microsoft Excel Weslee MS Office Support 2 24-01-2012 05:25 PM
Delete all Even cells in Excel CAILYN Windows Software 4 25-06-2009 12:26 AM
Excel Numbering of identical cells Bullnettles Windows Software 6 07-04-2009 11:51 AM


All times are GMT +5.5. The time now is 01:27 PM.