Can’t push objects off the sheet Error in Excel

I recently had an error pop up when working with a client’s file. The client’s file had a macro that would hide most of the columns on the sheet, but it had started to generate an error message.

A similar structure to the file can be seen in the image below.

As you can see the combo box drop down is slightly going into column D. That is what caused the problem. Hiding all the columns from D across will generate the error below.

If an object, image, or a graphic is showing above a certain column you have to ensure that the spreadsheet has enough room to display that graphic.

In the video below I demonstrate the problem and the solution.

If you don’t want to watch the video just resize the object or move the object to avoid the problem.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.