ExcelBanter - Can't insert row

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can't insert row (https://www.excelbanter.com/excel-discussion-misc-queries/196527-re-cant-insert-row.html)

FARAZ QURESHI

Can't insert row

Is the sheet locked?

Check out ToolsProtectionUnprotect Sheet
--

Best Regards,
FARAZ A. QURESHI

"Jan" wrote:

I am unable to insert rows on a spreadsheet sent to me by a colleague - I
get a message each time "Cannot shift objects off sheet".

Don't know what object this message refers to, as far as I can see this is a
simple sheet with no macros or anything else. This is a spreadsheet saved
in 2003 format being used in Excel 2007.

Anyone know how to get round this?

Jan

Jesper Audi

Can't insert 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 08:37 AM.