Skip to main content

Posts

Showing posts from December, 2015

Featured Post

Changing Digit Grouping (Comma Style) in MS Excel - Million to Lakh

Well this is a very common problem for our sub-continent i.e. Bangladesh, India, Pakistan, Nepal, Maldives, Sri Lanka. Cause our digit grouping system doesn't match with the international system. To be more specific - they use million, billion etc. But we use - lakh (also lac), crore etc. 
Users of the mentioned regions often face problem with the comma separator position in MS Excel. Cause the default system is international. It doesn't suit our digit grouping system. 
International System - Separates every three digits 1,000.0010,000.00100,000.001,000,000.001,000,000,000.00
Subcontinental System - Separates every two digits after the 1st three digits
1,000.0010,000.00 1,00,000.001,00,00,000.001,00,00,00,000.00 
If you're familiar with the Indian Subcontinent system and if you're bound to use this system then it will be a big trouble if you don't know the solution. Well nothing to worry about as you are going through this article. Cause from the very next moment you'…

Working with Photoshop Pattern Maker

Pattern maker is really a smart tool to create pattern from an image or drawing. In this post, I'm gonna tell you about Photoshop Pattern Maker. After completing this lesson, you will be able to create beautiful and eye-catching patterns from simple drawing or image!



Creating Patterns from Image

You can create pattern from any image. I'm gonna show you an illustration - 





I will use the above image to create a pattern. I'm gonna open this image through Photoshop CS6. 


Filter > Pattern Maker . . .






Now look at the image below - 





As soon as you choose Pattern Maker, you will get this window. Look at the area I've selected as my pattern area. 

You can choose any area to create a pattern. 


Select your area > Hit on the Generate button > You will get a patter > Hit Generate again to create a different pattern > You will be able to create 20 different patterns.


You can also change the values of the options as marked by a rectangle in the image above. Changing the default…

Add your Signature to Gmail Messages

Many of you might be familiar with the Auto Signature feature of Gmail. But you need to add this manually and it requires to be turned on by the user himself. Let's see how to add this . . . 


About Gmail Signature
When we write a letter to someone, we normally sign at the end of that letter. In case of email messages, signing is not that important. 

But in case of official email messages, we usually mention our name, designation and organization. 

But you don't need to do this manually every time. If you type few words (what may be included as signature) in the signature option and enable it, Gmail will do the rest automatically.




Add your Signature

Sign in to your Gmail ID.Hit on the Settings Gear from the top right corner and choose Settings.Now make sure you're in the General tab.There are lots of options under General. Scroll down and find the option - Signature.By default, No Signature option might be selected. You've to select the next radio button to enable it.Now type…

Hide Spelling & Grammar Errors in MS Word

When we type something wrong (typo) in MS Word, either in terms of grammar or spelling, the Spelling & Grammar Checker automatically detects the errors. And then we see a red underline for spelling error and blue underline for grammar error. And that's pretty useful and essential for preparing a correct document.

But sometimes, this automatic error detection marks may cause your headache. Maybe you're preparing something which is correct but not supported by traditional spelling and grammar rules. In that time, those error marks (red and blue underlines) look odd. Let's hide them! 

Applies to: Office 2007Office 2010Office 2013Office 2016
Hide Spelling & Grammar Errors . . . Open up an MS Word document from your PC.Hit on the File button from upper left corner & select Options.Now choose Proofing option from the left pane.Scroll down to the bottom and find the Exceptions for section.If you wanna hide the errors for all new documents in the future then choose, All New…