First of all, you need to save the "connection" that you want to assign a static IP Address.
Then Go to "Networks and Connections".
Then to "Wi-Fi Network".
Then to "Saved Wi-Fi Networks".
Choose the network you want to assign a static IP Address (The Network that you have saved before).
Uncheck the box next to "Automatically obtain IP address and DNS" to show the static IP Address form.
Enter your networking information (IP Address, SubNet Mask,Router, DNS).
Hit the "Save and Connect" button.
After this, you should connect to the network you want.
I hope this guide would help.
All (not) Open Source
I believe,.. God is the only owner of all knowledge. We knew something, just because God teached us through our live experiences. Knowledge sharing is good for better future.
Tuesday, October 8, 2013
Saturday, February 9, 2013
Video Tutorial on Programming
Free Hosting
Wednesday, October 3, 2012
How to Hide Comment in Excel 2010 Worksheet
Every month I receive an excel file from my colleague that contains a recapitulation of employee attendance data and my coworkers insert comments in cells which provide explanations on the day an employee is absent.
This of course is a very good thing because I could easily see the reason why one employee did not come to work that day. However, because of all the comments displayed, then it becomes a mess. So to read the comments of the adjacent cell, then I have to close the comments one by one.
Actually excel has provided comments and indicator display options, which we can set it in the Excel Options. Here's how:

This of course is a very good thing because I could easily see the reason why one employee did not come to work that day. However, because of all the comments displayed, then it becomes a mess. So to read the comments of the adjacent cell, then I have to close the comments one by one.
Actually excel has provided comments and indicator display options, which we can set it in the Excel Options. Here's how:
- Open Excel Options.
- Click on the File tab and in the left panel, then click Options.
- Click on Advanced menu in the left column.
- Scroll down to the Display section then go to "For cells with comments, show:"
- Select "No comments or indicators" if you want to hide all comments and indicators, then click OK.
- Select "Indicators only, and comments on hover" if you want to hide all comments but still show the red indicators, then click OK. In this setting you can mouse over on the red indicator in the cell to show the comment.
- Select "comments or indicators" if you want to show all comments and indicators, then click OK.

And now you have some options to display comments and indicator in Excel 2010 work sheet. Still has a problem on this? Write your question below.
Tuesday, October 2, 2012
Your server's SSL certificate for cpanel will expire in less than 30 days
I managed CentOs Server with Cpanel inside.
One day, I receive warning like this:
Your server's SSL certificate for cpanel will expire in less than 30 days. You need to install a new certificate as soon as possible. You can install a new certificate using WHM's "Manage Service SSL Certificates" interface: https://my.server. com:2087/scripts2/ manageservicecrts (Main >> Service Configuration >> Manage Service SSL Certificates).
This warning is not indicate a problem in my server. This just a warning that I need to reset SSL certificate on my server. So here the solution to this warning:
One day, I receive warning like this:
Your server's SSL certificate for cpanel will expire in less than 30 days. You need to install a new certificate as soon as possible. You can install a new certificate using WHM's "Manage Service SSL Certificates" interface: https://my.server.
This warning is not indicate a problem in my server. This just a warning that I need to reset SSL certificate on my server. So here the solution to this warning:
- I Login to my server via WHM.
- Then I Go to "Service Configuration" menu and then to "Manage Service SSL Certificates" sub menu.
- I Click "Reset Certificate" button that corresponding to the service which need a new certificate.
- After that the self signed certificate is renewed for one year ahead.
I hope the above explanation will give solution to all of you too. Do you? Send your experience below
Subscribe to:
Posts (Atom)