You Know So Much About Nothing At All

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. Ther...

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 ...