Unable to Hide Clolumns

Hanz77

Board Regular
Joined
Sep 21, 2006
Messages
87
I'm currently working on a spreadsheet that extends from cell A1 to GY178. I'm trying to slim down the spreadsheet by hiding about 100 columns. So far I have hidden about 50 of the 100 columns; however, I am now receiving a "Cannot shift objects off sheet" error. I could understand getting this error if I were inserting a row or column, but I am simply trying to hide columns. So far I have deleted everything from columns GZ to IV and rows 179 to 65536 to shutting down Excel and started it back up again. I continue to get this error. Any other suggestions are appreciated.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Forum statistics

Threads
1,214,971
Messages
6,122,520
Members
449,088
Latest member
RandomExceller01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top