Langsung ke konten utama

Fixed/Freeze row header

For about an hour, me and my boss try to find out, how to fixing/freezing header row in Microsoft Excel. We 'asked' the Help, trial and error, asked other person and looked for the example. And we found NOTHING!!!!!! Then we decided to give up, and continue to another topic.
But, in the next hour, i still wondering, how to do that thing? So, i surf it with search engine (thx 4 google) and i get direct answer just in the first line of the recommended site. I try it, and it works!!!! The funny thing is, the site just explains it just IN 2 STEP!!! This is how it works:

  • Decide where is the header data that you want to fixed/freeze. for example, i want to freeze ONLY the first
  • Place your cursor in A2, go to Windows and select Freeze. Or you can click Alt+W+F
See? As simple as that!!! If you want to freeze row and column, you have to place your cursor in a upleft of unfreeze table. For example, i want to freeze Column B and Row 2, then i place the cursor in C3 and do the step 2.

There!!! You dont have to spend an hour, just like me, to figure it out now, since i already wrote it in here, hehehe. Enjoy and cheers



Note:The original site is http://www.devx.com/tips/Tip/35350
Label:

Komentar

Posting Komentar

Postingan populer dari blog ini

Photoshop Tutorial:Making Glass Orb

My name is not Doni, but you suck at Photoshop. Haha, if you often browse photoshop tutorial at Youtube, you must be familiar with that line. He's teaching Photoshop with hilarious way. Anyway Im gonna give you some Photoshop tutorial here. I got it from Youtube, but no, not from Doni, hehe, im gonna write it in another tutorial. I forget where the original video was, so i cant refer to it, souwry. My Photoshop is Photoshop CS, so this tutorial will be aplicable for later version.In this tutorial, i will show you how to Make a Glass Effect Orb . This is my first tutorial, and i just start learning photoshop about two months ago, so feel free to comment. Without further sayings, let's get started!!!! First thing first, let's open a new file, File - New . Im using 500x350 pixel for my new document. You can use any dimension to your liking. Click OK. Okay, now select the Elliptical Marquee Tool, and make a perfect circle (Hold Shift to keep the cirle proportional) Create a ne...
Posting Komentar
Baca selengkapnya

Chords You Can Use

Consider you want to make a song. And let's just say, the root note is in C (the most common root note ever!!) and we're gonna use major scale. And then, the next question is, what chords i can use to make this song? Okay, im here to save you, dont worry, hehe. In this post, i will give you the idea, what chords you can use and why you can use them. And what im gonna give you here, is a basic music theory. Hopefully it's enough for you to make some song. Maybe you will encounter some song that out of this rule, but hey...music is not mathematics. You can break the rules, if it's good for you and/or your listeners. But of course if you a complete beginner, it's just save to follow the rules first. Without further sayings, let's begin, shall we? We continue with the scenario, which is make a song in C major. As we all know, a C major scale is C D E F G A B. There's common rule, that we can use pattern (Major-Minor-Minor-Major-Major-Minor-Diminished) over a maj...
Posting Komentar
Baca selengkapnya

My First Post

Hellow...this is my first posting...euu..don't know what to say, hehe I'm glad because finally i made myself a blog... I will share some of my knowledge or interesting (at least for me) here and need feedback from you, so don't hesitate to suggest, critic, mock or stuff like that, haha. And if you wish you can read about my daily life or about 'my feeling this day' wall of text or my love story, which is like diary book, like everybody does, then you just hoping for a fat lady sings. You won't find it in here. Maybe i'm gonna make it in another blog, maybe, hehe, not kind of person who wrote a diary everyday. So, don't bother searching my private stuff here, you will find NOTHING!!!!! Until then, C U in my next post. Bye.......
6 komentar
Baca selengkapnya