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:

  1. Open Excel Options.
  2. Click on the File tab and in the left panel, then click Options.
  3. Click on Advanced menu in the left column.
  4. 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.
excel 2010 option advanced display no comment or indicator

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: (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:
  • 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

Wednesday, September 12, 2012

How to calculate year, month and day between 2 cells in MS Excel 2010

Sometimes we need to calculate year, month and day between 2 cells in  Microsoft Excel.
For example, You have an employees database in excel that record the date they joined the company and then you want to know "how long each employee has worked for the company until now?"

In the such above case, I do the following in Microsoft Excel 2010:

  • I Input the "signed date" in cell C3 after "No" in cell C1 and "Full Name" in cell C2.
  • Make sure to assign "Date" as Cell Format for Cell C3.
  • I input =NOW() in Cell C4 and this will show the current date.
  • And the calculation begin in cell C5.
  • In cell C5, I put formula like this: =DATEDIF(C3,C4,"y") & " years, " & DATEDIF(C3,C4,"ym") & " months, " & DATEDIF(C3,C4,"md") & " days"
  • And the result of the above formula is like this: 19 years, 3 months, 11 days.

If you do not want to show the "day", just cut the last part of the formula (& DATEDIF(C3,C4,"md") & " days").

So now, you know how to calculate year, month and day between 2 cells in MS Excel 2010.

Do you have other formula to calculate the same above case?
Please share on the comment below.
Thank You

Monday, August 6, 2012

How to do a mx lookup in win 7

Sometimes we need to know whether our mx records are configured correctly.

How to do it in Win 7?

Here are the step:
Go to start button, All Program
Go to accessories menu
Click on Command Prompt

command prompt menu in win 7

command prompt window

After the Command Prompt window appear, do this:
type: "nslookup" and press enter
type: "set type=mx" and press enter
type "the domain name which you want to check its mx configuration"
command prompt nslookup exe

command prompt nslookup exe set type mx domain

All done, and you will see the result

Still having problem?
You can ask in the comment bellow.

Thursday, July 12, 2012

How to give a color in Microsoft Office Excel cell

Some time we want to highlight some cell in Microsoft Office Excel which we considered as important or give stressed for a certain term.

How to do that? Below are the instruction, especially for MS Office Excel 2007 that we can use conditional formating