Skip to main content

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

Keyboard Shortcuts for MS Word (All Versions)

MS Word is the best program for typing. To accelerate your work there are lots of keyboard shortcuts provided with the program. Some of the important keyboard shortcuts provided by the official support page of Microsoft are listed below: 



      Command Name                            Shortcut Keys
   --------------------------------------------------------

   All Caps                      CTRL+SHIFT+A
   Annotation                    ALT+CTRL+M
   App Maximize                  ALT+F10
   App Restore                   ALT+F5
   Apply Heading1                ALT+CTRL+1
   Apply Heading2                ALT+CTRL+2
   Apply Heading3                ALT+CTRL+3
   Apply List Bullet             CTRL+SHIFT+L
   Auto Format                   ALT+CTRL+K
   Auto Text                     F3 or ALT+CTRL+V
   Bold                          CTRL+B or CTRL+SHIFT+B
   Bookmark                      CTRL+SHIFT+F5
   Browse Next                   CTRL+PAGE DOWN
   Browse Previous               CTRL+PAGE UP
   Browse Sel                    ALT+CTRL+HOME
   Cancel                        ESC
   Center Para                   CTRL+E
   Change Case                   SHIFT+F3
   Char Left                     LEFT
   Char Left Extend              SHIFT+LEFT
   Char Right                    RIGHT
   Char Right Extend             SHIFT+RIGHT
   Clear                         DELETE
   Close or Exit                 ALT+F4
   Close Pane                    ALT+SHIFT+C
   Column Break                  CTRL+SHIFT+ENTER
   Column Select                 CTRL+SHIFT+F8
   Copy                          CTRL+C or CTRL+INSERT
   Copy Format                   CTRL+SHIFT+C
   Copy Text                     SHIFT+F2
   Create Auto Text              ALT+F3
   Customize Add Menu            ALT+CTRL+=
   Customize Keyboard            ALT+CTRL+NUM +
   Customize Remove Menu         ALT+CTRL+-
   Cut                           CTRL+X or SHIFT+DELETE
   Date Field                    ALT+SHIFT+D
   Delete Back Word              CTRL+BACKSPACE
   Delete Word                   CTRL+DELETE
   Dictionary                    ALT+SHIFT+F7
   Do Field Click                ALT+SHIFT+F9
   Doc Close                     CTRL+W or CTRL+F4
   Doc Maximize                  CTRL+F10
   Doc Move                      CTRL+F7
   Doc Restore                   CTRL+F5
   Doc Size                      CTRL+F8
   Doc Split                     ALT+CTRL+S
   Double Underline              CTRL+SHIFT+D
   End of Column                 ALT+PAGE DOWN
   End of Column                 ALT+SHIFT+PAGE DOWN
   End of Doc Extend             CTRL+SHIFT+END
   End of Document               CTRL+END
   End of Line                   END
   End of Line Extend            SHIFT+END
   End of Row                    ALT+END
   End of Row                    ALT+SHIFT+END
   End of Window                 ALT+CTRL+PAGE DOWN
   End of Window Extend          ALT+CTRL+SHIFT+PAGE DOWN
   Endnote Now                   ALT+CTRL+D
   Extend Selection              F8
   Field Chars                   CTRL+F9
   Field Codes                   ALT+F9
   Find                          CTRL+F
   Font                          CTRL+D or CTRL+SHIFT+F
   Font Size Select              CTRL+SHIFT+P
   Footnote Now                  ALT+CTRL+F
   Go Back                       SHIFT+F5 or ALT+CTRL+Z
   Go To                         CTRL+G or F5
   Grow Font                     CTRL+SHIFT+.
   Grow Font One Point           CTRL+]
   Hanging Indent                CTRL+T
   Header Footer Link            ALT+SHIFT+R
   Help                          F1
   Hidden                        CTRL+SHIFT+H
   Hyperlink                     CTRL+K
   Indent                        CTRL+M
   Italic                        CTRL+I or CTRL+SHIFT+I
   Justify Para                  CTRL+J
   Left Para                     CTRL+L
   Line Down                     DOWN
   Line Down Extend              SHIFT+DOWN
   Line Up                       UP
   Line Up Extend                SHIFT+UP
   List Num Field                ALT+CTRL+L
   Lock Fields                   CTRL+3 or CTRL+F11
   Macro                         ALT+F8
   Mail Merge Check              ALT+SHIFT+K
   Mail Merge Edit Data Source   ALT+SHIFT+E 
   Mail Merge to Doc             ALT+SHIFT+N
   Mail Merge to Printer         ALT+SHIFT+M
   Mark Citation                 ALT+SHIFT+I
   Mark Index Entry              ALT+SHIFT+X
   Mark Table of Contents Entry  ALT+SHIFT+O
   Menu Mode                     F10
   Merge Field                   ALT+SHIFT+F
   Microsoft Script Editor       ALT+SHIFT+F11
   Microsoft System Info         ALT+CTRL+F1
   Move Text                     F2
   New                           CTRL+N
   Next Cell                     TAB
   Next Field                    F11 or ALT+F1
   Next Misspelling              ALT+F7
   Next Object                   ALT+DOWN
   Next Window                   CTRL+F6 or ALT+F6
   Normal                        ALT+CTRL+N
   Normal Style                  CTRL+SHIFT+N or ALT+SHIFT+CLEAR (NUM 5)
   Open                          CTRL+O or CTRL+F12 or ALT+CTRL+F2
   Open or Close Up Para         CTRL+0
   Other Pane                    F6 or SHIFT+F6
   Outline                       ALT+CTRL+O
   Outline Collapse              ALT+SHIFT+- or ALT+SHIFT+NUM -
   Outline Demote                ALT+SHIFT+RIGHT
   Outline Expand                ALT+SHIFT+=
   Outline Expand                ALT+SHIFT+NUM +
   Outline Move Down             ALT+SHIFT+DOWN
   Outline Move Up               ALT+SHIFT+UP
   Outline Promote               ALT+SHIFT+LEFT
   Outline Show First Line       ALT+SHIFT+L
   Overtype                      INSERT
   Page                          ALT+CTRL+P
   Page Break                    CTRL+ENTER
   Page Down                     PAGE DOWN
   Page Down Extend              SHIFT+PAGE DOWN
   Page Field                    ALT+SHIFT+P
   Page Up                       PAGE UP
   Page Up Extend                SHIFT+PAGE UP
   Para Down                     CTRL+DOWN
   Para Down Extend              CTRL+SHIFT+DOWN
   Para Up                       CTRL+UP
   Para Up Extend                CTRL+SHIFT+UP
   Paste                         CTRL+V or SHIFT+INSERT
   Paste Format                  CTRL+SHIFT+V
   Prev Cell                     SHIFT+TAB
   Prev Field                    SHIFT+F11 or ALT+SHIFT+F1
   Prev Object                   ALT+UP
   Prev Window                   CTRL+SHIFT+F6 or ALT+SHIFT+F6
   Print                         CTRL+P or CTRL+SHIFT+F12
   Print Preview                 CTRL+F2 or ALT+CTRL+I
   Proofing                      F7
   Redo                          ALT+SHIFT+BACKSPACE
   Redo or Repeat                CTRL+Y or F4 or ALT+ENTER
   Repeat Find                   SHIFT+F4 or ALT+CTRL+Y
   Replace                       CTRL+H
   Reset Char                    CTRL+SPACE or CTRL+SHIFT+Z
   Reset Para                    CTRL+Q
   Revision Marks Toggle         CTRL+SHIFT+E
   Right Para                    CTRL+R
   Save                          CTRL+S or SHIFT+F12 or ALT+SHIFT+F2
   Save As                       F12
   Select All                    CTRL+A or CTRL+CLEAR(NUM 5)or CTRL+NUM 5
   Select Table                  ALT+CLEAR (NUM 5)
   Show All                      CTRL+SHIFT+8
   Show All Headings             ALT+SHIFT+A
   Show Heading1                 ALT+SHIFT+1
   Show Heading2                 ALT+SHIFT+2
   Show Heading3                 ALT+SHIFT+3
   Show Heading4                 ALT+SHIFT+4
   Show Heading5                 ALT+SHIFT+5
   Show Heading6                 ALT+SHIFT+6
   Show Heading7                 ALT+SHIFT+7
   Show Heading8                 ALT+SHIFT+8
   Show Heading9                 ALT+SHIFT+9
   Shrink Font                   CTRL+SHIFT+,
   Shrink Font One Point         CTRL+[
   Small Caps                    CTRL+SHIFT+K
   Space Para1                   CTRL+1
   Space Para15                  CTRL+5
   Space Para2                   CTRL+2
   Spike                         CTRL+SHIFT+F3 or CTRL+F3
   Start of Column               ALT+PAGE UP
   Start of Column               ALT+SHIFT+PAGE UP
   Start of Doc Extend           CTRL+SHIFT+HOME
   Start of Document             CTRL+HOME
   Start of Line                 HOME
   Start of Line Extend          SHIFT+HOME
   Start of Row                  ALT+HOME
   Start of Row                  ALT+SHIFT+HOME
   Start of Window               ALT+CTRL+PAGE UP
   Start of Window Extend        ALT+CTRL+SHIFT+PAGE UP
   Style                         CTRL+SHIFT+S
   Subscript                     CTRL+=
   Superscript                   CTRL+SHIFT+=
   Symbol Font                   CTRL+SHIFT+Q
   Thesaurus                     SHIFT+F7
   Time Field                    ALT+SHIFT+T
   Toggle Field Display          SHIFT+F9
   Toggle Master Subdocs         CTRL+\ 
   Tool                          SHIFT+F1
   Un Hang                       CTRL+SHIFT+T
   Un Indent                     CTRL+SHIFT+M
   Underline                     CTRL+U or CTRL+SHIFT+U
   Undo                          CTRL+Z or ALT+BACKSPACE
   Unlink Fields                 CTRL+6 or CTRL+SHIFT+F9
   Unlock Fields                 CTRL+4 or CTRL+SHIFT+F11
   Update Auto Format            ALT+CTRL+U
   Update Fields                 F9 or ALT+SHIFT+U
   Update Source                 CTRL+SHIFT+F7
   VBCode                        ALT+F11
   Web Go Back                   ALT+LEFT
   Web Go Forward                ALT+RIGHT
   Word Left                     CTRL+LEFT
   Word Left Extend              CTRL+SHIFT+LEFT
   Word Right                    CTRL+RIGHT
   Word Right Extend             CTRL+SHIFT+RIGHT
   Word Underline                CTRL+SHIFT+W
To know more, click here. 


Comments

Popular Posts

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them. 
To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs. 

I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side. 

You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom. 

EffectCheat CodeAdrenaline ModeMUNASEFAll Cars ExplodeALLCARSGOBOOMAll Cars Have NitroCOXEFGU or SPEEDFREAKAll Green LightsZEII…

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!!






About the Activator Name: KMSPico 10.1.5File Size: 3 MB (Approx)File Type: Zipped Folder100% Neat & Clean - No virus!

Activating Capacity . . .
KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010Windows 10, 8.1 & 8Hopefully this version will work for both 32 bit & 64 bit versions of Windows.








Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else.Install it as trial version without any key.Use the following activator . . .

Download > Install > Enjoy . . . Get the file from here. The first link i…

Office 2010 Activator (KMS) !!

Day by day cracking has been a tough job. But yet very possible. Earlier a software may require only serial key to activate. But today there are many other options. Sometimes you might be asked to connect to the internet to activate or sometimes you're asked to make a phone call! 






Microsoft Office 2010 has the same problem. It is not simply activated by the CD key. Sometimes CD key may not be asked during the installation process. If you're required to enter serial then try any of the following:



YF79C-7Y4B4-PGM89-6BKGJ-46PBT

FC7HF-CF42G-MX6D7-8K9T7-BT9QT

2PWHY-KT4X6-96PYW-XQR7V-HW2W9
PYMDW-8DFY2-Y68BB-XHDGD-CT443
7XD2X-JWJ94-BCHBW-W9WXP-J2WPT
P6RW8-B8X84-FFK73-4BPWM-KRHX3


After installing a trial version of Office 2010 you're allowed to use it for 30 days only. After that it will ruin your peace. It will give you continuous love messages each time you start office. Today I'm gonna share an activator by which you can activate Office 2010 and stop unwanted love messages by MS Of…

Office 2013 Activator (KMSpico 10.1.5)

KMSpico 9.1.3 is really an amazing tool for activating Office 2013. And as a bonus, you can also activate Windows 8 or 8.1 with this activator. Earlier I shared different activators for Office and Windows. And those activators are working fine. If you can't activate your Office or Windows by those activators, then you can try this one. 





I've got Microsoft Office Professional Plus 2013 (final version) last week. And before that I was using Office 2010. After installing Office 2013, I was unable to use it before activating. And with this KMSpico 9.1.3 my Office gets activated within minutes. It's very easy to use! 






Furthermore, this KMS is capable of activating -  Windows 8 and 8.1 (All Versions) Windows Vista and 7 (Business, Professional & Enterprise Edition)Office 2010 and 2013Windows Server 2008/2008R2Windows Server 2012/2012R2

Activation Procedure: Download the KMSpico 10.1.5 from Here.Now double click on it. And follow the manual include inside.Press Next > Accept ter…

IDM 7.2 Portable Free Download!!

There is nothing new to tell about Internet Download Manager (IDM). Most of you are familiar with this amazing download accelerator. But still people look for the cracked version of IDM. Version changes over time. And people try to get the new activated version. Today I'm gonna share IDM 7.2 (Portable) with you! 

Before I begin, I should declare that this is not a registered version of IDM actually. But the settings of this IDM are modified. You don't need to upgrade or register this version. After 30 days, you will not get the notifications to upgrade. And you will enjoy all the advantages just like a registered version. 
But there is nothing to worry about. You can download this portable version of IDM without hesitation. It's just 4.7 MB. You don't need to install it. This version will never demand serial from you. And the download link is 100% free from ads, spams or malware.


Downlaod IDM 7.2 Portable either from Link 1 or Link 2. Unzip the folder and move it to your …

Download GTA Vice City Cheat Codes (PDF)

Couple of years ago, GTA Vice City was one of the most popular game. GTA games are always preferred by the gamers. Most of the GTA games like Vicy City, Liberty City, San Andreas have cheat codes. With these cheat codes, you can complete missions easily. When something is very difficult to perform normally, you can use cheats. 

Here I'm gonna share 32 selected cheats with you. I've omitted the unnecessary cheats. And these cheats are also applicable for GTA Liberty City!


Press any of the below cheats while playing the game. The right part of the table contains the cheats and the left part contains the results. 

Effect
Cheat Code All Cars are FasterGet There FastArmorPrecious ProtectionBetter Driving SkillGrip is EverythingCaddyBetter Than WalkingCars Float on WaterSea WaysCars FlyAirshipCars FlyingCome Fly With MeClear Wanted LevelLeave Me AloneCommit SuicideI cant take it any moreDestroy All CarsBig BangFast CarGet There QuicklyFaster Game ClockLife is passing me byFaster Game Pla…

How to Disable Word Verification (Captcha) in Blogger Comment

By default blogger blogs are designed to show word verification when visitors comment in a post. Though this is a very useful tool to avoid spam, but real users often get bored by this option. Besides blogger has an automatic spam checking tool. So you can remove the word verification option from the comment in order to let your visitors express their opinion easily. 
While commenting on blogger blogs or other websites you may face a word challenge. And this is a very common thing. Specially when you open any online account. Sometimes words used in the verification option are too hard to guess. And users are very annoyed with this. 


Look at the image above. When you comment on blogger blogs or someone comments on your blog he/she will face a challenge like this. Normally this option doesn't show any hard challenge. But sometimes they are also difficult to guess. Users have to try this again and again. If they are annoyed they will loose interest to express their opinion. 

Since blogg…

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing.

Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing. 


Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout. 





Download the PDF file from the button below. Follow my instructions properly. And I can guarantee you will be able t…

Disable Automatic Update in Windows 10

As I mentioned earlier, Windows 10 has come with some boring changes. One of the stupid changes is related to Automatic Update. In Windows 10, you're set to automatically install new updates. And you've no choice to change this settings. Because the change settings option is disable. 


Applies to: Windows 10




Disable Automatic Update (Final Edition)



When you Disable Automatic Update?

If your net bandwidth is limitedIf you don't need windows updates at allIf the updates cause activators not work in your PC
In earlier versions of Windows (Windows 7, 8 or 8.1), you can manually configure the update settings. There were four settings: Install updates automaticallyDownload updates but let me choose whether to install themCheck for updates but let me choose . . . Never check for updates
In Windows 10, you don't have any option to choose any of these settings. It's simply disabled. You can't use the drop down menu. Look at the image below:




But still you have a chance to configu…