saya pernah mengalami spt ini...... kayaknya ikuti saja petunjuknya pada kolom terakir tekan CTR+End+tanda panah kekanan
kemudian stelah kolumn2 kosong itu terBlock tekan Delete Column begitukah ? wallahuaklam ________________________________ Dari: prabowoseptyobimo <[email protected]> Kepada: [email protected] Dikirim: Kamis, 8 November 2012 17:13 Judul: [belajar-excel] Tidak bisa menambah colum di spread sheet excel kebetulan ada spreadsheet yang telah jadi, lalu ingin di modifikasi, dengan menambahkan beberapa colum di tengah tengah ternyata tidak bisa, muncul textbox bertuliskan : 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 form the end of your worksheet. if you do not have data in cells that can be shifted off the worksheet, you can reset which cells ecxcel considers nonblank. to do this CTRL+End to locate the last nonblank cell on the worksheet. delete this cell and all cells between it and the last row and colum of your data then save kalau seperti ini bagaimana menambahkan colum kedalam sheet ....
