Sometimes, the following message prevents you from inserting or hiding columns or rows in a worksheet.
If you see this message, refer to the following table for possible solutions.
To fixed 1:
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 lot of objects in your
workbook, opting to hide those objects may make the workbook more
responsive. If that's the case, you can use the keyboard shortcut
(CTRL+6) to switch between hiding and showing objects.
Credit: Microsoft Help
Subscribe to:
Post Comments (Atom)
Post a Comment
Silahkan anda tulis komentar di bawah ini !