I highlight the cells I wish to hide by dragging the mouse across the column
headings, rightclick and choose the hide option, I have only got to cells BU
at present before I get the "cannot shift" error message

regards Craig

"bj" wrote in message
...
How are you hiding the columns?

It sounds like you might be adding columns or moving cells to the right to
hide them from the view.
If you have items in Column IV you can not do this.

If you are doing it as<format<columns<hide
about howmany times do you do it before you have the problem.
(I cant make it happen on my computer)

If you are doing it another way, What is it?

"craig" wrote:

I have a spreadsheet that is setup columns A-IV and need to hide columns
but
after a while get the message "cannot shift cells off sheet"

any ideas its driving me nuts

Regards
Craig