Category Archives: technology

Mac shortcuts

Some important (sometimes) for Mac

  1. To force quite application – Command+Option+Esc
  2. To show desktop – fn+F11 (volume down)
  3. To open a file – Command+O
  4. To open spotlight (quick launcher) – Command+space bar
  5. To screenshot and auto create file on desktop
  6. To screenshot but just copy in clipboard
  7. To insert row in Google spreadsheet – select whole row and cmd + alt + + OR
    cmd + alt + + then choose R

To check and add internet quota for celcom

Send SMS to 22188

VOL STATUS – to check status
BROADBAND VOL – to top up

To purchase:

ON VOL100MB – to top up 100 MB
ON VOL500MB – to top up 500 MB
ON VOL1GB – to top up 1 GB
ON VOL5GB – to top up 5 GB

Below is sample messages sent to 22188 and response received on 1GB purchase.

celcom data check and top up

2nd CNAME for blogspot

Google just introduced another security level to set custom domain for blogspot.com. Besides normal ghs.google.com to be added to the CNAME record in domain, user needs to add another 2nd unique CNAME record.

You can get the 2nd CNAME by following below steps

1. Go to blogger setting for any blog

Settings > Basic

2. Under “Publishing”, click on “Add a custom domain”
3. Click “Switch to advanced settings”
4. Enter your registered domain name
5. Click “settings instructions”

6. Choose type of domain to install.

e.g.  “On a top-level domain (www.example.com).”

7. Get the CNAME under “CNAME” subject

Add two CNAME records. For the first CNAME, where it says Name, Label or Host enter “qprm” and where it says Destination, Target or Points To enter “ghs.google.com” . For the second CNAME, enter “OKQFRCLFFBSL” as the Name and “gv-MK4QLTUM3XARQLGY4ZBLD6ZMRAERAEF72BQBZAZMNN26JVOAZ6AH.domainverify.googlehosted.com.” as the Destination. See our detailed instructions on providing CNAMEs for various registrars. If yours isn’t listed, or if you run into
other difficulties, contact your registrar directly and they can help you out.

Remove contact from google app contact list

I tried to remove a contact of a friend since he has a new email address. Few times I mistakenly sent to his old email address. But I couldn’t found where to go about to remove the old email address.

After wandering around, I found this hidden link to contact to remove a friend’s contact.

Click on the “Contact” link

Search for a contact

Click on the More > Delete contact

You are done removing a contact in your contact list.

To take a screenshot with Mac

Command-Shift-3: Take a screenshot of the screen, and save it as a file on the desktop
Command-Shift-4, then select an area: Take a screenshot of an area and save it as a file on the desktop
Command-Shift-4, then space, then click a window: Take a screenshot of a window and save it as a file on the desktop
Command-Control-Shift-3: Take a screenshot of the screen, and save it to the clipboard
Command-Control-Shift-4, then select an area: Take a screenshot of an area and save it to the clipboard
Command-Control-Shift-4, then space, then click a window: Take a screenshot of a window and save it to the clipboard

Barcode generator on Excel

To use excel to generate a bar code is easy.

1. Download free barcode font

2. Copy the font files to c:\windows\fonts

3. Open an excel file with 2 columns. One column for normal character and another column for barcode.

4. On the second column, paste this formula =CONCATENATE(“*”,A1,”*”)

For open office calc use this formula  =CONCATENATE(“*”;A1;”*”)

5. Choose the “Free 3 of 9 Extended” font

6. Adjust the font size accordingly to get a bigger barcode size

Use custom domain with blogger

If you want to use your own custom domain for blogspot.com

In your domain control panel

1. Update CNAME record

www.yourdomain.com -> ghs.google.com

*also applicable for any other subdomains

2. Update A records (for naked domain. i.e. yourdomain.com – without the www in front)

216.239.32.21
216.239.34.21
216.239.36.21
216.239.38.21

In your blogger setting

Settings -> Publishing -> Custom Domain -> Switch to advanced settings

Enter your domain name and the word verification then “Save Setting”

Refer here for google guide