Can't hide far right columns:"Shift objects off sheet"??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 12 Mar 2007 23:30 GMT

I've got some constants and such in the far right-most columns, where
my average user wouldn't have any need of going. Just to add an extra
measure of safety, though, I wanted to either hide the columns or set
the column width to something like 0.1. Excel won't let me do either
- the error message is "Can't shift objects off the sheet." But there
are no "objects" - just values in cells. What am I looking at? Is
there another way to accomplish this?

Ed

Reply to this Message

Joerg - 14 Mar 2007 04:03 GMT

Which version? Should be no problem in XL2003.
BTW: Far right is not a good solution since it inflates your Used Range. You
might pay a heavy price in terms of file size. Better use "nearer" cells or
a dedicated hidden page.

You can also define your constants without using any cells: Just use Insert
=> Name = Define. Into the box "Names in Workbook" input a name for your
constant (e.g. "rate"), into the box "Refers to" input the value of the
constant (e.g. "=1.3"). Press "OK" and now you can use your named constant
in your worksheet as usual (e.g. "=3*rate").

Cheers

Joerg Mochikun

> I've got some constants and such in the far right-most columns, where
> my average user wouldn't have any need of going. Just to add an extra
[quoted text clipped - 5 lines]
>
> Ed

Reply to this Message

Dave Peterson - 14 Mar 2007 15:25 GMT

Maybe...

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?scid=kb;en-ca;211769

Remember to look for comments and merged cells.

> I've got some constants and such in the far right-most columns, where
> my average user wouldn't have any need of going. Just to add an extra
[quoted text clipped - 5 lines]
>
> Ed

Signature

Dave Peterson

Reply to this Message

Ed - 14 Mar 2007 16:26 GMT

Thanks, Dave. That did the trick. I did have some merged cells, but
they posed no problem, so I assume it was the comments.

Ed

> Maybe...
>
[quoted text clipped - 15 lines]
>
> Dave Peterson

Reply to this Message