Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't insert a row
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't insert a row
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't insert a row
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't insert a row
Unfortunately this makes no difference!
"excelent" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't 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! "excelent" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't insert a row
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!! "excelent" wrote in message ... 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! "excelent" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't insert a row
This problem was really getting to me but this article sorts it all out
http://office.microsoft.com/en-us/ex...412411033.aspx As a quick fix, try CTRL+6 Cheers Jesper |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
insert row / insert column command buttons | Excel Worksheet Functions | |||
How can I insert a date with an icon (calendar) insert | Excel Discussion (Misc queries) | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) |