Using your phone's internet browser
go to:  qna.rediff.com
Click and drag this link to
the Home icon in your browser.
Q.

How can i solve this problem, which is occurs in my excel sheet, how can i remove this problem

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

Tags: problem, money, relationships
Asked by jaya singh, 11 May '10 04:41 pm
  Invite a friend  |  
  Save  |  
 Earn 10 points for answering
Answer this question  Earn 10 points for answering    
4000 characters remaining  
  
    
Keep me signed inNew User? Sign up

Answers (2)

1.

Hope this solves your problem, Jaya.

The "Cannot shift objects off worksheet" message occurs when you attempt to insert rows or columns in a worksheet, and the option Nothing (hide objects) is selected under the For objects, show section in the Excel Options dialog box. This is a known bug in Microsoft Office Excel 2007. Although this option is not selected by default, it's possible to set it accidentally by pressing a particular keyboard shortcut (CTRL+6).
To work around the bug, you must change the setting from Nothing (hide objects) to All. The fastest way to do this is by pressing CTRL+6.
Alternatively, you can change the setting in the Excel Options dialog box. To do so, click the Microsoft Office Button , and then click Excel Options. On the Advanced tab, scroll to Display options for this workbook settings. Under 'For objects', show, select All instead of Nothing (hide objects).

It may be that you intentionally hid objects in your workbook. For example, if you have a l ...more
Answered by QueSera Sera, 11 May '10 04:57 pm

 
  
Report abuse
Useful
 (0)
Not Useful
 (0)
Your vote on this answer has already been received
2.

Tell me clearly.
Answered by shikha, 11 May '10 04:42 pm

 
  
Report abuse
Useful
 (0)
Not Useful
 (0)
Your vote on this answer has already been received

Ask a Question

Get answers from the community

600 characters remaining

Related Answer

Q.
A

Yes a good question , When you read you may not read it deeply , when you write what you read or copy , you have good chance to concentrate and get it..more