Solusi Excel ‘Cannot shift objects off sheet’ error message

5 11 2014


When attempting to insert a new row in an Excel document you recieve an error message saying ‘Cannot shift objects off sheet’ and Excel fails to add the new row.

Excel 2007

  1. With the Excel document open
  2. Select the ‘Office’ menu followed by ‘Excel Options’
  3. Excel2007-r1c1-1
  4. Select the ‘Advanced’ menu
  5. Scroll down to ‘Display options for this workbook’
  6. Under ‘For objects, show’ select ‘All’
  7. MSExcel2007-CannotShift4
  8. Click ‘OK’ to save the changes



Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:


You are commenting using your account. Logout /  Ubah )

Foto Google+

You are commenting using your Google+ account. Logout /  Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout /  Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout /  Ubah )


Connecting to %s

%d blogger menyukai ini: