Trik Ms Excel | Cara merubah nama cell di Ms Excel 2010

Lembar kerja microsoft excel terdiri dari kumpulan cell yang berupa kotak-kotak. Cells tersebut dapat diubah ukuran lebar (kolom) atau tinggi (baris) sesuai dengan keinginan user. User dapat pula melakukan penggabungan atau merger cell satu dengan yang lain sesuai dengan keperluan. Dengan menggunakan Ms Excel, user akan mudah melakukan penghitungan data tertentu dengan menggunakan rumus atau formula.

Dalam menuliskan suatu formula atau rumus juga akan selalu memperhatikan letak dan nama cell. Nama sebuah cell didasarkan pada letak cell tersebut, yaitu pada kolom apa dan baris berapa. Penulisan nama sebuah sel didasarkan pada kepala kolom dan kepala baris tempat sel tersebut berada. Misalnya Sel D5, A2, F8, dsb. D, A, F merupakan kepala kolom sedangkan 5, 2,dan 8 merupakan kepala baris. Nama sebuah cell akan tampil pada kotak Name Box disamping Formula Bar pada jendela excel. Sehingga ketika anda klik pada cell tertentu maka nama sel tersebut akan secara otomatis muncul di Name Box.

Nama sel (cell) tersebut dapat anda rubah sesuai dengan keinginan anda untuk mempermudah mengakses atau menambah unik rumus anda. Nama sel tersebut dapat anda ganti dengan nama anda atau nama lain yang anda inginkan. Sebagai contoh misalnya cell D5 diganti dengan nama “Basel”. Sehingga nantinya ketika anda klik pada cell D5 maka nama yang tampil di Name Box adalah Basel. Dengan demikian ketika anda menggunakan sebuah rumus yang mengaitkan dengan sel D5 maka nama yang anda gunakan untuk menuliskan D5 adalah kata “Basel”, …. Unik bukan??!

Berikut ini adalah langkah-langkah merubah nama cell dengan nama yang lain di Ms Excel.
  1. Klik Cell yang akan diubah namanya misalnya cell D5.

    nama cell di Ms Excel
  2. Klik tab Formulas kemudian pada group menu Defined Names Klik Define Name

    Define Name di Ms Excel
  3. Pada jendela yang muncul ketikkan nama sel yang anda inginkan di kotak Name, Misalnya “Basel”. Anda bisa pula menambahkan komentar atau keterangan di comment. Jika sudah klik OK.

    Merubah nama sel di Ms Excel
  4. Mulai dari sekarang ketika anda klik pada sel D5 nama yang digunakan adalah Basel. Gunakan langkah yang sama pada sel yang lain.

    Nama lain sel di Ms Excel
  5. Untuk mengembalikan pada kondisi semula atau untuk menghapus nama sel tersebut dapat dilakukan dengan langkah klik pada Name manager pada group menu yang sama kemudian pilih nama yang ingin anda hapus, setelah itu klik delete dan klik yes. Maka nama sel tersebut akan kembali pada nama aslinya yaitu D5

    mengembalikan nama asli sel di Ms Excel

19 komentar:

  1. Or maybe you look at it from a monetary standpoint and decide that
    Guy Ritchie and Madonna divorce was worse because they were married so long and have children
    and there is a lot of money involved. However there are several troubleshooting steps
    you need to perform in order to determine the problem.

    This is why the said Albanian gossip thashetheme
    celebrity news blog page is written in Albanian '.

    Feel free to surf to my homepage ... latest celeb news

    ReplyDelete
  2. Here again you want to find or even create an angle or slant
    in which you can take headline news and 'incorporate'
    it into a post you are composing. Aamir Khan and Amitabh Bachchan had a rough battle, when the movies related to them were
    released at the same time. Celebritynewsapp has developed a celebrity app which is
    getting popular day by day.

    Here is my web blog; latest celeb news

    ReplyDelete
  3. Of course, one of the reasons why this area of Ohio has
    remained so persistently branded as a pocket of joblessness is its failure to recover from the death of
    the steel industry and also because of automotive production lines outsourced to foreign lands.
    He was instrumental in MTV showing African American artists.
    The facility of websites and online news are also getting lot of appreciation because it
    is very time saving and people can read it in between their work.


    Have a look at my page; Latest Daily News

    ReplyDelete
  4. It's perfect time to make some plans for the future and it's time to be happy.
    I've read this post and if I could I wish to suggest you few interesting things or suggestions. Maybe you could write next articles referring to this article. I wish to read more things about it!

    Also visit my blog: Test Force Xtreme Review

    ReplyDelete
  5. Appreciate the recommendation. Will try it out.

    my webpage - diaper rash home remedies

    ReplyDelete
  6. Every weekend i used to pay a quick visit this web page, for the reason that i wish
    for enjoyment, as this this web site conations actually fastidious funny data too.


    Also visit my homepage Diarrhea remedies

    ReplyDelete
  7. excellent post, very informative. I ponder why the other experts of this sector do not understand this.
    You must continue your writing. I'm sure, you have a great readers' base
    already!

    Here is my site; refinishing hardwood floors

    ReplyDelete
  8. Hello there! Would you mind if I share your blog with my facebook group?
    There's a lot of people that I think would really enjoy your content. Please let me know. Cheers

    Have a look at my web site http://mochi-kochi.sakura.ne.jp/

    ReplyDelete
  9. Normally I do not learn article on blogs, however I would like to say that this write-up very compelled me to take a
    look at and do it! Your writing style has been surprised me.
    Thank you, quite nice post.

    Take a look at my website; diarrhea remedies

    ReplyDelete
  10. Right here is the right blog for anybody who would like to find out about this
    topic. You realize so much its almost tough
    to argue with you (not that I personally will
    need toÖHaHa). You definitely put a new spin on a
    subject that has been written about for years. Great stuff, just wonderful!


    my website ... angry birds online spielen

    ReplyDelete
  11. I am truly pleased to glance at this blog posts which consists of plenty of helpful
    data, thanks for providing such information.


    Also visit my site; Http://Www.Dailymotion.Com

    ReplyDelete
  12. Hi mates, good paragraph and good arguments commented at this place, I am really enjoying by these.


    Also visit my blog post microsoft exchange server 2007

    ReplyDelete
  13. Hi! Quick quеstion that's completely off topic. Do you know how to make your site mobile friendly? My site looks weird when browsing from my iphone. I'm
    trуing to find a templatе οr plugіn that might be able to гesolve thіs
    issue. If уou have any rеcommendationѕ, please shaгe.
    Appгеcіate іt!

    Visіt mу web-site; pro-dog

    ReplyDelete
  14. Asking questions are truly fastidious thing if you are not understanding anything entirely,
    except this article presents pleasant understanding even.


    my site; moustiquaire fenetre pvc

    ReplyDelete
  15. Good day! I could hаvе swοrn I've been to this website before but after reading through some of the post I realized it's new to
    me. Anyways, I'm definitely delighted I found it and I'll be bookmarking anԁ checking bacκ oftеn!


    Also vіsit mу page :: Report abuse

    ReplyDelete
  16. Do you have a spam problem on this blog; I also am a blogger, and I was curious about your
    situation; many of us have developed some nice procedures and we are looking to trade solutions with others, why not shoot me an email if interested.


    Here is my page :: pose volet roulant

    ReplyDelete
  17. The other day, while I was at work, my cousin stole
    my iPad and tested to see if it can survive a 30 foot drop, just so she can be a youtube sensation.
    My apple ipad is now broken and she has 83 views.
    I know this is totally off topic but I had to share it with someone!


    Here is my website store pour fenetre pvc

    ReplyDelete
  18. It's actually a nice and useful piece of information. I am happy that you simply shared this helpful information with us. Please stay us informed like this. Thanks for sharing.

    Feel free to surf to my web site christophe chavigny

    ReplyDelete
  19. I will immediately seize your rss feed as I can't find your e-mail subscription link or newsletter service. Do you have any? Kindly let me know so that I may just subscribe. Thanks.

    Also visit my homepage Pirater Un compte facebook

    ReplyDelete