ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I'm trying to add columns and getting errors (https://www.excelbanter.com/excel-worksheet-functions/205313-im-trying-add-columns-getting-errors.html)

KimB

I'm trying to add columns and getting errors
 
I am working on a very large spreadsheet, grouping columns. I am trying to
add additional columns and keep getting the error " Cannot Shift Objects off
sheet".
I don't want to delete any of the columns, but how do I get past this error
and what does it mean?

John C[_2_]

I'm trying to add columns and getting errors
 
xl2003 has a limit of 256 columns. It sounds as if you are trying to create
more columns by inserting a new column than excel can handle. Unfortunately,
you can't. You will either need to split the sheet into 2 worksheets, or get
xl2007, which has significantly more columns.
--
John C


"Kimb" wrote:

I am working on a very large spreadsheet, grouping columns. I am trying to
add additional columns and keep getting the error " Cannot Shift Objects off
sheet".
I don't want to delete any of the columns, but how do I get past this error
and what does it mean?


muddan madhu

I'm trying to add columns and getting errors
 
check it here

http://support.microsoft.com/default...&Product=xlw2K



On Oct 7, 1:42*am, Kimb wrote:
I am working on a very large spreadsheet, grouping columns. *I am trying to
add additional columns and keep getting the error " Cannot Shift Objects off
sheet".
I don't want to delete any of the columns, but how do I get past this error
and what does it mean?




All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com