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
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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
46,837
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
7,984
Are there comments on your sheet? Those buggers are a usual suspect for that message as well.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,990
Messages
5,545,365
Members
410,679
Latest member
rolandbianco
Top