1. Blok sel C3, D3 dan E3, kemudian klik tombol merger (lihat panah merah)
![format sel](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8jJU3hJXyKIu0gUIOHaCNQdgkf3hgMldDgN1RXlPFNAQFsIgB6TtSnbJtsnuo5JlahP_edxm-IeuKM8wj_J20eBJg4iGfzanHdgIcG3Wm9EoZXqK9GL_S9-r9So13RQDE3ik7ygKQuYI/s400/Merger+sel+2.jpg)
2. Hasilnya akan tampak seperti di bawah ini (C3,D3 dan E3 telah tergabung jadi satu sel)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8JgS_cyDVMyR-LBcD171G4MbjEjbgHiIvS5vWWfWNtZjwv3L4kVpUt593dPpg6B6Bgg1i10j7CCuUaMBUVdseLc4ap6JD3U2rZxn6-a-U4HiZ_vrF1Da3Khyp5yg0JvtB8od1XW6WEl8/s400/Merger+sel+2b.jpg)
3. Blok sel F3 dan F4, kemudian pada toolbar klik tombol merger
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt87ne54qw_xuOVDQvN2QsirwaCjSFZf5E7HFaXo8QhCayWzAWC8DrPqfPckNKncYZ7zhU_N_LvBaj0caHDAxwFQ5LzpF0WE3fXW4uWAmwPnMUHoYKTtW9vLVdQTK8RNgRb8wJTFPWnfM/s400/Merger+sel+2c.jpg)
4. Hasilnya akan tampak seperti di bawah ini
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxDEE51rNwTyFNEAMh6qKf4CWGzbiLnk1nMe2WazG2iwAU6NRPfOL9t7ppgOcLKco0tmDD9ca7HplCvMR-KL_BJNIj-qw18nwDODhx_YvN5DLCicdZRNO2auUQfu4R3yuuGI092DomE8s/s400/Merger+sel+2d.jpg)
5. Klik sel B3 (hasil merger), klik tombol Format Painter (lihat panah merah)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIDGvRJ88HBhfVrRKkVnwbVi9CR1-owB52bAK2uJLPOv1ZmRgvOpuzjc27iVLlLMR5uVXIsjA1yeM3I0y-p3gUiUhon4DJm5pUDQlG2AMUwVyTpmoWdve64m7D9T9aXxCid5SkL8-iCmc/s400/Merger+sel+2f.jpg)
6. Jika format painter aktif, maka garis tepi cel B3 akan tampak putus-putus seperti di bawah ini:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgH26SpZ2YSoGolxDi8D_kBi7QAAH_13BNoy5DG-7lzY9yoYh5I91T1FJKtD2V4zaicqjQM25vnybul1tBS5BwhNnUzmBsoDsW9c6f2gNKCpPtVX8feLqGXy6v9HX5RqrhFyXW3lliB7uA/s400/Merger+sel+2g.jpg)
7. Selanjutnya klik sel F3, maka hasilnya akan tampak seperti di bawah ini:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2HUv5DEa_kxtXGlTdLIUGrbfOW2rhYAyVcLAfB8XaXc5EQtDC4plFG9r7TarBv3FBdWRZmfG9Vs59ZKeLEVnumLUSgdMY7YBEOJwXmk1wpNcOsnD4aeVrYsV2Fr4LXLf8YWdNE87KqfQ/s400/Merger+sel+2h.jpg)
Lihat tulisan Nilai pada sel F3 telah rata tengah.
Prosedur 5 sampai 7 bisa anda terapkan pada sel A3, agar tulisan "No" bisa rata tengah.
sumber : http://artikelkomputerku.blogspot.com/2008/12/004-merger-sel-dan-pengaturannya-bag-02.html
0 komentar:
Posting Komentar