Solusi Excel ‘Cannot shift objects off sheet’ error message

5 11 2014

Problem:

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

Aksi

Information

Tinggalkan Balasan

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

Logo WordPress.com

You are commenting using your WordPress.com 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: