Dear Master Excel,

Dari tabel di bawah, jika kita menempatkan cell pada B4 kemudian menekan tombol 
Ctrl+D, maka cell B4 akan terisi James NB Luhu Lima.
Short cut apa jika cell B4 bisa terisi Tien Tini Suhartono?

  A B C D E 
1 /CF/1/12/1 Mulyono OR 23926A 5463/CF/1/12/1 
2 /CF/9/12/1 Nurjani Wati OR 23993A 5467/CF/9/12/1 
3 /CF/6/12/1 James NB Luhu Lima OR 24368A 5470/CF/6/12/1 
4   Consumer Installment Rec. Housing ES 221437 5472/CF/7/12/1 
5 /CF/7/12/1 Tien Tini Suhartono OR 24047A 5472/CF/7/12/1 
6 /CF/2/12/1 Joko Amperayanto OR 24370A 5473/CF/2/12/1 
7   Consumer Installment Rec. Housing ES 221434 5476/CF/2/12/1 
8 /CF/2/12/1 Jefry Ronny Saragih OR 24113A 5476/CF/2/12/1 
9 /CF/2/12/1 Jefry Ronny Saragih OR 24547A 5476/CF/2/12/1 
10 /CF/2/12/1 Jefry Ronny Saragih OR 23985A 5476/CF/2/12/1 

Atas jawaban para master diucapkan terima kasih.

Salam,

Djaja.

Kirim email ke