Ketika kita ingin menambahkan kolom baru tetapi tidak bisa,
kemudian muncul kotak dialog dengan pesan 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.
If you do not have data in cells that can be shifted off of the worksheet, you can reset which cells Excel considers nonblank. To do this, press CTRL+End to locate the last nonblank cell on the worksheet. Delete this cell and all cells between it and the last row and column of your data then save."
Solusi :
1. Tekan tombol CTRL + END, maka akan menuju ke shell yang terakhir pada worksheet kita.
2. Tekan tombol CTRL + ALT + Panah Atas, untuk memblok satu kolom terakhir, kemudia tekan tombol Delete
3. Tekan tombol CTRL + ALT + Panah Kiri, untuk memblok satu Baris terakhir, kemudia tekan tombol Delete
4. Kemudian lakukan Save File Excell
5. Close file Excell
6. Buka Kembali File Excell
7. Semoga beruntung...hehehehe
Sekian, Semoga bermanfaat!
Terima Kasih.
Tx--->rt
