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
Asked by jaya singh,
11 May '10 04:41 pm
Earn 10 points for answering
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
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
Report abuse
Useful
(0)
Not Useful
(0)
Your vote on this answer has already been received
2.
Report abuse
Useful
(0)
Not Useful
(0)
Your vote on this answer has already been received