msExcel 2003 - Center Title using merge button

One of the best benefits of using msExcel for students, company or any other projects is its easy to create a good looking presentation. On this blog, i just tackle one of the basic button MERGE available as button of the toolbar. Its primary purpose is to combine selected cells into one. This button with a very simple functions of merging cells into one can be use to create a good looking presentation and neat data tabulation. So, let's talk and follow the short and simple steps i have provided below:

1) Highlight the title or text that you've wanted to be centered or contained into one cell. For example, below title was type in column A and aligned on the left side of the table. Highlight it to select column A to Column K.






















2) Once highlighted, click on Merge button as shown below:






















3) After clicking Merge button, result will be the same as shown below. Notice that columns A to K after merging has been combine as one whole cell.

Set Windows XP IP Address to Obtain address automatically

Internet Protocol address (IP address) are sets of numbers assigned to a computer or devices participating in a network. This unique sets of numbers used by computer make them able to share files, communicate and connect to internet to share information, download and upload files. Sometimes, when connecting to internet makes it difficult or there's a problem in the connection by Resetting it to its Default values can help to resolve the problem. On this blog, we will talk how to reset IP address to its Default value so that network will determine automatically what IP address it can used and available.

Below are just one of the solutions available we can set IP address to obtain automatically its address.

Let's Start:

1) Click on Start --> Control Panel as shown below.




















2) Once Control Panel window opens, click on Network and Internet Connections.
(Below view is in Category View)

3) Network and Internet Connections window will open, click on Network Connections.

















4) Once window for Network Connections open, right-click on Local Area Connection --> Properties.

















5) Under General tab, select Internet Protocol (TCP/IP) --> and click on Properties.

6) Window for Internet Protocol (TCP/IP) Properties will open, below it select Obtain an IP address automatically and make sure that Obtain DNS server address automatically will also be selected then clicked Ok.
Notice that as shown below Use the following IP address and Use the following DNS server addresses are selected and a value is set, once obtain an IP address is set to automatic those box portion will be blank or no value.




















7) After clicking OK, box portion will be blanked as shown below.




















8) Its Finished. Restart you computer and try to connect to internet.