Hiding Cells in Excel

segran

Active Member
Joined
Aug 20, 2004
Messages
335
Hi All

I am experiencing the following problem, when I try to hide a few cells in excel. I get an error message: "cannot shift objects off sheet".
Please advise what I should do.

Thank you
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
what are you trying to do?

in Excel you can hide rows, or columns, but not cells. Maybe there is another way that would work for you.
 
Upvote 0
I am trying to hide a few cells. This is the first time, I am encountering this problem.
 
Upvote 0
segran

Please set out CLEARLY the steps that you are performing that ends up with the error message.
 
Upvote 0
Sorry, no object/button. Its just an enigma!
All I am doing is, selecting the rows I want hidden, and I right-click, and select HIDE.
 
Upvote 0
Are there comments on your sheet? Those buggers are a usual suspect for that message as well.
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,184
Members
448,554
Latest member
Gleisner2

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