ExcelBanter - Hiding Columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hiding Columns (https://www.excelbanter.com/excel-discussion-misc-queries/30728-hiding-columns.html)

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

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

--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=379174

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

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" wrote in
message ...

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

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

--
belony
------------------------------------------------------------------------
belony's Profile: http://www.excelforum.com/member.php...o&userid=24311
View this thread: http://www.excelforum.com/showthread...hreadid=379174