Silahkan Pilih

Posted by : AdiMPS Friday, 20 June 2014


Pada suatu tabel, sering kita mencoba untuk mengkopi rumus karena rumusnya sama. Misalkan situasi dimana kita ingin membuat nilai New Salary yang mana Salary ditambah dengan 3.21%. Lihat contoh gambar dibawah ini
copy-rumus
Pada gambar diatas, kita telah membuat rumus sel New Salary yaitu =F2*$J$1+F2, dimana J1 berisi 3.21%. Maksud rumus diatas, adalah hitung kolom New Salary berupa penambahan 3.21% dari kolom Salary
Biasanya setelah menulis rumus diatas, kita akan mengkopi rumus tersebut dengan menarik kotak hitam kecil di Kolom H2 ke bawah, seperti gambar.

Tips 3. Copy Rumus

Namun ada cara cepat untuk mengkopi rumus tersebut, yaitu double klik saja pada kotak kecil hitam yang biasanay kita seret kebawah itu.
Hasilnya adalah, seluruh sel pada kolom New Salary sampai ke bawah akan terisi dengan rumus tersebut

Catatan:

Bila ada satu atau beberapa kolom di samping kiri atau kanan rumus ada yang kosong, maka double klik hanya akan berhenti sampai tempat kosong tersebut. Ini tentu mengesalkan, karena kita harus kembali mengkopi rumus dengan cara menggeser.
Nah untuk mengatasi hal seperti ini, pastikan bahwa disamping kiri dan kanan rumus yang dikopi, tidak ada sel kosong. Hal ini bisa dilakukan dengan cara : Menyembunyikan sel yang kosong tersebut. Caranya dengan klik kolom yang ingin disembunyikanklik kanan lalu pilih Hide.
RUANGKOSONG
hide_kolom
Pada intinya, agar double klik bisa mengkopi rumus secara otomatis, kolom di sebelah kiri atau kanan rumus tidak boleh kosong.

{ 10 comments... read them below or Comment }

  1. So to cover it up it can be said that the 5 star ranking system can be a terrific tool for people that recognize how to use it and also for folks that in fact utilize it in a proper way. reviews on facebook

    ReplyDelete
  2. hi admin, your articles are always awesome. i liked this point and wanted to share with you some useful information about the blog. I love gaming and who don't, i found some of the useful information about the mobile game and new tricks and tips for the games. visit the blog if you are interested in the gaming blog like this. thanks.

    ReplyDelete
  3. your blog is very awesome and am really impressed with it. you may like entertainment blogs like this. if you are a good game players like madden mobile, then you may be interested in having free madden coins, visit the site if you want free madden mobile coins.

    ReplyDelete
  4. hey buddy, your blog looks very cool while reading, please dont mind if i share the best mobile game trick here, i am a big fan of madden mobile game and like free coins for madden game. if anyone here looking for it then please consider myself in your list. thanks.

    ReplyDelete
  5. Hello guys, you all are awesome are thinking a lots better than me. i just wanted to know that if anyone is familier with mobile games and desktop games like animal jam introduced with national geographic society. if anyone can generate free diamonds for animal jam then please let me know how to get free codes for animal jam thanks.

    ReplyDelete
  6. your website encoraged me to compose some stuffs in video game game like animal jam computer game. this game is my favorite and that I constantly look into animal jam codes whenever I get time from my day-to-day program. please attribute an good website for obtaining free diamonds for animal jam. thanks.

    ReplyDelete
  7. hey there, your work is awesome as always, i heared about getting free coins for nba live mobile game is this true i dont know but i want free coins and cash if anyone is giving for it. i like nba live mobile game and need one working method for this. thanks

    ReplyDelete
  8. hello there, your article is awesome as always, i was looking for nice information on mobile games like new upcoming games of mobile versions, there are lots of good articles on this topic but the very rare ones share lethal information. please go through this one if you need the same.

    ReplyDelete
  9. best way to get free coins for the best mobile game is to visit this page and grab all the information about madden mobile hack. have fun.

    ReplyDelete
  10. You know there is a great option on madden mobile coins that anyone can obtain free coins for madden game by using this information about getting the resources. Thanks.

    ReplyDelete

Problem ?

- Copyright © AdiMPS - - Powered by Blogger - Designed by -