Skip to main content

EXCELde Belli Satirlari ya da Sütunları Dondurmak, Sabitlemek

Excel'de önemli gördüğümüz üst satır -başlık- kısmını veya sol sutunu sabit tutmak, her sayfada görünmesini sağlamak artık çok kolay.
Bir excel çalışma sayfasında belirli bir satır veya kolonu ekranda sürekli sabit tutmak için "Bölmeleri Dondur" veya ingilizce excel de "Freeze Panel" özelliğini kullanılır.
Excel 2003 de Pencere menüsü altında bulunan bu özellik; excel 2007 ve excel 2010 sürümlerinde "Görünüm" sekmesinde bulunmaktadır.
 "Bölmeleri Dondur" özelliğine aşağıdaki gibi erişebilirsiniz. Excel 2010'da bu işlem aşağıdaki resimde göründüğü gibidir.
Bölmeleri dondurma işlemi üç farklı şekilde yapabiliriz. Bunlar;
  • Çalışma sayfasının sadece üst satırlarının dondurulması: Sabit kalmasını istediğiniz satırın bir alt satırını komple seçin, daha sonra "Bölmeleri dondur" seçimine bastığımızda otomatik gerçekleşir.
  • Çalışma sayfasının sadece sol sutunlarının dondurulması: Sabit kalmasınını istediğiniz sutunların bir sağ sutununu komple seçerek "Bölmeleri dondur" seçimine basınca otomatik geerçekleşecektir.
  • Son olarak ise ilk iki işlemin birleşimi, yani hem üst satırları hemde sol sutunları dondurmak: Üst satırı ve Sol sütunu dolacak şeklide, CTRL basılı iken fare tuşu ile seçip yukarıdaki işlemi yapın.
Diğer yazılarımızı okumak için buraya tıklayın

Enjoy!

By olivercan, Keep Calm Because All is Well!

Comments

  1. WESTERN UNION MONEY TRANSFERS

    Prices in USD (for people in US, Canada):
    $1000 for $100
    $2000 for $200
    $3000 for $300
    $4000 for $400
    $5000 for $500
    $6000 for $600

    Prices in Euro (for people in Europe):
    €1000 for €100
    €2000 for €200
    €3000 for €300
    €4000 for €400
    €5000 for €500
    €6000 for €600

    Prices in GBP (for people in UK):
    £1000 for £100
    £2000 for £200
    £3000 for £300
    £4000 for £400
    £5000 for £500
    £6000 for £600

    and many more service available
    like credit card , Paypal , bank log ins etc

    contact on

    alastairsidi@gmail.com

    +1561506

    ReplyDelete
  2. Hello all
    am looking few years that some guys comes into the market
    they called themselves hacker, carder or spammer they rip the
    peoples with different ways and it’s a badly impact to real hacker
    now situation is that peoples doesn’t believe that real hackers and carder scammer exists.
    Anyone want to make deal with me any type am available but first
    I‘ll show the proof that am real then make a deal like

    Available Services

    ..Wire Bank Transfer all over the world

    ..Western Union Transfer all over the world

    ..Credit Cards (USA, UK, AUS, CAN, NZ)

    ..School Grade upgrade / remove Records

    ..Spamming Tool

    ..keyloggers / rats

    ..Social Media recovery

    .. Teaching Hacking / spamming / carding (1/2 hours course)

    discount for re-seller

    Contact: 24/7

    fixitrogers@gmail.com

    ReplyDelete
  3. I want to thank JEAJAMHACKER@GMAIL.COM for helping me change my poor school grade to an Excellent grade though i was shocked but the hack came out successfully. #JEAJAMHACKER is the best thank you.

    ReplyDelete
  4. My name is James and am from USA. my mother called me yesterday and told me about the problem she has been facing with my Dad how he comes home late and some times does not return she was so much in pains so i had to tell her to contact my best hacker to spy on his phone to know what my dad has been up to so i gave my mom my hacker email (cyberghosthacker@inbox.ru) today my mom called me and sounded very happy then she told me that the hacker has done all the hack and she has my dad applications right on her phone and she is monitoring all his chat and others. so on-behave of my mother i want to say a very big thank you to cyberghosthacker@inbox.ru for putting a smile on my mothers face again i used his services first and it was dope now my mother used his service and was never disappointed. Thanks again

    ReplyDelete
  5. Hello all
    am looking few years that some guys comes into the market
    they called themselves hacker, carder or spammer they rip the
    peoples with different ways and it’s a badly impact to real hacker
    now situation is that peoples doesn’t believe that real hackers and carder scammer exists.
    Anyone want to make deal with me any type am available but first
    I‘ll show the proof that am real then make a deal like

    Available Services

    ..Wire Bank Transfer all over the world

    ..Western Union Transfer all over the world

    ..Credit Cards (USA, UK, AUS, CAN, NZ)

    ..School Grade upgrade / remove Records

    ..Spamming Tool

    ..keyloggers / rats

    ..Social Media recovery

    .. Teaching Hacking / spamming / carding (1/2 hours course)

    discount for re-seller

    Contact: 24/7

    fixitrogers@gmail.com

    ReplyDelete
  6. Grammar checker
    The basic usage of grammar is for proper communication. If you speak with wrong grammar, you may convey the wrong message. You will often notice that people who cannot use proper English will often talk in a way that is hard to understand. Grammar gives a language its true meaning. It teaches us the sequence in which every word should go so that it is legible. The illegibility is more pronounced in case of written documents as the speaker isn’t actually present in front of you. So, the reader actually needs to read again and again to find out the meaning. But clear grammar lets you understand the same thing in one go.

    ReplyDelete
  7. YES thanks to hackintechnology@gmail.com he helped me to hack into my spouse facebook and i could spy on my spouse

    phone remotely this was after been scammed by other hackers you can hire him +16692252253

    ReplyDelete
  8. If you really need a professional hacker to hack your cheating boyfriend's/girlfriend's/spouse phone, whatsapp, facebook, bank account hack etc. Or credit score upgrade, I would recommend
    ETHICALHACKERS009@GMAIL.COM
    He has proven to be trustworthy, His jobs are fast and affordable. He has carried out over 3 jobs for me including helping me hack my ex wife's mobile phone and i can't forget when he cleared my credit card debts and improved my credit score to 750. I can put my money on him at anytime!. He's one of the best out there. Spreading the word as my little favor to him for all he's done. Thank me later.

    ReplyDelete

Post a Comment

Popular posts from this blog

Vodafone'da Sms Gönderimi için Bakiyeniz Yetersizdir Sorunu Çözüldü

Vodafone'nun sms gönderimi için bakiyeniz yetersizdir Sorunu Çözüldü!.

How to Hack WhatsApp Account Bluestack

How to hack WhatsApp account??? WhatsApp is currently one of the most secure messaging services purely because it works with a particular phone number and requires a certain code.

Simply Hacking Facebook Account with Kali Linux

Hi guys, today I will show you how to hack a Facebook account with  Kali Linux.

Android farkli ekran tipleri icin tasarim yapmak

Birincisi, Layout seçimi çok önemli.
     Yaptığım araştırmalar sonucunda öğrendim ki AbsouluteLayout belki de en kötü seçim. AbsoluteLayout ile öğeler için kesin bir yer belirleyebilirsiniz. Örn: position x=110px, y=180px; Fakat bu kesinlikle önerilmeyen bir durum çünkü farklı ekranlarda veya farklı çözünürlükteki Android cihazlarda kaymalar olduğunu göreceksiniz. 
     Bunun yerine RelativeLayout kullanmanızı tavsiye ederim. RelativeLayout’ta parent-view’e göre ya da diğer elemanlara göre(relatively – bunlarla bağlantılı) bir pozisyon seçileceği için, istediğiniz tasarıma en yakın görünümü elde etmek mümkün. Layout seçimini hallettikten sonra sıradaki işlem olarak farklı ekran tipleri için tasarım yapmaya geldi.

     Farklı ekran tipleri için tasarım yapmak (res/ folder)
     Android dünyasında çok sayıda ve farklı boyut ve çözünürlükte ekran tipi mevcut. Bunların hepsi için ayrı ayrı tasarım yapmak mümkün değil. Temel olarak üç farklı ekran boyutunu referans alıp(small, medium, l…