jump to navigation

Excel Tips: Membandingkan Dua Sheets Sekaligus (Comparing Two Sheets at Once) July 28, 2010

Posted by excelux in Tutorials, Tips & Tricks.
Tags: , , , ,
trackback

Beberapa hari yang lalu, jurus yang sudah lama saya simpan ini akhirnya terpakai juga. Kadang kita perlu untuk membandingkan dua sheets di excel sekaligus, baik sheets tersebut terletak di dua file yang berbeda atau malah di satu file yang sama. Kalau letaknya di dua file yang berbeda kita masih bisa mengakalinya dengan mengatur lebar window excel secara manual lalu meletakkannya satu di kiri, dan satu di kanan. Tapi bila yang akan dibandingkan dua sheets dalam satu file lebih repot lagi (bagi yang belum tahu tipsnya) karena by default windownya cuma satu.

Few days ago, the old tricks that I had kept for a long time finally used. Sometimes we need to compare two sheets in excel at once. The sheets could be located in two different files or in the same file. When we found it in the different files we still can handle it by resize the excel window manually and place it in the left and right of our screen. But when they are located in the same file it will raise difficulty (for the one who don’t know this tips) because by default there is only one window.

Misalnya pada gambar di atas kita ingin membandingkan data di Sheets Jakarta dan Surabaya. Bila tampilannya seperti ini maka kita harus klik Sheets Jakarta, cek datanya, lalu klik Sheets Surabaya, cek data lagi, balik lagi ke Jakarta, dan seterusnya. Tentu akan sangat merepotkan. Jadi kita akan gunakan tips ini untuk membuat tampilannya lebih mudah dilihat. Klik Window – New Window. Maka jadilah yang tadinya hanya ada satu window excel sekarang ada dua. Tinggal teman-teman atur yang satu buka Sheets Jakarta dan yang satu buka Sheets Surabaya. Langkah terakhir klik Window – Compare Side by Side With… Nah jadi deh tampilannya enak dilihat seperti gambar di bawah ini.

For example, in the figure above, we want to compare the data in sheets Jakarta and Surabaya. If the view is just like that figure, it will be very troublesome. We need to click sheets Jakarta, check the data, click sheets Surabaya, and check the data again, click sheets Jakarta again, and again, and again. So we need this tips to make the view more comfortable. Click Window – New Window and you will find that now there are two excel window. In the first window open sheets Jakarta and the second window sheets Surabaya. The last step click Window – Compare Side by Side With… And the window become easier to look at just like the figure below.

Lebih gampang bukan ngelihatnya. Selamat mencoba. Semoga bermanfaat.

The view is nicer, isn’t it. Have a nice try. Hopefully useful.

Comments»

1. hasrul - July 29, 2010

*numpang lewat Gan*
nice share excel lux! hehe

excelux - July 30, 2010

Silahkan lewat aja gan, gratis, ga ada pungli di sini, he… he…

2. agus - September 12, 2013

apakah ada rumus untuk menggabungkan data 2 tabel? terima kasih


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: