How to lock cells in Excel

There were times that we students don't want to show how we came up with calculations to our teachers or peers for fear of them using it to their advantage for submitting their sheets in lesser period of time, when you have done all the researching and they will simply benefit from it. Call it selfish but for me it's precaution, so they will do their part.

Here's how:
1. Select all the cells of the sheet.
    Right click any cell, Format Cells
    @ Protection Tab, uncheck Locked
    OK
2. Select all the column or select the group of cells to lock
    Right click, Format Cells
    @ Protection Tab, check Lock
    OK
3. @ ribbon, click on Review Tab
    Protect Sheet
    Tick all except Locked Cells
    Put password on top, reenter password, OK

To end: count then share blessings like Web traffic exchange to others

Setting Blackberry "Desktop" contacts for display

Scenario: You connected the Blackberry phone to Outlook to transfer the contacts from BB to Outlook. On the phone, there are 250 contacts. But what is showing before synching is only 50. Where are the 200 staying from?

1. Check the BB phone if it has more than 1 email configured.
2. Next is to check the contacts from which it is displaying from, just verify if the contacts that are being displayed are coming from SIM, email1, email 2, or Desktop accounts, so you can identify the quantity of contacts and target each source differently.

From the scenario above, I have confirmed that the 50 contacts are coming from Gmail account, the other 200 contacts are from "Desktop" that I don't know what it is.
Anyway, I was able to figure out the solution to extract all 250 contacts from BB to Outlook. Pls follow the steps below:

1. Click Options
2. Device
3. Advanced System Settings
4. Default Services
5. Select Contact List (SYNC)
6. Select Desktop instead of the current selected, a Gmail account.
7. Save.
8. Now you're ready to sync it to Outlook.

Do the process of synching the BB to Outlook from this link.
Get the first 200 contacts, then go back to the default Gmail contacts and sync again into Outlook, by adding into the current Outlook contacts. You will be having the 250 contacts afterwards.

To end: count then share blessings like Web traffic exchange to others

CD/DVD drive is not detectable

If the CD drive is not listed from "My Computer", pls click this link first before doing the below steps.
There is a CD that can upgrade your current operating system to a new OS, aside from the usual genuine Windows CD that would cost more than the upgrade version. Unfortunately, there are times that when you upgrade it, suddenly the CD/DVD drive is not recognizable anymore. Going into registry of the computer is very critical coz 1 data entry change will make the computer non-working. Carefully follow the steps below.

I. DELETING UPPER FILTER
1. Click Start, type regedit at Run
2. In Registry Editor, expand My Computer, then expand HKEY_LOCAL_MACHINE
3. Expand SYSTEM, then CurrentControlSet
4. Expand Control, then Class
5. Click 4D36E965-E325-11CE-BFC1-08002BE10318
6. On the right, click UpperFilters
7. On the Edit Menu, click Delete

II. DELETING LOWER FILTER
1. Perform Steps 1-5 above
6. On the right pane, click LowerFilters
7. On the Edit Menu, click Delete

Exit Registry and restart the computer. This is mandatory for values to take effect.

To end: count then share blessings like Web traffic exchange to others

How to transfer contacts and BBM contacts into Z10

RIM provides username and password to:

1. Download apps into your BB phone

2. Save your BBM contacts

3. other perks for using BB

Transferring the contacts from old BB to new Z10 is a piece of cake. Before Z10, all BB are using Blackberry Desktop Manager to transfer data from one BB to another. With Z10, you have to use a new software called Blackberry Link. Open it.

It is recommended to connect the old BB and the Z10 at the same time in doing the transfer.

1. There is called "Data Transfer" on the BB Link , click this and follow the prompt on the screen.  

2. Select the items that you would like to copy from old BB like contacts, calendar, sms, etc. Tick the boxes.

3. Then click on Transfer at the bottom right.

4. Be patient in using the software since it would take time to transfer the items, specially if you have loads of information from old phone, like 5 minutes or more.

For BBM contacts, use the username and password that you used in your old BB and sign into Z10 using the same. If you don't remember your BB userid and pwd, retrieve them using a link "Forgot password" and retrive the information using the email that you used in creating the BB userid. 

If BBM contacts can't be transferred, use manual invites to contacts.

There is another way of transferring the data using BB Protect. It is a cloud service to where you can save your phone information on the cloud prior to transferring them to Z10. Use the old BB phone in downloading this from AppsWorld and save whatever you needed saving, then on Z10, download the same and recover whatever you have saved.

To end: count then share blessings like Web traffic exchange to others

NOKIA808 41MP IS HERE?

I was once an avid Nokia fan because of it's user-friendly interface. Sad to say that it's now being used mostly by our grannies and pops coz it is easier to navigate and is a no brainer cp. While smart phones are arguably smart (can't wait to get a hand on Samsung S3, the fastest phone so far), this Nokia 808 Pure View is rocking the camera phone world with its astounding 41MP feature, the Guinness book of record holder, to say the least.

Thanks to gsmarena.com

Well, what do you need the 41MP for when it is backed up by an aging Symbian OS, oh it's a new version of symbian: Nokia Belle. Alright, why does Nokia advertises new OS on new design on new phone, like Windows Phone and upgrading the Symbian OS in succession of what months, quarterly maybe? against most phones clinging into Android? Why don't Nokia join the bandwagon of creating new phones with android and if they want to segway into Windows phone at least the phone is as cool as the new arrivals too. Wouldn't be a good competition? People used to love Nokia because of its innovation, now other brands are replacing it coz of better OS:android.

Jelly Bean is the latest of Android OS and it will be a lot cooler if this 41MP will be used on that OS, rather than staying in archaic Symbian. Just a thought, maybe.

To end: count then share blessings like Web traffic exchange to others