Excell Error : Tidak Bisa Menambahkan Baris Baru (New Row) Di File Excell

__________________________________

TERIMA KASIH TELAH BERKUNJUNG TEMAN !
SEBELUM MELANJUTKAN MEMBACA, TOLONG SUBSCRIBE KE CHANNEL YOUTUBE SAYA YA KAWAN.
CARANYA KLIK TOMBOL MERAH DIATAS.
____________________________________________________________________________________________________________________________________
________________________

Pada saat akan memasukkan sebuah baris baru ke dalam file excell, muncul pesan berikut ini :

To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet. Select another location in which to insert new cells, or delete data from the end of your worksheet.

Seperti terlihat pada gambar berikut.

 Solusi :

1. Letakkan cursor dibaris terakhir dari berkas (file) yang bermasalah (error) tersebut, misal posisi kursor di baris 45.
   
   
   
   
   
2. Tekan "CTRL+End", maka kursor akan berpindah ke posisi baris terakhir (baris 65536).
   
   
   
   
   
3. Klik kolom paling kiri (kolom indeks) pada baris 65536, kemudian scroll keatas, selanjutnya sambil menekan tombol shift tekan kolom index baris 45 sehingga seluruh baris dan kolom dari baris 65536 hingga baris 45 akan terseleksi.
4. Kemudian klik pada sembarang area di baris-baris yang telah terseleksi tersebut, pilih "Delete".
   
   
   
   
   
5. Save & Close.
6. Kemudian buka kembali file tersebut dan coba tambahkan baris baru, maka tidak akan muncul masalah lagi.

Referensi : http://www.wizardofexcel.com/2011/08/03/unable-to-insert-columns-solved/

Unable to insert columns [solved]Posted on August 3, 2011 by Dan   

Sometimes you'll encounter a spreadsheet that doesn't allow you to insert a new column. When you try, it will give you the following error:
 
To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet. Select another location in which to insert new cells, or delete data from the end of your worksheet.

I adore its use of the "off of" artificial construct.

It's basically saying that there's something at the far right of your worksheet (column IV pre–Excel 2003; column XFD thereafter), or else at the very bottom (row 65,536 pre–Excel 2003; row 1,048,576 thereafter).

Often you don't know why it's happened, and you can't find any data anywhere near those extremes. Here's how to solve it.

1. Find the last column in which data appears (column AQ, say)
2. Highlight the next column to the right (column AR)
3. CTRL+Shift+Right
4. ALT, E, A, A.

This last step is an old shortcut that still works to this day. In earlier versions of Excel, it selected Edit | Clear | All. Essentially, it gets rid of the contents and formats of all cells highlighted.

The equivalent steps to sort out the rows are:

1. Find the last row in which data appears (row 100, say)
2. Highlight the subsequent row (row 101)
3. CTRL+Shift+Down
4. ALT, E, A, A.

To allow you to insert rows and columns, you'll need to save your spreadsheet and, in true Microsoft style, close it and open it up again. Now you should be able to add columns and rows to you heart's content.

BERIKUT INI VIDEO NYA DI YOUTUBE: LINK