can not shift object off sheet

G

Guest

Over sudden I was trying o insert a row I had an error Can not shift objects
off sheet would you please help me solving this problem?


best regards

abdurraouf
 
N

Nick Hodge

abdurraouf

Although you can see nothing there is actually data Excel thinks it has at
row 65536 (XL97-2003). This often happens by selecting entire rows and doing
stuff

To fix, highlight the entire rows from 65536 to the last row where you have
data (Click on label for 65536 and hold shift key down and click on label
for last row with data), now select edit>delete. It appears to do nothing
but now save the file (versions before 2000 shut excel and re-open) and all
should be well

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 

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

Top