4 Convert Excel Sheets to Word In Microsoft Excel 2010, you can create large tables in which to store your data and then use it in formulas and store the results in the same table. The Selection Pane in Excel can enables you to hide or show all or partial objects in active worksheet. 1.Click Home > Find & Select > Selection Pane to open the Selection Pane.See screenshot: 2.After opening the Selection and Visibility task pane, all of the objects in the active sheet have been listed in the pane. If you want to hide all of the objects, you just need to click Hide All button.
Excel 2013 Excel 2010 Excel 2007 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. Issue Why it happens, and what to do about it You can't insert rows or columns 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 Excel options. This is a known bug in some versions of Excel.
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 Excel options. To do so,.
Click File Options Advanced. Note: In Excel 2007, 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.
You can't insert or hide columns If the 'Cannot shift objects off worksheet' message (or a similarly worded message) continues to appear even after applying the previous resolution, it may be because there are objects such as comments, images, or charts in cells toward the end of the worksheet grid. The amount of columns you can hide or insert is limited to the amount of columns between the right edge of the object and the last column on the worksheet (column XFD).
If the number of columns that you want to hide or insert anywhere else on the worksheet is larger than that number, the object will be moved off the worksheet, and you will see the message. Generally speaking, you can fix this issue by finding the offending object and either deleting it or moving it further away from the end of the worksheet.
Here are a few tips for finding objects:. To quickly move to the last cell in a row or column, press END, and then press the RIGHT ARROW key or the DOWN ARROW key. To go to the last cell on the worksheet that contains data or formatting, click CTRL+END.
To quickly find and remove comments, press F5. In the Go To dialog box, click Special. Select Comments, and then click OK. To delete the comment, right-click the cell containing the comment, and then click Delete Comment. To quickly find graphical objects, including charts and buttons, press F5. In the Go To dialog box, click Special.
Select Objects, and then click OK. Once you've found the object, you can delete or move it.