Can't insert a row

[Jan]

I am unable to insert a row in a spreadsheet (2003 format but working on it
in 2007) - each time I get the message "Can't shift objects off sheet".

Don't know what objects this message is referring to, this is a simple sheet
with no macros or objects that I can see. Anyone know how to get round this
problem?

J

 

[excelent]

Ges there is som data way down near last row
try:

select first cell below data u dont wana delete in column A
hit [CTRL]+[END] to mark data
hit [DEL] to delete unknown data


"Jan" skrev:

 

[excelent]

sry. it was:

hit [CTRL]+[SHIFT]+[END] to mark data




"excelent" skrev:

Ges there is som data way down near last row
try:

select first cell below data u dont wana delete in column A
hit [CTRL]+[END] to mark data
hit [DEL] to delete unknown data


"Jan" skrev:

I am unable to insert a row in a spreadsheet (2003 format but working on it
in 2007) - each time I get the message "Can't shift objects off sheet".

Don't know what objects this message is referring to, this is a simple sheet
with no macros or objects that I can see. Anyone know how to get round this
problem?

J

 

[Jan]

Unfortunately this makes no difference!

sry. it was:

hit [CTRL]+[SHIFT]+[END] to mark data




"excelent" skrev:

Ges there is som data way down near last row
try:

select first cell below data u dont wana delete in column A
hit [CTRL]+[END] to mark data
hit [DEL] to delete unknown data


"Jan" skrev:

I am unable to insert a row in a spreadsheet (2003 format but working
on it
in 2007) - each time I get the message "Can't shift objects off sheet".

Don't know what objects this message is referring to, this is a simple
sheet
with no macros or objects that I can see. Anyone know how to get round
this
problem?

J

 

[excelent]

Maybe u have som shapes - drawings or som - delete them

u can use the tools "Select multible objekts" found in drawings menu


"Jan" skrev:

Unfortunately this makes no difference!

sry. it was:

hit [CTRL]+[SHIFT]+[END] to mark data




"excelent" skrev:

Ges there is som data way down near last row
try:

select first cell below data u dont wana delete in column A
hit [CTRL]+[END] to mark data
hit [DEL] to delete unknown data


"Jan" skrev:

I am unable to insert a row in a spreadsheet (2003 format but working
on it
in 2007) - each time I get the message "Can't shift objects off sheet".

Don't know what objects this message is referring to, this is a simple
sheet
with no macros or objects that I can see. Anyone know how to get round
this
problem?

J

 

[Jan]

There are no spades or drawings on the page. In fact every page in the
workbook gives the same message when trying to insert a row!!

Maybe u have som shapes - drawings or som - delete them

u can use the tools "Select multible objekts" found in drawings menu


"Jan" skrev:

Unfortunately this makes no difference!

sry. it was:

hit [CTRL]+[SHIFT]+[END] to mark data




"excelent" skrev:

Ges there is som data way down near last row
try:

select first cell below data u dont wana delete in column A
hit [CTRL]+[END] to mark data
hit [DEL] to delete unknown data


"Jan" skrev:

I am unable to insert a row in a spreadsheet (2003 format but
working
on it
in 2007) - each time I get the message "Can't shift objects off
sheet".

Don't know what objects this message is referring to, this is a
simple
sheet
with no macros or objects that I can see. Anyone know how to get
round
this
problem?

J

 

[Jesper Audi]

This problem was really getting to me but this article sorts it all out

http://office.microsoft.com/en-us/excel/HA102412411033.aspx

As a quick fix, try CTRL+6

Cheers Jesper