Excel 2007 Can not insert row.

G

Guest

Excel 2007. When I try to insert a row, the following notation comes up:
"Can not shift objects off sheet". Never had that problem in Excel 2003,
2000 etc.
 
G

Guest

i don't know whether to call this a glitch or not. it has something to do
with cells having been merged.

go somewhere down the worksheet and delete several (or several hundred)
rows. this will allow you to insert rows.

don't make logical sense, but it works
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't insert a row 6
I can only delete an entire row not a cell in excel 2013? 1
Excel 2007 - Can't insert rows 1
Can't insert column 1
Locking only borders and patterns 2
edit insert dialogue box 1
Problem in inserting rows 1
Innsert a row in microsft excel 2007 - rows without borders 2

Top