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 |
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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com