How To, Computer Tips Trick And Creative Ideas

How To Resize Picture ( reduce file size ) Using MS Outlook

2012-03-11T04:00:00.001+07:00

If at your workplace using Ms Outlook (e-mail client software from Microsoft), and if you need to make smaller or resize the picture file, you can use this Ms. Outlook by sending the attachment (the picture) to your friend or to yourself, and receive the new size of the attachment

Here's the way :
• Highlight / block the picture/s
• Right-click on it , and select Sent To -> Mail recipient
(click on image to enlarge)

How To Know Android Local IP Address

2012-03-09T19:38:00.000+07:00

While connecting to the hotspot or wifi, android device ( smartphone, tablet, etc) will get the IP (internet protocol) address, which is given by the DHCP server in it's hotspot / wifi.

To find a local IP address given (obtained by the android) while it is connected to a wifi/ hotspot, following the steps below.

• Go to the Settings menu

Example picture - using Samsung Galaxy Tab, for other android devices in principle is the same, just different in appearance only.

Combination Portrait And Landscape Pages In the Same File MS Word 2007

2012-03-03T21:36:00.000+07:00

To create pages with different pages layout, portrait and landscape in the same word document (in the same file) in MS Word 2007.

Below are the steps :

For example to make page 1 portrait and page 2 is landscape
• Run MS Word
We have to make different section for each page. Section 1 for page 1 and section 2 for page 2 ( section 3 for next page..and so on )

• Place the cursor on the page 1
• Go to Page Layout menu tab
• Click on Breaks
• Click on Next Page

Read more »

Driver For Toshiba Satellite M55 S3262 Windows XP

2012-02-29T20:48:00.000+07:00

Here are drivers for Notebook / Laptop Toshiba Satellite M55 S3262 Windows XP.

Shared in Zip file which include :

1. Wireless LAN : Intel(R) PRO Wireless 2200BG
2. Audio : RealtekAC97
3. Flash Media Controller : Texas Instruments PCIxx21
Read more »

How To Know The Blackberry OS Version

2012-02-26T15:07:00.003+07:00

Below are the steps to know the Blackberry Operation System (OS) Version

Go to the Options menu

How To Hide / Disable All Programs From The Start Menu In Windows 7

2012-02-22T20:24:00.000+07:00

Sometime you need to hide or disable the All Programs Menu, for example if you don't want your friends to run the program or application easily on your computer.

Below are the steps to remove / hide or disable All Programs from the Start Menu in Windows 7 Computer

• Go to the Run command by pressing Win + R (on the keyboard Windows Logo + R)
• Type gpedit.msc and click OK or press Enter

Read more »

Where is the Recent Documents / Recent Items Menu in Windows 7 ?

2012-02-19T22:17:00.003+07:00

By default in Windows 7, the Recent Items / Recent Document menu does not appear or hasn't been active,
To make active The Recent Items in Windows 7, follow bellow steps :

Right click on Start (Windows Logo 7)
Click on Properties
Click on Customize (Start Menu tab)

Change Measurement Unit From Inch to mm or cm in MS Office 2007

2012-02-15T19:58:00.000+07:00

By default in Microsoft Word, all measurements unit for page margins, paper size , etc, are in Inch.
In the Microsoft Word 2007 If you want to change to others unit, to cm (centimeter) or mm (milimeter), let see the way bellow

• Click on the Office Logo
• Click on Word Options

Vertical Selection In MS Word 2003, 2007 and 2010

2012-02-14T11:53:00.000+07:00

Generally, for selecting a word document usually by horizontal highlight from left to right or from right to left.
We can also select a document using vertical highlight, from top to down or from down to up.

To make the selection vertically:

• Place the cursor in front of the word to be selected
see an example

How To Deactivate / Disable Startup Sound In Windows 7

2012-02-11T15:03:00.002+07:00

To make disable or deactivate Startup Sound in Windows 7

• Go to Control Panel (Click on Start --> click Control Panel)
• Select Hardware and Sound (View By Catagory)

How to Open Command Prompt With Mouse Click

2012-02-09T20:18:00.000+07:00

Usually to open Command Prompt we go through the RUN Menu (Win + R) and typing the word Command in the run column.
In Windows 7 we can also open a Command Prompt using a Mouse Click

• Press and hold the Shift key (on the keyboard)
• Right-click on the Desktop area (while holding down the Shift key)

Read more »

Change To Uppercase or Lowercase In MS Word Document

2012-02-07T22:07:00.000+07:00

Change to Uppercase or Lowercase In Microsoft Office Word Documents, MS Word 2003, MS Word 2007 and MS Word 2010.

If you have a Word document, and want to change the contents of that document to use uppercase character (capital) in all of them or all with lowercase, or just the first character using uppercase of each word.

It's very easy :

Highlight / Select the Sentences you want to change its character to uppercase / lowercase, then press The Shift + F3 key

Optimally Modem Speed Setting For Increasing Internet Speed

2012-02-05T14:59:00.000+07:00

For internet users who use modem (GSM or CDMA) for connection, and you think the internet speed is not optimal (slow), maybe the trick below will be able to help or resolve

One way to increase the speed of internet connection is to optimize the speed or the speed setting on the modem.
Usually the dial-up software to connect to the internet (built-in with modem) is using a modem default setting speed and it is usually not optimal.

Read more »

How to go to Google.com, not to Local Google

2012-02-01T19:27:00.001+07:00

When you want to entry to google.com, then you type www.google.com in your browser and hit the enter key, usually will change back to local google, (google.com.au,.google.co.uk, google.it, google.co.id, etc, depend to your location)

How to force go to google.com ?
The answer : In the address bar type like this : www.google.com/ncr

Good luck..

See Also :
• How To Make Header Content or Footer Different on Each Page in Ms.Office Word 2007
• How to know Blackberry MAC Address

How To Make Header Content or Footer Different on Each Page in Ms. Word 2007

2012-01-28T15:35:00.002+07:00

By default, if we create a header or footer on one page in Ms. Word, then the other pages will have the same header / footer contents automatically.

If we want to have a header / footer contents are different in other pages, below is the way :

For example I have a word file contains 3 pages, and want to have different header on each page
• Open the file
• Determine the section on each page header to be distinguished. because only by distinguishing the section we will be able to make the different header on each page.(to have different header must have different section).

Read more »

How to Know The Blackberry MAC Address

2012-01-13T15:59:00.000+07:00

We need the Blackberry MAC ( Media Access Control ) Address when we have to give access or setting to the wireless hotspot / wireless access point.

To know the MAC Address of a Blackberry device
• Go to Options Menu

Ziddu will not pay anymore

2012-01-10T22:34:00.001+07:00

Who is not familiar with Ziddu?, Ziddu is the site for sharing and store the files for free, no premium user, completely free for all, no waiting time to download a file. more, when someone downloaded a file, we as the owner of the file would get paid.
But now, we get the Not good news, Starting January 2012, ziddu do not pay the user anymore, "From January 2012, Ziddu Will not pay to users. However the Ziddu The service is 100% Free for downloading files". announced at Ziddu website.

Read more »

How to Make Faster Windows XP installation Process

2012-01-07T00:43:00.001+07:00

Normally, to install Windows XP takes about 40 minutes
There is a trick to get Windows XP installation process much faster, only takes about 20 to 25 minutes.

Here's the trick :

• Boot the computer using the XP CD installer and follow the initial setup steps as usual.
• At the formatting step , select Quick format (NTFS or FAT32)
• The computer will restart and will start the installation process on GUI mode (Graphical User Interface), from here we start the trick.

Read more »

How To Add / Insert Watermark In Microsoft Word 2007

2011-12-29T11:50:00.000+07:00

Watermark is intended to provide an identity, a sign or warning on a drawing, photograph, video or a document.
To give a watermark on a document in Microsoft Office 2007, here is the way:

• Open MS. Word Document that you want to give the watermark
• Click on the Page Layout tab
• Click on the Watermark

Read more »

Easy Way To Know The Unknown Extension File

2011-12-24T23:34:00.000+07:00

Maybe you will be confused when one day you have to open a file, for example there is an attachment from someone or your relationship, or you just download a file, etc, while you do not know what type of the file it is and you don't know must be opened using which program/software application, because that is an unknown extension for you.

The easy way to know the properties of the extension file,
Read more »

How to make moving / running text on Blog or website ( marquee and it's variations)

2011-12-22T21:31:00.001+07:00

One of way to draw attention to a word or phrase in a blog or website is with using variations to that word or phrase. We can use Marquee / running text (the movement of text from left to right or right to left, from top to bottom or bottom to top, also combined from those both variations).

Here is the html code for various variations on the marquee:

1• Moving from right to the left
<marquee> Text or phrase </marquee>
http://h0w2.blogspot.com
2• Moving from left to the right

<marquee direction="right"> Text or phrase </marquee>

http://h0w2.blogspot.com

3• Moving from right to the left and from left to the right
<marquee behavior="alternate"> Text or phrase </marquee>

http://h0w2.blogspot.com

4• Moving from bottom to top
Read more »

Enabling Default Games In Windows 7

2011-12-17T20:29:00.000+07:00

A simple game is needed for refreshing when you are working and feel boring.
In windows 7 the default games are not enable. and you have to set manually to show or to enable them.

• Go to Control Panel
• Choose Programs -- > Programs and Features --> Turn Windows features on or off

Read more »

Reduce picture/photo file size using a simple tool

2011-12-14T22:20:00.000+07:00

For uploading to the blog, website, social networks (facebook, twitter, friendster, etc.), send to mail, and others type of sharing, an image (picture / photo) should be resized to smaller file size. it is intended to be fast uploading process, and next fast for accessing or downloading process.

Not only for internet or web actifity, for office activities, inserting image to word /office document, the picture is needed to be resized to the smaller size.
Often we found the word document have a big and large file size because of inserting image/picture to the word without resizing first.

There are many software/ tools for resizing or reducing the file size, one of them is PIXresizer, verry good tool for reducing photo / picture files. Support for Windows (98/ME/NT4/2k/2k3/2k8/XP/Vista/7 ). The installer file is about 3MB.

Here is an example picture reduced by PIXresizer
Double click the picture for enlarge

Setting Gmail On Ms. Outlook

2011-12-11T05:16:00.001+07:00

Gmail provides POP (Post Office Protocol) so that we can use a local mail client software to be able to receive and send e-mail without having to open the browser to open Gmail.
Benefit more by using email client software to open the email is access will be faster, and we can open the email without having to always be online because the mail will be downloaded to our computer.

Here's how to setting Gmail using Microsoft Outlook 2007, (for Ms outlook 2003 and Ms. Outlook 2010 are not too different )

• The first step, go / login to Gmail through the web browser to activate the facility of POP
Read more »

Trick to write on the hard copy form using Ms.Word

2011-12-08T21:42:00.001+07:00

When you have to fill out in hard copy form, an application, questionnaire, etc, and you do not have a typewriter, the way below may be used as a solution.

• Scan the form / application and save it as a picture file (jpg, png, gif dll)
• Run Ms Office Word and create a New Blank Document
• Double Click at the Header area

How to make keyboard shortcut for launching an aplication

2011-12-01T00:16:00.001+07:00

Other than using the mouse, we can also use the keyboard for launching an application, with pressing the combination keys of the keyboard ( Ctrl+Shift+'Character' or Ctrl+Alt+'Character' ). This combination key called Keyboard shortcut. Using keyboard shortcut is faster than using mouse click.

How to create a keyboard shortcut for an application :
For example we will create a keyboard shortcut for the Application : Ms. OfficeWord

• Go to the Start Menu Programs where MS Word is (or may exist on the desktop)
• Right-click on Microsoft Office Word, then left click on Properties
Read more »

How to hide sitemeter icon on a free sitemeter account

2011-11-27T23:28:00.001+07:00

If you are using a free sitemeter (from http://sitemeter.com) on your blog / web site, and want to hide it's icon ( invisible icon), the way is you have to upgrade to the pro account.

But wait.. we have a trick to make hiding icon of a free sitemeter account, without upgrading to the pro.

Bellow is the trick :
Read more »

How to Remove Site or Blog from Google Friend Connect

2011-11-25T22:58:00.001+07:00

I looked for the menu for removing / deleting the web site or blog from listing of the Google Friend Connect (GFC), because i needed to remove one of my blogs from list of GFC. After a while, the menu was found.

The location is not at the front, we have to goto inside.

• Login to GFC
• Choose a blog or site that we will be deleted / removed
• Click on Settings

Read more »

Login multiple Gmail accounts in the same browser at the same time

2011-11-19T19:31:00.001+07:00

If you have more than one Gmail account , to open the mail usually will log off from one gmail, then log in to another. Unless if you use different web browser (eg mozilla firefox for one gmail, and google chrome for another then we can open simultaneously.
To be able to open multiple Gmail accounts using the same browser at the same time, here is the trick.

Gmail has a Grand access to your Account menu, where one can be delegated to another gmail.

For instance I have 3 (three) Gmail accounts, and will try to open all

• Decide the first gmail / main gmail, that will be used to open other gmails
(mine is kakara00@gmail.com as the main Gmail)
Read more »

How To Resolve The Problem : The Remote Console is unavailable on ILO2 HP Server DL Series

2011-11-16T16:48:00.001+07:00

When using ILO 2 ( Integrated Lights Out ) for remote the HP server, if you get the error like this : The Remote Console is unavailable, it is already in use by a different client, so you could not work with the remote console, although no one else is being remotely to the server.

How to resolve this problem ?

Read more »

How to Update or Synchronizing clock / time on the computer with the time on the internet

2011-11-14T02:21:00.001+07:00

If the time on our computer is wrong, we will usually equate by looking at watch , wall clock, etc. done manually. The accuracy will certainly depend on our watches.

If your computer is connected to the Internet, better for setting the time on the computer using update or synchronize with NTP time servers (Network Time Protocol) on the internet, in order to have a good time and accurately according to the international standard time.

Step to sync time on the computer with the time on the internet :

• Click on the display time / clock in the bottom right of your Windows

How to Create Safely Remove Hardware Shortcut on Desktop

2011-11-12T08:48:00.001+07:00

If you work with external USB Storage media such as USB flashdisk, memory card, external hard drive, or any other external USB drive, you should always do for Safely Remove Hardware before opening or remove that external media, to avoid your data from error.

In order to make easily perform Safely Remove Hardware, you can create it's shortcut on the desktop screen.
The steps to create a shortcut :

• Right click on the desktop => click New => Click Shortcut

How to Disable Data Copy To USB Flashdisk / USB External Disk

2011-11-09T23:13:00.000+07:00

If your laptop or computer is often used by others, while a lot of important data in it, o f course you do not want your data copied by them without permission
To make disable copy to USB external drive or flashdisk, one way is with making change setting in regedit editor

The steps are :

• Press Win + R (to go to Run Command )
• Type Regedit, and then click OK (Will appear Windows Registry Editor )

Type 'regedit' in Run command

How to Extract Images From Ms. Word File

2011-11-07T23:52:00.000+07:00

To take a picture from a Microsoft Word file, the most common way is to select an image, copy and then paste in Ms. Paint or to the Picture editor then Save-as become a new image file.
If the picture is only one or two is not a problem, but if there are a lot of pictures, we'll be bothered having to copy and paste one by one.

Tricks of the easiest to extract pictures from the Microsoft Word file is to go to Save-As menu. Then Save-As the word file to become the web page format.
Image files will be directly stored in a folder automatically.

Read more »

How to Hide Icons, Shortcuts and All, On The Windows Desktop

2011-11-02T00:19:00.002+07:00

If you want your windows computer desktop screen clean from the icons , shortcuts, files and folders or to make better view of background theme, this trick may be useful for you.
The way is through the settings in the Local Group Policy Editor.

• Press Win + R to enter the RUN Command
• Type gpedit.msc, click OK, then it will go to the Local Group Policy Editor

List of Adobe Photoshop Keyboard Shortcuts

2011-10-29T06:02:00.001+07:00

Function	Shortcut
Adjust the auto Contrast	Alt+Shift+Ctrl+L
Adjust the Color and Tone balance	Ctrl+B
Adjust the color levels	Ctrl+L
Adjust the Hue/Saturation	Ctrl+U
Change Page Setup for printing	Ctrl+Shift+P
Copy the selected area	Ctrl+C or F3
Create the Group of layers	Ctrl+G
Create the ungroup of layers	Shift+Ctrl+G
Cut the selected area	Ctrl+X or F2
Deselect all	Ctrl+D
Display the info of opened file	Alt+Shift+Ctrl+I
Extract the selected area	Ctrl+Alt+X
Extract the selected image	Alt+Ctrl+X

How to Hide Text Document Inside Notepad

2011-10-27T01:04:00.000+07:00

If you have personal or confidential text data and want to hide it without sounding hide, Put inside the computer harddisk or other storage media such as external harddisk or flashdisk. There's one way to hide it in Notepad, by using a simple and easy command.
The disk must use NTFS formatted (generally windows now use the NTFS format)

Open Notepad through the Command Prompt (not through Start Programs ==> Acessories)

Default IP Address and Administrator Password for IP Camera Trendnet TV-IP110

2011-10-20T14:51:00.000+07:00

If you lost or forget your password or lost your IP (internet protocol) address for your IP camera Trendnet TV-IP110, the only way is to reset the camera to the default setting. And reconfig the device.
For reseting the device, we can use pencil or ballpoint or something like that, push the reset button located on the back of the device ( press and hold for about 30 seconds when power is on)
Read more »

Where is the Help Menu In Microsoft Office 2007 / 2010?

2011-10-18T13:39:00.001+07:00

Help menu is very useful, especially for those who have not mastered with an application.
For those who were accustomed using Microsoft Excel, Ms. PowerPoint and MS. Word 2003 and now turning to Ms. Office 2007 or MS. Office 2010, will see the different menus, including many who seek where the help menu is.
Read more »

How To Lock the Computer Screen Using Mouse Click

2011-10-16T20:43:00.000+07:00

If you're working with a computer, and must leave it for a moment, to avoid things that are not desirable should not let the screen open, better lock your computer screen.

In Windows (Windows XP, Vista and Windows 7) to lock the computer screen is by pressing the keyboard buttons Win + L
If you want to lock with a click of the mouse, we have to make shortcuts beforehand, make it very easy.

• Right click at the desktop screen
• Click New
• Click Shortcut

• Copy and paste the following code to the column location of the item
rundll32.exe user32.dll, LockWorkStation

• Click Next
• Type the name of the shortcut as you wish
• Click Finish.
There will be a shortcut on the desktop which when we click, will lock the computer screen.

See Also :
• How to Login as Administrator On HP thin Client
• How to Merge text files into one file
• How to go to safe mode without press F8
• How to Disable Shutdown, Restart, Sleep and Hibernate Menu in Windows

How to login as Administrator on HP Thin Client XP embedded

2011-10-14T17:13:00.000+07:00

On Hp (Hewlett Packard) Thin client with Windows XP embedded, when it is turned On, it loading to windows as a user. with limited facilities, no right click, no control panel, etc.
If you want to go as an administrator, follow these steps :

• Press and hold Shift key
Read more »

How to Combine Multiple Text Files into One File

2011-10-12T02:21:00.001+07:00

There is an easy way to combine a number of text files become one text file with a simple command via the command prompt.

Here are the steps:
• Put the files to be merged into one folder
for example I put it in a folder with the name is Merge in drive D

Read more »

Booting into Safe Mode without press F8

2011-10-09T00:12:00.000+07:00

To go to Windows safe mode, we usually using F8 keyboard key, pressing it repeatedly while booting. But sometimes it is not success because of pressing F8 too late or not in the right time, we have to wait for windows to load normally, and restart again to repeat the step pressing F8 when booting to go into safe mode.

To get into safe mode without pressing the F8 key, before you restart the computer, follow these steps

Read more »

How to Disable Shutdown, Restart, Sleep and Hibernate Menu in Windows

2011-10-06T22:15:00.001+07:00

Someday, you might want to make a computer could not be turned off easily. For example because you are running a program that need a long time to wait ( download a big file, rendering a video, etc ). And you have to leave the room. To prevent a friend or anyone else to turn off the computer, then one way is to disable the function of Shutdown, Restart, Sleep or Hibernate menu.

Here are the steps you have to follow :

• Click Start
Read more »

How to Hard Reset Motorola Q / Q9

2011-10-04T22:08:00.000+07:00

Before doing this job, copy all data from the phone.

How to Hard Reset :
• Turn of the device
• Press and hold the E and Z keys

• During hold the E and Z key, press the Power button once.

• When screen displaying, release the E and Z key

•.Press Power button once again.

• Will display message that the phone has been reset

• It takes a few mins to reset. Press the Power button once.

See Also:
• Removing Ask.com From Mozilla Default Search Engine
• How To Know List files in Ziddu
• How to Switch On ATX Power Supply Without Mainboard
• How To Check an Infrared Remote Control

Resolve The Error 912 - The computer has been removed in the HP Compaq dx2700 MT

2011-10-03T20:48:00.000+07:00

On the Desktop computer HP Compaq dx 2700, after opening the cover of CPU case (altough it has been closed back again), when starting the computer, there will be the alarm tone sound is quite disturbing.
And we must press the F1 key to continue loading the OS (Operating System). And this will continue on every time the computer is restarted.

The warning is : error 912 - The computer has been removed. The machinecover has been removed
since last system start up. please Ensure That any system access wasauthorized.

To solve this problem:
Read more »

How to Replace Battery of BIOS / CMOS Desktop Computer

2011-10-01T23:40:00.002+07:00

When the computer is turned on, before entering the OS (operating system)it will be handled by the BIOS (Basic Input Output System) first, initialize the existing hardwares, set some basic configurations (date, time, etc.), and then run the OS.

BIOS configuration is controled by CMOS (Complementary metal oxide semiconductor) and the configuration will be lost (back to the default setting) when the battery is weak or exhausted.

Here is one example of a warning if the bios battery has been weak / exhausted:

Usually we will press F2 to continue, or press F1 to setup. If we press setup (F1) the configuration will be lost again when the computer shutdown.

Read more »

How to Enable Hyper Terminal In Windows 7

2011-09-28T16:33:00.002+07:00

Hyper terminal is used for data communication via serial port com or TCP/IP Winsock. Unfortunately on Windows 7 was not found anymore, even though many of us who still need it, and it is not the solution if we have to downgrade back to Windows XP

There is an easy way to activate or show the Hyper terminal in windows 7, just go to a computer that is still using Windows XP, then Copy the two files associated with hyper terminal, hypertrm.exe and hypertrm.dll

Read more »

List of Microsoft Excel Keyboard Shortcut

2011-09-23T01:53:00.001+07:00

Just as in other Microsoft Office Software, in Microsoft Excel if we want to work faster or you don't like to use a mouse, then you can use keyboard to hit the shortcut key.

Bellow are list of shortcut keys for Ms Excel :

No	Shortcut	Description
1	Ctrl + A	select all
2	Ctrl + B	make Bold
3	Ctrl + I	make italic
4	Ctrl + K	insert link.
5	Ctrl + U	make under line
6	Ctrl + P	Show print dialog
7	Ctrl + Z	Undo
8	F2	Edit selected cell
9	F5	Go to defined cell
10	Shift + F5	showing search form
11	F7	Check spelling
12	F11	making chart
13	Shift + F3	Insert function / formula
14	Ctrl + Shift + ;	Insert time (hour,min)
15	Ctrl + ;	insert date
16	Alt + Shift + F1	new worksheet
17	Ctrl + 5	strikethrough
18	Ctrl + F9	Minimize
19	Ctrl + F10	Maximize
20	Ctrl + F6	Switch between opened excel
21	Ctrl + Page up	toggle beetwen Sheet to the left
22	Ctrl + Page down	toggle beetwen Sheet to the right
23	Ctrl + Tab	toggle beetwen opened excel
24	Alt + =	add sum formula
25	Ctrl + '	inserting the value upside cell
26	Ctrl + Shift + !	Number in coma format
27	Ctrl + Shift + $	currency format
28	Ctrl + Shift + #	date formating
29	Ctrl + Shift + %	formating in percent
30	Ctrl + Shift + ^	format in scient
31	Ctrl + Shift + @	time formating
32	Ctrl + Arrow key	move to next text
33	Ctrl + Space	select all columb
34	Shift + Space	select all row

Kill Task using Click Mouse, Without Ctrl+Alt+Del

2011-09-20T22:40:00.002+07:00

If your program stop working and appears warning Not Responding, we usualy have to kill the process by pressing the combination key Ctrl + Alt + Del to get into task manager to end  the troubled program.

We can also kill Process / End task by using click the mouse, without pressing the Ctrl + Alt + Del

We can make the shortcut for Kill Process, so if we need to make ending task  just Click the shortcut using mouse.

To make the Shortcut
• Right click on the screen on the desktop, click New -> Shortcut
•  In the column type the location of the item copy and paste this code:
taskkill.exe / f / fi "status eq not responding"
• Click Next, click Finish.

See Also :
• How to lock the leftmost column or top row cells in Ms Excel 2007
• How to Remove or Disable Ctrl-Alt-Del when Log in to Windows
• Creating New Folder in Windows 7 without click mouse

Freeze Panes in MS Excel 2007 (lock the leftmost column or top row)

2011-09-18T15:19:00.001+07:00

If you work with spreadsheets with large size, and want the top row or leftmost column (which usually contains a description, number, date, name, etc) are always visible (because of limited display screen of computer), we can use the Freeze Panes tool.

• Open your Excel Spreadsheet Document
• Highlight the cell just below the second row and second column, (assuming the first row and first column to be locked)
• Click the View Tab
• Click Freeze Panes
• Click Freeze Panes,
the row and first column will lock, to see the result try moving to the far down or right side cell.

To restore to its original state (without freeze panes)
• Click the View Tab
• Click the Freeze Panes
• Click unfreeze Panes.

Displaying Random Home Page in Browser

2011-09-17T01:07:00.002+07:00

Want something different every time you open your computer's browser?.

The following interesting web sites provide links to make random page of their articles.
Just put the link on the Home Page settings in your browser, then every time the browser is run, will present a different page.
Read more »

How to Backup and Restore HP ProCurve Switch Configuration via Serial port

2011-09-15T00:29:00.001+07:00

For anticipation loss or destruction the configuration of a managed switch, we should backup the configuration, so if a problem occurs, we can easily restore or copy the configuration file into a new equipment.

For HP ProCurve Networking (switches ProCurve 2910, 2510 series, etc.), one of the way to backup and restore is done through a serial port rs 232, using a hyper terminal connection.

Step by step Backup

Assumptions, Switch has been connected to the computer using a serial cable and use the hyper terminal and logged in as a manager (administrator)

• Type : copy startup-config xmodem pc then hit the enter key
• Click on the Transfer menu and then select Receive File

Read more »

Script to make the computer speaks according to the words we wrote

2011-09-14T19:16:00.002+07:00

With a few script, we can make the computer speak according to the text that we have written.
Follow these steps :

• Open Notepad
• Copy and Paste to notepad these script bellow
Dim message, sapi
message=InputBox("What do you want me to say?","Speak to Me")
Set sapi=CreateObject("sapi.spvoice")
sapi.Speak message

Read more »

Enabling Telnet in Windows 7

2011-09-12T16:54:00.000+07:00

Unlike the previous windows, Windows XP and Windows Vista, Telnet in Windows 7 By default is not activated.

Here are the steps to enable Telnet in Windows 7

Click Start
Click Control Panel
Select View By : Large icons atau small icons ( at the up right of the page )
Select Programs And Features
Click Turn Windows features on or off ( at the up left of the page )
Give a checklist at Telnet Client
Click OK.

How to Disable Ctrl Alt Del when logging on to Windows XP, Vista and Windows 7

2011-08-28T06:10:00.000+07:00

In Microsoft windows, when you will log on to your computer, one of the way is you have to press ctrl + alt + del.
If you want to bypass this way to login or eliminate this requirement for the logon process faster, here is the easiest way.
The tool is for disappearing / bypassing the ctrl alt del, can be downloaded from here
work with windows XP, Vista and Windows 7

If you want to restore back ( logon with using Control Alt Del again )
here is the tool.

Displaying Google Maps on Blog

2011-08-21T11:51:00.006+07:00

If you want to tell or share the location of a place, just open Google maps, specify a location, then do share, you can send via e-mail, instant messenger or post through the blog or website.

For example, in this post I show the picture / photo and would like to inform you the location of the photo using google maps.

The location on google maps :

View Larger Map

Read more »

Entering Into Bios, Sony Vaio VPCS125FG

2011-08-16T21:08:00.000+07:00

Not all of laptops / notebooks showing how to get into the bios setup when the computer is turned on, including the Sony VAIO notebook series VPCS125FG.

On Sony VAIO series VPCS125FG, to get into the bios setup the way is:
Press the Esc key and then F2 (quickly and repeatly) when the laptop is turned on before loading the Operating system.

Creating New Folder Without Using Click Mouse in Windows 7

2011-08-03T21:55:00.000+07:00

When you're working with computer, especially while typing / writing, of course use more keyboard than use mouse click. even you would like to avoid using mouse as much as possible, including when you will create a new folder.

To create a New folder without clicking the mouse, hit CTRL SHIFT N at the same time.

Change The Value of Serial COM Port for USB to Serial in Windows 2000, Windows Me and Windows 98 SE

2011-07-22T22:49:00.000+07:00

Currently it has rarely use Operating system Windows 2000, Windows me, or Windows 98 SE. But for certain purposes still exist, for example, used in a controller device, machine controllers or for other purposes.

When we install an USB to Serial com converter then it will be obtained automatically, for examples COM 5, Com 6, etc.
In Windows 2000, Me or 98 SE, to change the serial com port as we want, for example we want COM 2, we must convert hexa decimal values for the port manually.

Go to Device Manager,
• Windows 2000
Start -> Settings -> Control Panel -> System -> Hardware -> Device Manager
• Windows 98/ME
Start -> Settings -> Control Panel -> System -> Device Manager

Read more »

How to Protect Document Using Password in Ms. Office Word 2007

2011-06-25T06:32:00.001+07:00

In Microsoft Office Word 2007, (same for others office 2007 Ms. excel 2007 and Ms. Power Point 2007) to protect a file or document with a password is very simple,
• Inside the document, Go to Save As ( Klick at Office Button, then klick Save as )

Keyboard Shortcuts For Google Chrome Browser

2011-06-23T07:26:00.001+07:00

For you who used to work using the shortcut, list keyboard shortcuts for Google Chrome browser is likely to be useful.

Below are the lists :

	Action / instruction / Destination	Keyboard Shortcut
1	Bookmark	CTRL+D
2	Chrome Task Manager	SHIFT+ECS
3	Close Google Chrome Window	CTRL+W
4	Download File History	CTRL+J
5	Enter search query at address / go to address bar	CTRL+E
6	Go Backward / Forward	ALT+left Arrow / right Arrow
7	History http://h0w2.blogspot.com	CTRL+H
8	Increase decrease size of Font	CTRL +/-
9	Java Debugger	ALT+`
10	New Google Chrome Window	CTRL+N
11	New Tab	CTRL+T
12	Open Web Page	CTRL+O
13	Print	CTRL+P
14	Private Browsing	CTRL+SHIFT+N
15	Refresh	CTRL+R
16	Reload	F5
17	Search on Page	CTRL+F or F3
18	Select Address bar	ALT+D
19	Show/Hide Bookmark Tool	CTRL+B
20	Switch between Tabs	CTRL+TAB or CTRL+PGUP/PGDW
21	View Source	CTRL+U

Step by Step Backup And Restore Using HP Data Protector

2011-06-16T19:43:00.002+07:00

To understand the mechanism of backup-restore using HP ( Hewlett Packard ) Data Protector needs to be understood first of Architecture HP Data Protector is described as follows:

Architecture of HP Data Protector Backup and Restore based on the concept of Cell. Cell is a network environment, consisting of the Cell Manager, client backup, backup device and the Graphical User Interface (GUI).

Cell Manager is a computer where the Data Protector software installed that serves as a central control point of the backup-restore environment.
Clients are computers that have installed Data Protector software agent, which is the source of data that will be the backup.

Device is a device where the backup data will be stored in the backup media.
GUI is a Graphical User Interface that is used by administrators to configure the backup-restore, manage backup media, backup data, restore data.
In one neighborhood Cell may have only one (1) Cell Manager, but allowed to have more than one installation GUI, more than one Device Backup Tape and more than one client to be backed up, limited by the number of licenses installed.

Read more »

Ranking of Websites in Mid - 2011

2011-06-09T20:05:00.002+07:00

Search analytics firm compete recently released a list of the Top websites for the month of April 2011 according to the number of unique visitors.

Rank	Website Name	Unique Visitors
1	google.com	150,132,536
2	facebook.com	137,917,539
3	yahoo.com	137,281,886
4	youtube.com	123,404,304
5	bing.com	86,836,886
6	wikipedia.org	81,157,591
7	amazon.com	74,978,780
8	msn.com	73,799,209
9	live.com	72,369,485
10	ebay.com	67,372,294
11	blogspot.com	65,940,748
12	microsoft.com	62,162,835
13	craigslist.org	57,500,250
14	ask.com	54,508,628
15	go.com	49,504,372
16	about.com	47,709,562
17	aol.com	46,906,652
18	walmart.com	46,349,561
19	ehow.com	45,960,705
20	answers.com	42,276,025
21	mapquest.com	36,700,156
22	target.com	36,178,431
23	weather.com	33,728,429
24	wordpress.com	33,459,473
25	netflix.com	33,129,869
26	myspace.com	32,876,686
27	paypal.com	31,870,573
28	apple.com	31,103,237
29	adobe.com	31,079,363
30	twitter.com	27,504,233
31	chase.com	26,432,079
32	att.com	25,744,344
33	bankofamerica.com	25,671,467
34	imdb.com	23,787,667
35	groupon.com	23,768,883
36	cnn.com	23,341,250
37	flickr.com	21,514,439
38	photobucket.com	20,523,415
39	comcast.net	20,077,436
40	bestbuy.com	19,690,984
41	yellowpages.com	19,683,713
42	irs.gov	19,682,366
43	jcpenney.com	19,452,462
44	sears.com	19,348,832
45	homedepot.com	19,244,361
46	verizonwireless.com	18,440,068
47	cnet.com	18,405,154
48	comcast.com	18,362,992
49	wellsfargo.com	17,984,172
50	lowes.com	17,949,686

Super Control Panel In Windows 7

2011-06-05T22:25:00.002+07:00

Do you feel confused with the Control Panel in Windows 7 ?, maybe there are some icons are missing or you hard to find what you look for.
Why not try The Super Control Panel, is a very complete control panel.
How to open it, The Super Control Panel ?
• Create a new folder
• Rename it to h0w2.{ED7BA470-8E54-825C-465E-99712043E01C}
Change the red character with yours

Now open the folder, and you already have a super control panel.

Power Efficiency Diagnostics Report In Windows 7

2011-06-05T21:13:00.001+07:00

If you have a laptop/ notebook with windows 7 Operating system, you can use the efficiency calculator to generate loads of useful information about its power consumption. Used in the right way, this can help you make huge gains in terms of battery life and performance.

• Go to command prompt as an administrator by typing cmd in Start Search,

• At the command line, type powercfg -energy and hit Enter,

The system will scan and looking for ways to improve power efficiency. wait for a moment, It will then publish the results in an HTML file.

Custom Power Button in Windows 7

2011-06-04T10:59:00.001+07:00

In Windows 7, by default Power button is set to Shut down, we can make custom become Restart, Hibernate, Sleep, etc.
• Right click at Start, click properties
• At Tab Start Menu, Go to Power Button Action, and you can choose other buttons,
Read more »

Switch Display to External Monitor or to LCD Projector in Windows 7

2011-06-02T17:43:00.001+07:00

Other than using the function keys (FN+F5, FN+F7, etc, according to brand of laptop / notebook), windows 7 provides a standard way to switch your computer display from one monitor to another, or to the LCD projector,

Just press Win+P, the menu for switching / selecting display will appear.

Or Go to Run command and type DisplaySwitch then press Enter.

Choose your preferred display. (This is only effect if you have plugged external monitor or LCD projector to the VGA out port of your computer / laptop ).

Displaying And Using Check Boxes To Select Multiple Files In Windows 7 Explorer

2011-05-22T01:43:00.002+07:00

Checkbox in explorer, click on image to enlarge

In order to select multiple files for an operation such as copying, moving or deleting in Windows 7 explorer, you generally use the keyboard and the mouse, Shift or Ctrl + clicking every file you want to select. But if you're mouse-centric, there's a way to select multiple files in Windows 7 using only your mouse, via check boxes. To do it:
Read more »

Make The Picture looks Old, Without Using Editing Software

2011-05-16T03:16:00.003+07:00

Want to make your photos look old without picture editing software like photoshop,
Go to http://vintagejs.com
vintagejs is a online tool where you can upload your new digital images (photos) and make them appear old with sepia tones and blurred edges in few easy clicks.

Unlike most other web-based photo editing tool, vintage JS is written completely in HTML5 and is open-source so you may even host it on to your own servers.

Also, it uses data URIs to render images and the various filters are applied via jquery at the client’s computer itself so the thing should work in offline mode as well..

Trick To Clean Pins Of Physical Memory ( RAM ) From Dirt

2011-05-02T16:09:00.010+07:00

The cause of computer errors can be variative, one of them could be caused by dirty pins of physical RAM (Random Access Memory) which causing the imperfect connections between pins and terminals in the Computer mainboard .
Dirty on pins memory can make computers work slowly, often hangs, or computer even die at all.

Read more »

Always Delete History In Mozilla Firefox When Exit

2011-04-29T01:11:00.002+07:00

At default, mozilla firefox browser save all history items, to make easy if we need the information in the next time.
But if you don't want mozilla to save the history, it is not difficult. Every time when we exit from mozilla we can set the browser to delete / remove the history automatically.

For the newer version of mozilla:
• Go to Menu Tools, then click Options

• Click on the Privacy option.
• Under History Firefox will section, choose Never Remember History

• Click OK

For the older version of Mozilla :

• Go to Menu Tools, then click Options
• Click on the Privacy option.
• Under the Private Data section, tick the Always clear my private data when I close Firefox check box option.
• Click OK

See Also :
• How To Resize Picture (reduce file size) Using MS Outlook

How to know the color hexadecimal value of the picture or screen display

2011-04-25T21:07:00.005+07:00

If you see the specific color of one picture or displayed in the computer screen, and you want to copy that color to your project, so your project have the same color. How to do that?

You have to know the hexa value of that color.

To know the hexadecimal value of the picture color we need the tool called WhatColor, download here, stand alone file small size, about 200KB for windows.

How to separate two words within a single cell to be divided in two cell in Ms Excel

2011-04-24T15:22:00.002+07:00

To separate the two words within a single cell in Microsoft Excel to be divided into two cells, means each word occupies one cell, it's not difficult. using this formula.

For example we have the data below

To separate it into two cells, the formula is :
• For the first new cell =MID(A1,1,SEARCH(" ",A1))

How To Move Cursor Faster Using Keyboard

2011-04-24T01:54:00.003+07:00

When you are typing, reading or editing the document on the computer, you get a black flashing line that shows you where you are typing. The black flashing line is called the cursor.

To make position the cursor exactly where you want it, it is often easier to use the keyboard arrow keys, rather than the mouse.

• When we press the Left or the Right arrow key, cursor will move per character
• When we press the UP or the DOWN arrow key, cursor will move per line,

• When we press and hold the Left or the Right arrow key, cursor will keep moving per character faster
• When we press and hold the UP or the DOWN arrow key, cursor will keep moving per line faster,

• If you press and hold the Ctrl key (control key), and then press the Right arrow key or the Left Arrow key, the cursor will jump to the previous or next word
Read more »

How to Delete The File or Folder Permanently in Windows

2011-04-23T07:34:00.002+07:00

When we delete the file in windows, it move to the Recycle Bin, useful for avoid unwanted file deleteted or maybe oneday we still need.
But if you are sure the files no longer needed, or need for space in hard disk without go to the recycle bin,
there is nothing wrong if delete permanently.
Just Press and hold SHIFT key at the same time when you are deleting the file, the file will be deleted forever permanently.

Slang, Informal Words and Expressions in SMS or Social Networking

2011-04-23T02:59:00.003+07:00

Sometimes when you chat, in sms or social networking (facebook, twitter, etc.), someone writes abbreviation words, and you don't understand what it means.
The following lists are commonly abbreviated words and the meaning,

SLANG	MEANS
ASAP	As Soon As Possible
ASL	Tell me your Age, Sex and Location
B4	Before
bbz	Babes
BFF	Best Friends Forever
BRB	Be right back
BTW	By The Way
CMIIW	Correct me if I'm wrong
FB	Facebook
FFS	For fuck's sake
FYI	For Your Information
GM	Good Morning
GN	Good Night
gr8	Great http://h0w2.blogspot.com
GTFO	Get the fuck out
IDK	I don’t Know
IMHO	In my humble opinion

How to Disable Autorun / Autoplay in Windows Xp

2011-04-22T18:51:00.011+07:00

Many viruses get into computers through autoplay or autorun as usbdisk drive or flash memory.
To make Disable the function of autorun in Windows XP

Using Group Policy Editor (GP Edit)

1. Click Start , Click Run
2. type gpedit.msc and Click OK

How to Download Online Flash Games, And Play Offline

2011-04-17T22:34:00.002+07:00

There are many online flash games now on the internet.
In this trick, how to download that online flash games and play offline.

First, what we have to do is to download the SWF file from the address where the flash game is.
for example my flash game is from gamesfree.com, the complete address for the game is http://www.gamesfree.com/game/cow_marathon.html

• An easy way to download is using file2hd.com
Open your browser, go to http://www.file2hd.com
Read more »

How to Zoom in and Zoom out The Page in The Browser

2011-04-16T21:54:00.003+07:00

When you are surfing on the internet, sometimes you find the page with the font size too small or too big.
And of course you want the perfect size , comfortable according to you. so we need to zoom in or zoom out.

For all browsers ( Mozilla firefox, Opera, Safari, Chrome ) the keyboard shortcut key to make zoom in or zoom out are the same.
Press Ctrl + + to make Zoom in
Press Ctrl - - to make Zoom out
Press Ctrl 0 to go back to the Original size.

See also :
Mozilla Firefox Keyboard Shortcut

How to Force Log In To Remote Desktop Computer When The Session is Already Full

2011-04-16T19:35:00.007+07:00

Usually in the Windows remote desktop, if the session is full we have to wait for other user to logoff.
but sometimes we need to go to remote desktop immediately and can not wait because an important thing.

If you need to force, follow this trick :
- From the Start menu click RUN Command
- type mstsc /console /v:nameserver or ip address of remote computer /admin
for example: mstsc /console /v:192.168.0.10 /admin
- Click OK

Script for Making Flip Text

2011-04-16T13:42:00.043+07:00

As you can see at page here, making flip text,

Below is the script for making that flip text.

How to Know If Someone Entering Your Computer When You're Online

2011-04-16T11:02:00.000+07:00

To know if someone entering (hacking) your computer when you are online, is with her/his Ip Address.
In windows To know what's an IP address that entering your computer :
Go to Start --> RUN --> type CMD (to go to command prompt page) , click OK
Then type netstat -an press Enter key

How to Stop Autoplay With Simple

2011-04-14T22:22:00.001+07:00

Most of virus entering your computer through USB Flashdisk with an autorun file when inserting the disk.
If you are not sure whether the flashdisk have an autorun virus or not, just press and hold SHIFT key when inserting the flashdisk, It will make disable autoplay process, and block the aplication start automatically.

How to Shut Down Your Computer at Specific Time

2011-04-14T17:10:00.000+07:00

You can shut down your windows computer at the specific time (scheduled) with easy command, using no software.
Just Go to RUN Command, and type for example : at 09:30 shutdown -s then click OK
To Cancel, Go to Run Command again and type shutdown -a

How to Know Your Computer's IP Address

2011-04-13T07:50:00.000+07:00

To know your computer's IP Address in Ms Windows
Go to Start --> RUN --> type CMD (to go to command prompt page)

Type ipconfig then press Enter, or for detail information, type ipconfig /all press Enter

The result will be displayed.

Making Horizontal Line in MS Office 2007 With Very Easy Way

2011-04-12T11:32:00.000+07:00

In Microsoft Office word 2007, we can make horizontal line with keyboard shortcuts, it is very easy,

If you want to make standard line, type: --- (3 dashes) then press Enter key

Or type: _ _ _ ( 3 underscores), press Enter key

Type: *** (3 asterisk signs) and press Enter. the result will be like this :

Type: = = = (3 equal signs) and then press Enter. the result will be like this :

How To Make Default Saving Format Office 2007 Always To Office 2003

2011-04-10T01:25:00.002+07:00

As we all know that the document written in Microsoft Office 2007 format can't be read with Ms Office 2003, except in Office 2003 has plugin for reading 2007 format.
In this tips, how to make default saving office 2007 format is always to Office 2003 format.

Run MS Office word 2007
1. Click at Office logo
2. Click word option
Read more »

Forget Administrator Password in Windows XP, Vista, And Windows 7

2011-04-09T21:11:00.010+07:00

If we forget password for user account in windows, it doesn't really matter, because still can be reset using administrator account. but if we forget password for administrator account, of course this is a problem, because can't be reset by user account.

fortunatelly, we have tool for reset this administrator password.
The tool can be downloaded from here..size is about 3MB

After download, extract the file, there is an ISO file, then burn it to the CD with option burn image to disk (nero), because the CD is needed for booting the computer.
For Windows 7, just right click the Iso file then choose burn image to disk *

Read more »

Mozilla Firefox Keyboard Shortcut

2011-04-09T14:07:00.000+07:00

When we are surfing in the internet sometimes we need to use shortcuts to make it more quickly to a specific command,

Below are list of keyboard shortcuts in mozilla firefox

	Command Navigation	Shortcut

1	Back	Alt + Left Arrow
		Backspace
2	Forward	Alt+ Right Arrow
		Shift+Backspace
3	Home	Alt+Home
4	Open File	Ctrl+O
5	Reload	F5
		Ctrl+R
6	Reload (override cache)	Ctrl+F5
		Ctrl+Shift+R
7	Stop	Esc

Removing Ask.com From Mozilla Default Search Engine

2011-04-09T06:16:00.002+07:00

Maybe you never know why default search engine become ask.com, because you installed free software, installed tool bar , etc.
And now you want to remove it and back to became google.com search as default search engine.

• Open your firefox browser
• In the address bar of your browser, type: about:config click Go or press Enter,
• Click I'll be careful, I promise

Read more »

How To Know List files in Ziddu

2011-04-08T08:26:00.000+07:00

To know List files in Ziddu, type or click this address :
http://www.ziddu.com/root/urllist1.txt
For next page, just change the number of txt file
http://www.ziddu.com/root/urllist2.txt
http://www.ziddu.com/root/urllist3.txt
http://www.ziddu.com/root/urllist4.txt and so on..

How to Switch On ATX Power Supply Without Mainboard

2011-04-08T03:45:00.002+07:00

Each computer must have a power supply in it. Desktop computers nowadays normally use power supply ATX (Advanced Technology Extended).

ATX power supply can also be used outside the CPU casing, for example due to the addition of hard drives, CD / DVD drive, or other peripherals, (because the internal power is not enough or the connector is used up.)
Read more »

How To Check an Infrared Remote Control

2011-04-08T02:34:00.000+07:00

Most of remote control using IR (infrared) signal for operation.
The infrared singnal can't be seen with our eye. but with digital camera, it can be seen.
So, if you want to know whether an infra red remote control (TV, air conditioning, etc.) the function is Ok or not, or want to know the battery is still good or weak, take your digital camera, you can also using hand phone camera.
• Turn on the digital camera and switch to camera position function.
• Press and hold one of buttons of the remote control
• Use the camera to see infrared light of the remote control
• Look at the camera monitor, if the remote control is in good condition, then the light from the infrared remote control will be seen on the camera screen brightly.