cannot shift objects off sheet after using Subtotals

[RealGomer]

I have a spreadsheet that, after running Subtotals from the Data menu,
returns the error message "Cannot shift objects off sheet" when I try to
condense the spreadsheet. There are no comments on the spreadsheet. I
selected all cells and pressed "Delete". The susbtotal range is below any
text. After running Subtotals, there are a total of 2,374 roows. What gives?
--
I know enuff to be dangerous.

[SVC]

Another possibility is that you might already have the maximum number of
columns (not rows). Hit Ctrl+End and see where you end up. If it is in
column IV, there is the problem--remove any unneeded columns.

"RealGomer" wrote:

> I have a spreadsheet that, after running Subtotals from the Data menu,
> returns the error message "Cannot shift objects off sheet" when I try to
> condense the spreadsheet. There are no comments on the spreadsheet. I
> selected all cells and pressed "Delete". The susbtotal range is below any
> text. After running Subtotals, there are a total of 2,374 roows. What gives?
> --
> I know enuff to be dangerous.

[SVC]

Actually, I got myself turned around in my initial response. Try Ctrl+End
and see what row you end up in. You may have something in the last possible
row (possibly a space in a cell). Also see if, by removing several rows, you
can add subtotals.

"RealGomer" wrote:

> I have a spreadsheet that, after running Subtotals from the Data menu,
> returns the error message "Cannot shift objects off sheet" when I try to
> condense the spreadsheet. There are no comments on the spreadsheet. I
> selected all cells and pressed "Delete". The susbtotal range is below any
> text. After running Subtotals, there are a total of 2,374 roows. What gives?
> --
> I know enuff to be dangerous.

[Lou]

Did you solve your problem, if so please tell me what to do. I have the same
error .

"RealGomer" wrote:

> I have a spreadsheet that, after running Subtotals from the Data menu,
> returns the error message "Cannot shift objects off sheet" when I try to
> condense the spreadsheet. There are no comments on the spreadsheet. I
> selected all cells and pressed "Delete". The susbtotal range is below any
> text. After running Subtotals, there are a total of 2,374 roows. What gives?
> --
> I know enuff to be dangerous.

[hackneymn]

Did anyone solve this problem?
I have exactly the same issue - I have checked the end of the spreadsheet
and its not in column IV. I have also deleted all rows and columns beyond the
range of the sheet but still get the error mesage.
Interestingly I still get the error message when I try to hide a column.
Also is the mention of "objects" significant?

"Lou" wrote:

> Did you solve your problem, if so please tell me what to do. I have the same
> error .
>
> "RealGomer" wrote:
>
> > I have a spreadsheet that, after running Subtotals from the Data menu,
> > returns the error message "Cannot shift objects off sheet" when I try to
> > condense the spreadsheet. There are no comments on the spreadsheet. I
> > selected all cells and pressed "Delete". The susbtotal range is below any
> > text. After running Subtotals, there are a total of 2,374 roows. What gives?
> > --
> > I know enuff to be dangerous.

[Drusiel]

I've got that same problem when I try and hide columns. Having so much
trouble sorting it! >_<

"hackneymn" wrote:

> Did anyone solve this problem?
> I have exactly the same issue - I have checked the end of the spreadsheet
> and its not in column IV. I have also deleted all rows and columns beyond the
> range of the sheet but still get the error mesage.
> Interestingly I still get the error message when I try to hide a column.
> Also is the mention of "objects" significant?
>
> "Lou" wrote:
>
> > Did you solve your problem, if so please tell me what to do. I have the same
> > error .
> >
> > "RealGomer" wrote:
> >
> > > I have a spreadsheet that, after running Subtotals from the Data menu,
> > > returns the error message "Cannot shift objects off sheet" when I try to
> > > condense the spreadsheet. There are no comments on the spreadsheet. I
> > > selected all cells and pressed "Delete". The susbtotal range is below any
> > > text. After running Subtotals, there are a total of 2,374 roows. What gives?
> > > --
> > > I know enuff to be dangerous.