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 )

Gambar Twitter

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

Foto Facebook

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

Foto Google+

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

Connecting to %s

%d blogger menyukai ini: