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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
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.
 

segran

Active Member
Joined
Aug 20, 2004
Messages
335
I am trying to hide a few cells. This is the first time, I am encountering this problem.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,700
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

segran

Please set out CLEARLY the steps that you are performing that ends up with the error message.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Do you have a drawing object or button etc on one of the cells you are trying to hide?
 

segran

Active Member
Joined
Aug 20, 2004
Messages
335

ADVERTISEMENT

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.
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,016
Office Version
  1. 365
Are there comments on your sheet? Those buggers are a usual suspect for that message as well.
 

Forum statistics

Threads
1,141,931
Messages
5,709,403
Members
421,635
Latest member
mehdi hannechi

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
Top