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

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

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

Sorting Data With Excel

It's 2:27 AM now. Got my graveyard shift now. And boss gave me a task. It looks simple yet it's very frustrating since i have to deal with crazy disorganized arrays of data. For example, the first row is a data at 2 Sept 2008 08:02:00 AM. But the next row is data at 1 Sept 2008 23:10:26 PM, then continue with 2 Sept 2008 00:10:27 AM. See the image By the way, im dealing with sea level height data, sent by tsunami buoy. And in this post, i will use example of three data row. You can apply it for thousands of data (as long as the data fit in excel, cause excel limited the number of data row to 65000 or so). As you can see, the date, hour, minute and second placed separatelly. This is an advantage (at least for me, hehe). Here's the idea. I want to combine the date, hour etc. into a single cell. What im doing here is write this formula: I multiply the minute with 100, hour with 10000 and date with 1000000 and then add them all (with second too), in a single cell. Then copy it ...
1 komentar
Baca selengkapnya