Copy Paste Horizontal Ke Vertikal Excel

Kalo pengin sederhana pakai Copy All Array– Paste Special

( All – Tranpose) – Enter deh.

Klik Kanan – Copy

Buka sheet baru – Klik Kanan PAste Spesial

( Cheklist Transposenya – Ok )

Begitu Pun sebaliknya Kalo mau Vertikal Ke horizontal.

Trims.

Adis

About adisalannuary

Write What You Do - Do What You Write

Posted on 30 Januari 2012, in Ms. Word & Excel. Bookmark the permalink. Tinggalkan komentar.

Mohon Komentar Anda

Please log in using one of these methods to post your comment:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: