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.

{ 15 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. 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
  5. 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
  6. 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
  7. getting animal jam codes is now very easy as you can get free codes for animal jam just using this vital information about this game. try it yourself and have fun of free gaming. Thanks.

    ReplyDelete
  8. everyone knows that animal jam game is very much favorite of kids like me.. i love animal jam game designed by national geographics and just amazed how they managed this awesome game very easily. getting animal jam codes is not that hard but having them in sufficient quantity is very important. have fun..

    ReplyDelete
  9. This comment has been removed by the author.

    ReplyDelete
  10. hi there, you might know that pixel gun 3d cheats are the awesome facts about pixel gun game as this is the best way to get free coins for pixel gun 3d and use them in your gaming strategy. have fun.

    ReplyDelete
  11. best site for getting various informative stuff over the net. pls do visit if you love strange things over the net.

    ReplyDelete
  12. getting free coins for madden mobile is now more easier than having a cup of tea. visit madden mobile guide which can help you out getting madden coins without having money. this site gives free coins

    ReplyDelete
  13. hi friend, your post really make sense and you know that you can also use this method to do this process more easily and there are plenty of methods still unused like this and you may also use them for getting it done. hope you understand what i mean and you can follow the given process for you can go for it just click here and you are ready to go.

    ReplyDelete
  14. your thoughts are really good mate, I liked it and you may also happy by knowing that i also tried it and this is working one. thank you for describibng this this wonderful thing and wanted to tell you that you can use it as per your need and its very helpful for you. give it a try and check out other things too. thanks.

    ReplyDelete
  15. hi.. your articles is very good and you can visit to the best site for simcity buildit guide and tips for the simcity buildit. have fun.

    ReplyDelete

Problem ?

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