Skip to main content

Posts

Showing posts from June, 2014

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'…

How to Put Blogger Site Offline?

Both Blogger and WordPress have an option to put the site offline or make it unavailable permanently or temporarily. You may need to put your site offline for a number of reasons. In this post, I will just talk about how to limit access to a blogger site. At the same time, you can deny the search engines to access your site and you can also restrict general people to view your contents. 


As mentioned earlier, there could be several reasons behind putting the site offline. Such as - 

You can restrict search engines to crawl your site. Because you would like to decorate your site first. In that case you can limit search engines' access. You may need to make your site unavailable temporarily due to political violations or religious issues. Or may be the site could be a private one. Maybe it's subject to be unavailable to the public. 
Whatever the reason, or even if you don't need to put your site offline, at least you should know the way. Some bloggers even think, why I put my s…

How to Change the Folder Icon?

By default, Windows folders look like a yellow folder. And if you use any custom theme, it may change. Many of you might know how to customize the Windows Folder Icon. It's very easy to change. Previously I discussed about how to change the pen drive/ hard drives icon. Today I'm gonna discuss about changing the folder icon. 

It's been few months when I published any Windows trick. Sorry for the long break!

To change the folder icon is much easier than changing the drive icon. If you wanna change the drive icon, you have to use an autorun file. But you don't need any notepad file to change the folder icon. All you need is just an icon format (must be .ico) image. 

First collect an icon format image. You can convert an image into icon in any of the following ways: Create Icon using IcoFx (Only 1.62 MB)Convert Image into Icon Online
I prefer using IcoFx. Download it and convert your image into icon within seconds. After getting the icon, you can go for the next step.


Change Fol…

How to Rotate Text in Excel

When you're running out of space to write column headings in MS Excel, you can rotate  your texts. In my last post, I discussed how to wrap text to create multiple lines in a cell. But if you don't have sufficient option to create multiple lines, then you can rorate your text by some degrees. And definitely it will save your column space. 

Maybe most of you are familiar with text rotation. But I'm sharing this tips for the beginners. You will get the text rotation option at the same place where the wrap text is located. Both of them are located in the Alignment Tab in Format Cells dialogue box. 


Shortcut Method
If you're using Excel 2007/ 2010, you can easily rotate text from ribbon. Go to the Home tab and then move to the Alignment section. Look at the image below:



First you have to select the cell which you wanna rotate. Then go to the text rotation icon and choose your desired rotation style. 

If you'd like to explore more options then press Shift+Ctrl+F > Go to t…

Type Multiple Lines in a Cell in Excel

Excel users often face a common problem. Normally you can't type two or three words in a cell in Microsoft Excel. You have to merge cells to type something. But if you have no option to merge cell horizontally then you may fall in trouble. Believe it or not, last week I had the same problem while working in a worksheet! 

Today I am sharing the solution with you. Look at the image below - 



By default, you can't type like the image above in MS Excel. Have you noticed - I haven't merge the rows or colums. And there are 3 lines in Column A and 4 lines in Column B. Try to type multiple lines in a row or cell. Simply you can't. You have to use the Wrap Text option to type multiple lines in a cell. 


For Excel 2003
Sorry to say, I don't have Microsoft Office 2003. So I can't show you the path. Probably you have to follow this way- 
Format Menu > Font > Format Cells > Alignment > Text Control > Wrap Tex (Check the box) > OK. 
I'm not sure about this comm…

Change Photoshop Transparency Grid Color!!

If you're a Photoshop user, you must know about transparency grid. Transparency Grid is a checkerboard which appears when you're working with an image with transparent background. If your image has no color in the background, this checkerboard appears behind the image. 

Okay fine. Transparency will be indicated by the checkerboard. But you may ask, why I will change the color of transparency grid. In this post I'm gonna answer this question. And I will also show, how to change the color of the transparency grid. 


Why to Change? 
Suppose you've an image with white background. And you need to remove this background behind the image. You know there are different ways to remove background. I'm not gonna discuss it here. 
In the critical part of the image, Magic selection tool may not be able to select the white part. In that situation you can manually select the unselected portion. But you may also fail remove the white background properly. Because you can't select the…

Twist Image by Liquify Effect

By default, Adobe Photoshop contains numerous attractive effects/ filters. And you can also add third party filters if you want. Today I will show the use of liquify filter which can be used to twist an image or object. And it's really a useful tool when you need to distort the photos of your friends! You can make their faces bizarre! :) 


I'm using Photoshop CS5 Extended Version. Hopefully the commands and options will be almost same with other versions of Photoshop. Let's start - 


Run Photoshop and open an image from your hard disk. Now go to the Filter Menu and choose Liquify (Shift+Ctrl+X).Now your image will be opened in a new window. Mouse pointer will take the form of a plus sign with circle. Hit and move the pointer over the image. Rotate and twist the image as your wish. If you're done press OK. Or if you wanna cancel, hit the Cancel button or press Esc. 
There are some additional options too! Look at the tools panel of liquify filter - 


By default, you're gett…

Working with Photoshop Color Range

Photoshop guys are very familiar with the color range option of Adobe Photoshop. Color range command is a great tool for selecting the areas of an image based on sampled color. And it's somewhat similar to Magic Wand Tool. In Magic Wand Tool you need to manually click on the areas of an image that needs to be selected. But if you use the color range option, you just need to choose the sample color. And Photoshop will make the selection by itself! 

This tutorial applies to all running versions of Adobe Photoshop including CS4, CS5 and CS6. But I've prepared the tutorial using Photoshop CS5. All the images of this post will be based on Photoshop CS5. 


Color Range
Color Range belongs to the Selection part of Photoshop. You will find it under the Select Menu. Run Photoshop from your PC > Open an image from your hard disk > Go to the Select menu > Choose Color Range. You will get the following image: 




Have you noticed Marks PC Logo on color range window? Here the white part is…