Is there a limitation on the amount of data that can be hidden?

  • Thread starter Thread starter C Brandt
  • Start date Start date
C

C Brandt

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy hidden sheet data 2
reading data from hidden sheet 4
Is there a maximum number of non-contiguous columns that can be h. 6
data on hidden sheets 1
hide formula in cells till data is available for calc 1
Macro that will hidden columns, rows and worksheets based on an identifier 2
how can I hide the contents of a cell so others cannot see it 6
sorting lardge amount of data 3

Back
Top