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

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

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