Skip to main content


Showing posts from May, 2012

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 Disable CD/ DVD Drives?

This is a very funny trick as well as very useful when you trying to prevent your friends from using your CD/ DVD Drive. If you can successfully do it, your CD/ DVD drive will not function until and unless you enable it. Let's have a try. First, right click on My Computer icon from desktop and select Manage. Now you'll be able to a new window named Computer Management.Look at the left panel and hit on Device Manager. Now the list of devices of your computer will appear. Search for CD/ DVD Drives.Now collapse the CD/ DVD section by clicking the arrow.Now right click on the Drive and choose Disable. From now CD/ DVD drive will not be able to play any disk. But you can just open and close it. 

To enable the CD/ DVD drive, follow the same procedure. All you need to do is just choose enable in the step 6.
Note: In this way you can disable your Mouse, Keyboard, Modem, USB Port too! Choose Uninstall if you don't see the Disable option. If you uninstall your Mouse or Keyboard they…

How to Reduce Windows Start up Time?

A common complaint of PC users is My PC is Too Slow! And it takes a long time to start. And they would like to install Windows again. And after few days they face the same problem. Because the problem was not fixed at all! 
Actually I'd the same problem few years ago. But now I enjoy a fast start up!

Do you like to start your Windows faster? Then follow some simple steps below:

Go to Run by pressing Start Key + R.Type msconfig and press Enter. Now you'll find a a new window named System Configuration. Click on Startup Tab from this window.Here you'll find a list of option with check mark. All you need to do is just deselect these options except antivirus, graphics driver, sound driver and few essential programs.

Definitely this work will reduce your booting time. And don't keep any unnecessary software installed on your PC. And remember, the fewer the number of programs installed on your PC the better the performance. And don't forget to delete the temp file (%tmp%…

How to Backup Firefox Data?

When a person remove his operating system and install it again, he loses all programs that were installed previously. Sometimes we have many necessary web addresses, bookmarks saved in web browsers. And these information also lost.
But Firefox users should not lose anything. Firefox provides a way to backup all data stored on it. In this post I am gonna show you the way to backup your Firefox data. 
There are two ways to back up the Firefox data. One way is to copy the whole installed file from program file. Follow the steps below:  First go to My Computer.Then open your C Drive (or where your windows is located)Then Open Program Files FolderNow look for Mozilla Firefox install location. And copy the whole folder in your desired location.When you re install windows on your PC then go to that folder again that you copied earlier. And find a file named firefox.exe. Double click in this file and your Firefox will start. 
Note: In this way you can backup almost all browsers. 

Another way w…

How to Create a Master Password in Firefox?

Earlier I wrote about how to set a strong password either for online or for computer security. If you wanna know how to create a strong password, read this post
Today's world is based on online. Few years ago, only people with IT profession used to live with computer, internet and technology. But today, a very normal person has to depend on information technology. He has to create Email IDs, Online Accounts and he has to remember the passwords too! 
For different reasons a person naturally needs to have more than one Email ID. And he may have many online accounts. And to remember the ID and password as well as type them again and again is a boring job. To ease the users' work every browser offers to save password and username. 
To be honest, to save password is really helpful for users. But at the cost of security who wants to save his password? 
When you save your password and if someone has access to your computer then he might see your password! 
To protect users' privacy …

How to Show Text Boundaries in MS Word?

When you install MS Office on Your Computer, by default there are some settings that may need to be changed due increase to your convenience. 
The most common problem for every user is to show text boundaries in MS Word after installing Microsoft Office Pack. Text Boundaries show the printable area for text so that a user can easily  understand the layout of the page. 
By default, MS Word shows no text boundary in the document. And this is very bothering personally for me. So, in this post, I'm gonna show you how to set text boundaries in MS Word document.

For Office 2000/ XP/ 2003 Users: 
At first open MS Word. Then go to the Options under the Tools Menu and hit on the View Tab. Now at the bottom of the window you will see an option named Text Boundaries. Now simply place a Check Mark on Text Boundaries. Your Problem gets solved! 
Note: Make sure you're using print layout option. To show your document in Print Layout, go to the View Menu and select Print Layout

For Office 2007…

How to Enable or Disable Registry Editor?

In my previous post I showed how to enable Windows Task Manager. 
To know how to enable Task Manager Click here
In this post I am gonna show how to enable or disable Registry Editor. For this purpose I'm gonna use Group Policy Editor to recover Registry Editor. 
Registry Editor works as registry editing tool provided with each and every version of Windows operating system. It can be disabled, blocked or locked to prevent the regedit from being run or executed by users in order to protect important system registry. A virus can also disable Registry Editor.
Registry Editor can be opened from Run by typing regedit. If it is disabled then you will see the following error message: 

Don't worry if you lose control over Registry Editor. Because if you can follow some easy steps then you'll be able to recover it. Lets try it:  First of all you should open Run by pressing Start + R. Then type gpedit.msc and hit enter.Now you'll see Group Policy Editor Window.Locate Administrativ…

How to Enable Task Manager?

Windows task manager may be lost due to the virus. A virus often take over the control of your PC and disable many functions. And this is very irritating.
When task manager lost due to the virus it creates many problems. When a user press Ctrl+Alt+Del task manager appears on the screen. But if it is lost then he may get a error message like this: 

In this post I am gonna show you how to recover the task manager if this happens. It's a quite easy procedure. Just follow the steps:
Open Run (Press Start + R) Type gpedit.msc and hit enterNow you will see a windows named Group Policy EditorNow hit on Administrative Template under User ConfigurationNow double click on System and then double click on Ctrl+Alt+Del OptionsDouble Click on Remove Task ManagerNow select Disable to activate Task Manager and hit OK button Note: If you wanna disable task manager then follow the steps again and in the last step, choose enable and hit OK button. 
Read this post to activate Registry Editor (Regedit)…

Top Keyboard Shortcuts for Twitter!

In my previous post I've provided some useful Keyboard Shortcuts of Facebook. And in this post I am giving the shortcuts for twitter. 
Twitter is a popular social networking site. And day by day its popularity is increasing rapidly. More than 50 million tweets in a single day and 600 tweets just in a second! Can you imagine? Many users are moving to the twitter leaving Facebook. 
Twitter provides some useful shortcuts to accelerate the users' experience. The shortcuts for twitter are very very cool. It is very easy to use. I think the shortcuts of twitter are the easiest shortcuts to memorize.  
The following table will show you the shortcuts. Don't press the two shortcuts button at a time. Press the first one and then second respectively.

ActionsNavigationTimeline FFavourite?This MenuGHHomeRReplyJNext TweetGCConnectTRetweetKPrevious TweetGAActivityMDirect MessageSpacePage DownGRMentionsNNew Tweet/SearchGDDiscoverEnterTweet Details.New TweetsGPProfileLClose All Open Tweets

Keyboard Shortcuts for Facebook!

Millions of internet users visit Facebook everyday. But most of them are not familiar with the keyboard shortcuts available for using Facebook! These shortcuts can accelerate your experience with Facebook.
For the convenience of users most the shortcuts have been created with the numbers. In this post I'm gonna provide you these shortcuts for your convenience: 

Alt+? or /: SearchAlt+m: Compose a new messageAlt+1: Home pageAlt+2: Your profile pageAlt+3: Friend requestsAlt+4: Your messagesAlt+5: NotificationsAlt+6: Account pageAlt+7: PrivacyAlt+8: About FacebookAlt+9: Facebook Terms/AgreementAlt+0: Facebook help center NOTE:  If you're on a Mac then you need to add Ctrl+Option+ to each of the shortcuts. (ie. Ctrl+Opt+?) In Firefox, you'll need to add a Shift key to the combination. (ie. Shift+Alt+?) On Internet Explorer, combinations will be the same. Additionally you'll have to press enter to confirm the each combination.  Visit here to know more about these shortcuts


MS Word 2010 Exam: Practical Sheet

MS Word is a popular word processing program all over the world. The latest version of Microsoft Office is 2010. In this post I'm giving you a practical test sheet for MS Word 2003.
Your job is to make a sheet like the pdf file in the download link. 
If you are capable of making a sheet like this, then your MS Word practical knowledge will be considered as very high. So, let's try it.
Download the file from here.

Stay with Marks PC Solution to get more interesting IT topic!

How to Make a Strong Password?

Password has been integrated to our daily activities. The whole world is being operating through computers, networks and Internet. And lots of information are there. And we have to keep those information password protected. 

But there are some people who may hijack your information for their own benefits. And if you use a password which is easy to guess or break, then you might be in trouble. So, it's important to build a strong password for your digital devices, web accounts or network access. 

In this post, I would like to share some tips which may help you build strong passwords. Try to apply these tricks: 

Password Should be Long Enough: A long password is always stronger than a short one. Use at least 10 characters (or more) in your password.Make it Complex: To be strong, the password should be complex. Combine letters, symbols, numbers or special characters (!, @, #, %, &) in your password. And it should not be easy to guess. Use Space within Password: You can also use spac…

How to Measure the Rank of a Website?

The ranking of a website depends on several factors. It depends on Google Page Rank (known as PR), Alexa Traffic Rank, Number of Backlinks, Social Sharing and so many. And to check the status of a site, there are hundreds of extensions available for Internet browsers. And some websites also help you measure the site's worth ie. Stat my Web

But my personal choice for this purpose is Web RankToolbar. You can install this toolbar with your browser. And you can check the status of any site within seconds. Today I'm gonna show you how to install this toolbar on Firefox and Google Chrome.
Follow the steps below:
First, make sure you are using Google Chrome or Firefox.If you are a chrome user then click here. And Firefox users can use this link.Chrome users will get several toolbars with Web Rank SEO. You can choose either the first one or any other toolbar as you like and then hit on Add to Chrome. And Firefox users should click on Add to Firefox button. Then click on install. Firef…

How to set a password on logon screen?

Most of the computer users are familiar with user account password. It can be set during the windows startup. It prevents the unauthorized access to a computer. But this password can only protect you from a normal user. An expert can easily break this and have access to your computer.
But in this post I am gonna show you a trick that can add an extra layer of security of your computer.
Follow the steps below:Press Start + R to open RunType syskey in the Run and press enterNow hit yes and then update (Make sure that Encryption enabled option is selected)Whenever you hit on update immediately a new window named Startup Key will appearNow select Password StartupType your password here and confirm it then hit ok.

Note: Remember, if you enable this password once then it can’t be disabled. You can change the password only. You can also hide the password box during the startup.  To do so, repeat the steps 1 to 4 and in the step 5 select System Generated Password and Store Startup Key Locally…