Error msg when attempting to hide columns..


Sheryl Lang

I have a worksheet that out to column "IC" and goes down
about 1200 rows. When I attempt to hide columns (to make
a print job easier) I get an error message that
says "cannot shift objects off page".

I found references in the knowledge base that instructed
me to format any comments to move and size with cell. I
did that and I still get the same error message. We are
not able to manually hide columns either (cannot set
column width to zero, and cannot 'slide' column down).

The only way around if for me has been to cut and paste
the entire worksheet (as values) into another file and
then format it for printing. It's a nightmare since I
have been updating the data regularly and I have to
manually format the report for printing each time.

Any ideas??



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