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.

{ 22 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
  11. 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
  12. 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
  13. best information for everyone here is you can now enjoy free gaming without paying for it. there are lots of online games which you can play for free of cost or can be obtained there resources for free enjoy.

    ReplyDelete
  14. hi, you may know that there is a good site which offers free coins and gems for your favorite game, you may visit this site if you want to know how to get free sources in your game. have fun with this information and stay tuned for more.

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

    ReplyDelete
  16. use pixel gun 3d guide and tips for pixel gun 3d game which makes your experience even more joyable. have a look at this site which gives best ways to get free coins in pixel gun
    3d game.

    ReplyDelete
  17. 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
  18. best site for getting various informative stuff over the net. pls do visit if you love strange things over the net.

    ReplyDelete
  19. 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
  20. 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
  21. 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

Problem ?

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