can not shift object off sheet

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top