Pages

Powered by Blogger.

My name is Mohd-Danish This blog is for education purpose only.

Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.
Use at your own risk.
Mouse shortcuts

ShortcutDescription
Double-click (on a cell)Edit the cell contents.
Double-click (on a row/column divider)Adjust height/width to auto-fit
High-light headers of multiple rows/columns then Double-click on a row/column dividerAdjust height/width to auto-fit of all high-lighted rows/columns
Triple-clickSelect the entire contents in the cell
Click on row/column divider then dragAdjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then dragAdjust height/width of the rows/colunns
Ctrl + Mouse wheelZooms in and out of document.
Hold Shift + Click the cellsSelect multiple cells


Keyboard shortcuts

ShortcutDescription
F2Edit the selected cell.
F5Goto a specific cell. For example, C6.
F7Spell check selected text and/or document.
F11Create chart.
Ctrl + ASelect all.
Ctrl + BBold.
Ctrl + CCopy.
Ctrl + FFind (same as Shift + F5).
Ctrl + GGo To.
Ctrl + HReplace.
Ctrl + IItalic.
Ctrl + KInsert link.
Ctrl + NNew Workbook.
Ctrl + OOpen Workbook.
Ctrl + PPrint dialog.
Ctrl + SSave.
Ctrl + UUnderline.
Ctrl + VPaste.
Ctrl + ZUndo.
Ctrl + YRedo.
Ctrl + XCut.
Ctrl + 5Strikethrough text.
Ctrl + F3Define Name.
Ctrl + F4Exit Excel.
Ctrl + F6Switch between open workbooks.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize current window.
Shift + F1Activate Help on Item.
Shift + F2Insert Comments
Shift + F3Insert Function.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Ctrl + Page downMove to next worksheet.
Ctrl + Page upMove to previous worksheet.
Ctrl + Shift + #Number Format: Date
Ctrl + Shift + @Number Format: Time.
Ctrl + Shift + !Number Format: Commas.
Ctrl + Shift + $Number Format: Currency
Ctrl + Shift + %Number Format: Percentage
Ctrl + Shift + ^Number Format: Scientific.
Ctrl + SpaceSelect entire column.
Shift + SpaceSelect entire row.
Ctrl + (Arrow key)Move to next section.

Basic Shortcut Keys

The followings are some basic PC shortcut keys that are supported in most IBM compatible computers. They are also supported in most application software.
Use at your own risk.
Shortcut KeysSupported Window VersionsDescription
Alt + e95, 98, ME, NT, 2000, XP, VistaPull down the top Edit menu.
Alt + f95, 98, ME, NT, 2000, XP, VistaPull down the top File menu
Ctrl + a95, 98, ME, NT, 2000, XP, VistaSelect all text.
Ctrl + c95, 98, ME, NT, 2000, XP, VistaCopy selected item(s) (to clipboard).
Ctrl + f95, 98, ME, NT, 2000, XP, VistaFind.
Ctrl + v95, 98, ME, NT, 2000, XP, VistaPaste copied item(s) from clipboard
Ctrl + x95, 98, ME, NT, 2000, XP, VistaCut.
Ctrl + Ins95, 98, ME, NT, 2000, XP, VistaSame as Ctrl + c
Ctrl + (left arrow)95, 98, ME, NT, 2000, XP, VistaMove one word to the left at a time.
Ctrl + (right arrow)95, 98, ME, NT, 2000, XP, VistaMove one word to the right at a time.
Shift + Ins95, 98, ME, NT, 2000, XP, VistaSame as Ctrl + v
Shift + Delelte (or Del)95, 98, ME, NT, 2000, XP, VistaCut. Or permanently delete selected item(s) on Windows Explorer.
F195, 98, ME, NT, 2000, XP, VistaHelp.
Home95, 98, ME, NT, 2000, XP, VistaJump to the beginning of the line or page.
Ctrl + Home95, 98, ME, NT, 2000, XP, VistaJump to the beginning of the document or page.
End95, 98, ME, NT, 2000, XP, VistaJump to the end of the line or page.
Ctrl + End95, 98, ME, NT, 2000, XP, Vistaump to the end of the document or page.
Shift + Home95, 98, ME, NT, 2000, XP, VistaSet selection (highlight) from current position to beginning of the line or page.
Shift + End95, 98, ME, NT, 2000, XP, VistaSet selection (highlight) from current position to end of the line or page.
Shift + (left arrow)95, 98, ME, NT, 2000, XP, VistaSet selection (highlight) from current position to the left, one character at a time.
Shift + (right arrow)95, 98, ME, NT, 2000, XP, VistaSet selection (highlight) from current position to the right, one character at a time.
Shift + (down arrow)95, 98, ME, NT, 2000, XP, VistaSet selection (highlight) from current position to the next line down.
Shift + (up arrow)95, 98, ME, NT, 2000, XP, VistaSet selection (highlight) from current position to the next line up.

Windows XP Secrets

Powered by Translate

Windows XP Secrets

Notepad Secrets
Create a log
  1. Open Notepad
  2. On the very first line, type in ".LOG" (without quotes) then press Enter for a new line
  3. Now you can type in some text if you want, then save the file.
  4. Next time when you open the file, notice its contents. Notepad automatically adds a time/date log everytime you open the file.
Text becomes unreadable
  1. Open Notepad
  2. On the very first line, type in "dont eat the donut" (without quotes) then save and close the file. Note: the file should have only one line of the text above.
  3. Now, open the same file. You'll notice the text becomes unreadable squares. (try this with different text with the same format and length).
Paint Secrets
Create a trail image
  1. Open Paint, then open an image.
  2. Right-click on the image and select "Select All"
  3. Now hold the "Shift" key and move the image around. The image will be drawn with trail.
10x Zoom
  1. Open Paint, then open a small image.
  2. Select the zoom "Magnifier" tool.
  3. Windows Paint lists out the zoom options from 1x to 8x, but there is a 10x...
  4. After selecting the Magnifier tool, point the mouse right at the border line right under "8x" and left-click. There you go.. the hidden 10x.
Other Secrets
Where is the relaxing music that you've heard during Windows XP Installation?
  1. The file is in:
    C:\Windows\system32\oobe\images\title.wma
Game Secrets
 Solitaire: Instant Win
  1. Press Alt + Shift + 2 to instantly win
 Solitaire: Draw only 1 card (instead of 3)
  1. Hold down Ctrl + Alt + Shift then click on unopen cards to draw.
 FreeCell: Instant Win
  1. Hold down Ctrl + Shift + F10 while playing, then click Abort.
  2. Now move one card.
 FreeCell: Hidden Game Modes
  1. Go to "Game" menu choose "Select Game"
  2. Here you can choose from game mode 1 to 1,000,000. But -1 and -2 will also work (hidden modes)
 Hearts: Show All Card
    Warning! this requires a modification on your registry. Be sure you follow the steps carefully. Damage your registry might damage your Windows.
  1. Open the "Registry Editor" by: "Start" >> "Run" then type "regedit" and press Enter
  2. Expand to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Applets\Hearts
  3. Right-click on the right panel and create a new String value with the name "ZB"
  4. Double-click to open this key "ZB" to edit its value. Then enter "42" and close the Registry Editor.
  5. Start Hearts and Press Ctrl + Alt + Shift + F12 to show all the cards
 Minesweeper: Stop The Timer
  1. When you start to play a new game, the timer is ticking...
  2. Press Windows Key + D to show desktop.
  3. Now come back to the game by selecting it from the taskbar. The timer is stopped.
 Pinball
  1. Unlimited Balls: Type bmax at a new game to get unlimited balls (no notification).
  2. Extra Balls: Type 1max at a new game to get extra balls.
  3. Gravity Well: Type gmax at a new game to activate Gravity Well.
  4. Promotion: Type rmax at a new game or while playing to get instant promotion and raising rank.
  5. Extra points with partial shots: Partially shot the ball just to pass the yellow light bars. There are 6 bars. With the first bar, you'll get 15,000 points, 2nd: 30,000,...
  6. Extra points with partial shots: Partially shot the ball just to pass the yellow light bars. There are 6 bars. With the first bar, you'll get 15,000 points, 2nd: 30,000,...
  7. Test Mode: Type hidden test with a new ball or new game. Now you can use your mouse to drag and move the ball where you want.

Best Marketplaces for Flipping Websites

Online world is really fast, couple of times faster then our offline world.
And every minute someone sell and buy website or blog, and make money flipping websites.
There are couple of really good ways to make money online, but flipping websites is one of the best ways towork from home.
You can sell your already established website/blog or you can design one and sell it fresh from the “factory” :).
You can make money that can easily replace your full time income from your offline job, I personally made sometimes from $50 per week to $2122 in one week.
Of course, you need to know what people are looking for, present them your website like a really one time opportunity, tell them the ways they can build business from it, etc.
The best way to start making money online by flipping websites is to find the right marketplaces where you can sell your websites or blogs.
You can be amazed when you see what kind of power community can have, if you don’t choose the right community and marketplace, selling can be hard and can look like you’re talking to the wall.
Because of the low competition and always growing community, many website flipping marketplaces were born, here is the list.
Flippa – One of the most popular and useful websites, I was able to make most of my money using this marketplace.
Buy and sell websites and find websites for sale in the most active auction marketplace. Established websites and online businesses for sale on Flippa.
Websitebroker - also websitebroker is in the top of the list, selling your website here is easy and you can profit a lot. you can also sell domain names here. Premiere Websites and Domains for sale.
Attract serious buyers - Websites and Domains for sale. List your site and find potential buyers. Buy and Sell Websites.
Dealasite - Established websites for sale. It’s free to buy and sell a website or domain name at DealASite.com!
Buysellwebsites – one of the good places to sell your website. It’s currently being redesigned.
Eflipp – really nice and useful website flipping marketplace. I think that this website deserves more attention, can and will become leader in buying  and selling websites really fast. Check it out and tell me your opinion.


There you go, the list of some of the leading websites in this industry, flipping websites can be really profitable, and you can make money online really fast if you follow the rules and do your best.

Websites Where You Can Get Paid to Translate

Even today when the Internet is playing the big part of our everyday life and everyone finds the way to communicate online, we need translators. This post is all about websites where you can get paid to translate documents, posts,books etc…
English is one of the most popular languages online, but some people need translation for their job or friends that they are about to meet.
And in moments like those, finding the good translator is the crucial thing, for you and everyone else that depends of that translation job.
But you will not succeed if there are no any websites to find translators and give them a chance to earn your respect and make money online translating.
That’s why this post is dedicated to those smart people with knowledge in languages and passion for writing, for translators that will help you to connect people and make world the more open to new things.
If you are freelancer or full time translator, and you are looking to get paid to translate then you’re on the right place.
Internet is big, and everyone needs help finding the best stuff, so I spent some time looking and collecting the best websites where you can get paid to translate.
This list of websites will help you to find translators jobs easier, make money online translating texts, and work from home.
So lets get started, here is the useful list of websites where you can find freelance translation jobs.
get paid to translate
image credit: translators-biz-secret.com
Websites to Translate and Make Money:
Freelance Websites
Freelancer.com - One of the most popular and reliable freelance websites online, you have “Translation Jobs” category that you can check out and find the newest translation jobs online to make money from.
Guru.com - On Guru you can find various translation related jobs from translating texts to all kinds of ebooks and websites too.
iFreelance.com - iFreelance is a great way to hire Freelancers, find work and get your goals accomplished. They also have huge base of translation jobs.
PeoplePerHour.com - Interesting name for website but also very trusted, contains various translation jobs which can help you to earn money. And I noticed that earnings on this websites are really good, for translation people pay around $ 320 and around $ 16 per hour for copywriter.
oDesk.com - great website with different types of translation jobs, full time, part time, hourly or fixed price, it’s your choice.
Elance.com - find any type of work on this useful website, set the budget and you’re ready to go, earn as much as you want and can do.
Those are some of the best freelance website where you can find good payed translation jobs to make money online and work from home.
Translation Jobs Websites
TranslatorsTown.com - Translation jobs for freelance translators and translation agencies. Freelancetranslation work in over 100 languages!
Trally.com - Translation jobs and directory of freelance translators and translation agencies.
Translationdirectory.com Portal for Language Professionals and their Clients.
Proz.com - The translation workplace with over 300,000 professional translators and translation companies.
Traduguide.com - TRADUguide is a convenient platform for freelance translators, translation agencies and their clients.
Hope you will choose the website of your choice and that you will make enough money for yourself or your family.
The website position in the list doesn’t mean that one website is better then the other, it’s the randomly written while I was trying to create the list.
Tell me what you think about some of these websites and your experiences when it comes to translation jobs and work from home.