View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
C Brandt C Brandt is offline
external usenet poster
 
Posts: 92
Default Is there a limitation on the amount of data that can be hidden?

Found the problem to be a "comment box" associated with a cell to the right
end of the active spread sheet was actually located waaaay over to the
right, near the end of the physical spreadsheet (column IV). Once I
reposition the comment box near the accociated cell, the program worked just
fine.

Thank you John Bundy for your help. I would never have associated the
problem with comment without you lead.

Craig


"C Brandt" wrote in message
...
Hi Guys;
Running Excel 2000.
I ran into a problem when I tried to hide data (columns).
Working a spread sheet that is 151 columns wide by 765 rows high. In order
to make navigating and working the sheet easier, I decided to use the Hide
Columns feature to set aside column that were not pertenate to the task at
hand.
When I tried to hide the 84th column I get the message "Cannot shift

objects
off sheet"
Does anyone have an idea what causes this error and if there is a simple
work-around?

Any assistance would be greatly appreciated,
Craig