Monday, November 24, 2014

MS EXCEL: PROTECT A CELL IN EXCEL 2010

This Excel tutorial explains how to protect a cell in Excel 2007, 2010 and above (with screenshots and step-by-step instructions).

Question: How do I protect a cell from being edited by others in Microsoft Excel 2010?

Answer: First, you'll need to unprotect all of the cells on your sheet. To do this, select all of the rows and columns in your sheet. Right-click on then select "Format Cells" from the popup menu.

When the Format Cells window appears, select the Protection tab. Uncheck the "Locked" checkbox. Click on the OK button.

Next, select the cell(s) that you wish to protect. Right-click and then select "Format Cells" from the popup menu.

When the Format Cells window appears, select the Protection tab. Check the "Locked" checkbox. Click the OK button.

For the locking of the cells to take effect, you must also protect the worksheet. To do this, select the Review tab from the toolbar at the top of the screen. Then click on Protect Sheet button.

A "Protect Sheet" window will appear. You may enter a password to protect the sheet if you wish. The password is optional. Click on the OK button.

Note:-

First of all Select Whole Excel Worksheet (Ctrl+A+A) and Right-click and then select "Format Cells" from the popup menu. When the Format Cells window appears, select the Protection tab. Uncheck the "Locked" checkbox. Click the OK button.

Wednesday, November 19, 2014

Google Hindi Input tool for Android Devices

Google Hindi Input

What's New

- New Material dark and light UI

- Hindi Handwriting

- Voice Input

- Hinglish Dictionary, which suggests Hinglish words when user types English / Hinglish

- Dynamic change of the consonant / vowel compound forms: In the Hindi keyboard, when user types a consonant, the vowels on the top row changes into the consonant / vowel compound forms

- Emoji keyboard

- New Hindi keyboard on tablet

- More accurate transliteration and Hindi candidate suggestions

Description

Google Hindi Input is an Indic keyboard which allows you to type messages, update on social networks or compose emails in Hindi on your Android phone. If you can read नमस्ते correctly on your phone, then you may install and use Google Hindi Input, otherwise your phone may not support Devanagari script.

How can I enable it and set it as the default input method/keyboard on my Android phone?
- On Android 5.x and newer versions:
Open Settings -> Language & Input, under “KEYBOARD & INPUT METHODS” section, go to Current Keyboard -> Choose Keyboards -> Check “Google Hindi Input” -> back to “Language & input” -> Current Keyboard -> Select “Hinglish & Hindi Google Hindi Input”
When typing in an input box, you can also change the default input method by clicking the keyboard icon on the bottom right corner of the screen.

- On Android 4.x:
Open Settings -> Language & Input, under “KEYBOARD & INPUT METHODS” section, check Google Hindi Input, then click Default and select “Hindi” in the “Choose input method” dialog.
When typing in an input box, you can also change the default input method by selecting “Choose input method” in the Notification area.

How can I enable/disable Hinglish, Hindi or handwriting keyboard?
Go to Settings->Language & Input->Google Hindi Input->Keyboard, under “Select keyboard type” section, check the keyboard types you like.

How can I change keyboard theme?
Pick the theme you like at Settings->Language & Input->Google Hindi Input->Keyboard->Keyboard theme.

How can I use this application?

Hindi transliteration
- Toggle the button “a->अ” on English keyboard to turn on/off transliteration mode.
- In the transliteration mode, you can type Hindi word in English characters and the app will convert them to Hindi.
- For example, type “hindi” and then you will get the word हिंदी from a list.

English
- By turning off the transliteration mode on English keyboard (by pressing the button “a->अ” again), you can type in English.

Hindi keyboard
- Toggle the globe button to switch between English and Hindi keyboard
- Vowels are changed to matra automatically after typing consonants.
- Long press characters(vowels and consonants) to type variations of characters. For example, long press “ई” you can type “ई” or “ी”, long press “क” you can type क, कं, क्र or र्क.

Download

Wednesday, November 12, 2014