Hiding Columns

[belony]

Hi,
I am new to this forum. I hope someone can help me.
I have a workbook to which I add a sheet every pay period. Actually, I copy the sheet from the previous week and make a new, additional sheet at the end of the workbook.
I use these sheets for batching the current payroll information and link past columns to new. I do not remove any old info from the new copied sheet, but I add 10 new columns to each sheet each time I copy. I tell you all of this in case it helps with my problem.
My new sheet will not allow me to hide the columns I don't need to see.
The Error message is "CANNOT SHIFT OBJECTS OFF SHEET".
I have been hiding columns for years and years and have never gotten any error message, much less on like this. Can anyone out there help??
Thanks so much.

[dominicb]

Good evening Belony

It sounds as though you have an object (a button, an autoshape, a textbox etc) at the end of the worksheet, and Excel will not let this item be "bumped off" the end of the sheet. Go to column IV and scroll down looking for anything unusual. Delete it and your problem should be solved.

HTH

DominicB

[Gord Dibben]

Do you have any objects such as cell comments?

See this KB article for assistance.

http://support.microsoft.com/default...b;en-us;211769


Gord Dibben Excel MVP

On Tue, 14 Jun 2005 17:13:14 -0500, belony
<[email protected]> wrote:

>
>Hi,
>I am new to this forum. I hope someone can help me.
>I have a workbook to which I add a sheet every pay period. Actually, I
>copy the sheet from the previous week and make a new, additional sheet
>at the end of the workbook.
>I use these sheets for batching the current payroll information and
>link past columns to new. I do not remove any old info from the new
>copied sheet, but I add 10 new columns to each sheet each time I copy.
>I tell you all of this in case it helps with my problem.
>My new sheet will not allow me to hide the columns I don't need to see.
>
>The Error message is "CANNOT SHIFT OBJECTS OFF SHEET".
>I have been hiding columns for years and years and have never gotten
>any error message, much less on like this. Can anyone out there help??
>Thanks so much.

[Alan]

You get this if the sheet is full, ie either the columns reach the last one
which is IV or the rows go to 65536 which is the last row available in
Excel. The only way I think is to archive some of the data and delete it
from your sheet.
That said, there may not be data in all these cells but XL may think there
is. Try Ctrl End to find the actual last column and row then if the last
column were say GP, in the name box type GQ:IV and delete (not Clear
Contents) all those rows. Similarly if the last row is 16554, in the name
box enter 16555:65536 and delete all those rows. Save, Exit and reopen and
that should do it.
Do this on a copy of your file to avoid any possible corruption of the
original,
Regards,
Alan.
Regards,
Alan.
"belony" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
> I am new to this forum. I hope someone can help me.
> I have a workbook to which I add a sheet every pay period. Actually, I
> copy the sheet from the previous week and make a new, additional sheet
> at the end of the workbook.
> I use these sheets for batching the current payroll information and
> link past columns to new. I do not remove any old info from the new
> copied sheet, but I add 10 new columns to each sheet each time I copy.
> I tell you all of this in case it helps with my problem.
> My new sheet will not allow me to hide the columns I don't need to see.
>
> The Error message is "CANNOT SHIFT OBJECTS OFF SHEET".
> I have been hiding columns for years and years and have never gotten
> any error message, much less on like this. Can anyone out there help??
> Thanks so much.
>
>
> --
> belony
> ------------------------------------------------------------------------
> belony's Profile:
> http://www.excelforum.com/member.php...o&userid=24311
> View this thread: http://www.excelforum.com/showthread...hreadid=379174
>

[belony]

Thank you, Thank You.

You are all awesome.I got my spreadsheet to work. This is a great resource.
I hope I will be able to return the favor very soon.

Again Thanks so much to you all.

Belony