Insert a row

G

Guest

I recently installed Excell 2007 . I want to insert a row or column in a
converted file.
When I try to insert either a row or column, I get the meesage "cannot shift
object off sheet". The sheet is all data. I have not formatted it yet. What
can I do to insert a row or column?
 
G

Guest

Press the F5 key, click on the Special button, check Objects and click on OK.

If there are any objects on the sheet they will be selected. You can simply
delete it/them since you say there shouldn't be any.

Then you should be able to insert
 

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

insert blank row and formulas 1
insert row / insert column command buttons 1
Need Formula to Find a Match and Then Insert Some Characters 4
Auto insert a comment box. 1
How do I create IF function that inserts cells when condition is m 1
How do I "insert copied cells"? used to be "alt i e" still work 1
SUM Char 9
Insert row with a locked cell 1

Top