Monday, 30 December 2013

Quick Handy Keyboard Shorcuts

Keyboard Shorcuts (Microsoft Windows)
1. CTRL+C (Copy)
2. CTRL+X (Cut)
3. CTRL+V (Paste)
4. CTRL+Z (Undo)
5. DELETE (Delete)
6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
7. CTRL while dragging an item (Copy the selected item)
8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
9. F2 key (Rename the selected item)
10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
15. CTRL+A (Select all)
16. F3 key (Search for a file or a folder)
17. ALT+ENTER (View the properties for the selected item)
18. ALT+F4 (Close the active item, or quit the active program)
19. ALT+ENTER (Display the properties of the selected object)
20. ALT+SPACEBAR (Open the shortcut menu for the active window)
21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneou sly)
22. ALT+TAB (Switch between the open items)
23. ALT+ESC (Cycle through items in the order that they had been opened)
24. F6 key (Cycle through the screen elements in a window or on the desktop)
25. F4 key (Display the Address bar list in My Computer or Windows Explorer)
26. SHIFT+F10 (Display the shortcut menu for the selected item)
27. ALT+SPACEBAR (Display the System menu for the active window)
28. CTRL+ESC (Display the Start menu)
29. ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command)
30. F10 key (Activate the menu bar in the active program)
31. RIGHT ARROW (Open the next menu to the right, or open a submenu)
32. LEFT ARROW (Open the next menu to the left, or close a submenu)
33. F5 key (Update the active window)
34. BACKSPACE (View the folder onelevel up in My Computer or Windows Explorer)
35. ESC (Cancel the current task)
36. SHIFT when you insert a CD-ROMinto the CD-ROM drive (Prevent the CD-ROM from automatically playing)
Dialog Box - Keyboard Shortcuts
1. CTRL+TAB (Move forward through the tabs)
2. CTRL+SHIFT+TAB (Move backward through the tabs)
3. TAB (Move forward through the options)
4. SHIFT+TAB (Move backward through the options)
5. ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
6. ENTER (Perform the command for the active option or button)
7. SPACEBAR (Select or clear the check box if the active option is a check box)
8. Arrow keys (Select a button if the active option is a group of option buttons)
9. F1 key (Display Help)
10. F4 key (Display the items in the active list)
11. BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)

Microsoft Natural Keyboard Shortcuts
1. Windows Logo (Display or hide the Start menu)
2. Windows Logo+BREAK (Display the System Properties dialog box)
3. Windows Logo+D (Display the desktop)
4. Windows Logo+M (Minimize all of the windows)
5. Windows Logo+SHIFT+M (Restorethe minimized windows)
6. Windows Logo+E (Open My Computer)
7. Windows Logo+F (Search for a file or a folder)
8. CTRL+Windows Logo+F (Search for computers)
9. Windows Logo+F1 (Display Windows Help)
10. Windows Logo+ L (Lock the keyboard)
11. Windows Logo+R (Open the Run dialog box)
12. Windows Logo+U (Open Utility Manager)
13. Accessibility Keyboard Shortcuts
14. Right SHIFT for eight seconds (Switch FilterKeys either on or off)
15. Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
16. Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
17. SHIFT five times (Switch the StickyKeys either on or off)
18. NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
19. Windows Logo +U (Open Utility Manager)
20. Windows Explorer Keyboard Shortcuts
21. END (Display the bottom of the active window)
22. HOME (Display the top of the active window)
23. NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
24. NUM LOCK+Plus sign (+) (Display the contents of the selected folder)
25. NUM LOCK+Minus sign (-) (Collapse the selected folder)
26. LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)
27. RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)
Shortcut Keys for Character Map
After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts:
1. RIGHT ARROW (Move to the rightor to the beginning of the next line)
2. LEFT ARROW (Move to the left orto the end of the previous line)
3. UP ARROW (Move up one row)
4. DOWN ARROW (Move down one row)
5. PAGE UP (Move up one screen at a time)
6. PAGE DOWN (Move down one screen at a time)
7. HOME (Move to the beginning of the line)
8. END (Move to the end of the line)
9. CTRL+HOME (Move to the first character)
10. CTRL+END (Move to the last character)
11. SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)
Microsoft Management Console (MMC)
Main Window Keyboard Shortcuts
1. CTRL+O (Open a saved console)
2. CTRL+N (Open a new console)
3. CTRL+S (Save the open console)
4. CTRL+M (Add or remove a console item)
5. CTRL+W (Open a new window)
6. F5 key (Update the content of all console windows)
7. ALT+SPACEBAR (Display the MMC window menu)
8. ALT+F4 (Close the console)
9. ALT+A (Display the Action menu)
10. ALT+V (Display the View menu)
11. ALT+F (Display the File menu)
12. ALT+O (Display the Favorites menu)

MMC Console Window Keyboard Shortcuts
1. CTRL+P (Print the current page or active pane)
2. ALT+Minus sign (-) (Display the window menu for the active console window)
3. SHIFT+F10 (Display the Action shortcut menu for the selected item)
4. F1 key (Open the Help topic, if any, for the selected item)
5. F5 key (Update the content of all console windows)
6. CTRL+F10 (Maximize the active console window)
7. CTRL+F5 (Restore the active console window)
8. ALT+ENTER (Display the Properties dialog box, if any, for theselected item)
9. F2 key (Rename the selected item)
10. CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)
Remote Desktop Connection Navigation
1. CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
2. ALT+PAGE UP (Switch between programs from left to right)
3. ALT+PAGE DOWN (Switch between programs from right to left)
4. ALT+INSERT (Cycle through the programs in most recently used order)
5. ALT+HOME (Display the Start menu)
6. CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
7. ALT+DELETE (Display the Windows menu)
8. CTRL+ALT+Minus sign (-) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
9. CTRL+ALT+Plus sign (+) (Place asnapshot of the entire client window area on the Terminal server clipboardand provide the same functionality aspressing ALT+PRINT SCREEN on a local computer.)

Microsoft Internet Explorer Keyboard Shortcuts
1. CTRL+B (Open the Organize Favorites dialog box)
2. CTRL+E (Open the Search bar)
3. CTRL+F (Start the Find utility)
4. CTRL+H (Open the History bar)
5. CTRL+I (Open the Favorites bar)
6. CTRL+L (Open the Open dialog box)
7. CTRL+N (Start another instance of the browser with the same Web address)
8. CTRL+O (Open the Open dialog box,the same as CTRL+L)
9. CTRL+P (Open the Print dialog box)
10. CTRL+R (Update the current Web )

Monday, 9 December 2013

Simple Guide to download videos from Youtube using VLC player

VLC Player .... I call it universal player! it does so many things ... and one among them is used to download videos from YouTube. Here is a simple guide to explain!

First Open VLC Player (With version 2.0 and above) 

Enabling Built-In Administrator account in Windows 8

Here is a quick tip to enable Built-In Administrator account in Windows 8. 

Windows 8 has a backup method that will allow you to retain administrative rights in case of your system is compromised as  Windows 8 is still prone to attacks like its predecessors. This account is an elevated local administrator account that has total control of your operating system's permission and access rights.

Even in a compromised system, you can still run this account and authorize actions or programs in an already infected account. Consider this an emergency backup plan for when the unthinkable happens. Here’s how to enable your very own built-in administrator account on Windows 8 and 8.1.

Thursday, 5 December 2013

Healthy Guilt Free Recipes With Good Taste

Healthy diet can do wonders for your overall health. It is essential to have balanced diet to maintain the nutritional level in the body. A good balance of fats, minerals, vitamins, carbohydrates, etc will reduce the risk of developing any kind of nutritional related health problems. With the right kinds of foods, you can stave off heart disease, stay slim and boost your immune system.

Here are a few healthy food recipes which you can include in your breakfast, lunch or dinner meals:

1) Sprouts Salad:

Sprouts: 1 cup (lentil, chickpea, moong bean and soy bean)
Onion: ½ cup chopped
Tomato: 1 chopped
Green chilly: 1 minced
Lemon juice: 1 spoon
Salt to taste
Cilantro or coriander (dhaniya) leaves: Handful (chopped)
Mint leaves - 2-3 finely chopped.

1. Mix the onions, tomato, green chilly, sprouts, chopped mint and cilantro.
2. Add few drops of lemon juice to it with little salt.
3. Mix everything nicely and serve as a healthy snack.

Tip: To make it sweet, replace green chilli with one spoon of honey. You can add fresh fruits too in it.

Wednesday, 4 December 2013

How to prepare your device before it gets lost or stolen !


For Windows, get LAlarm (, which is free for personal use. If Windows is locked, LAlarm can be set to raise an alarm when someone disconnects the power cord or removes a USB flash drive. If you prefer, another service called LocateMyLaptop (http://locatemylaptop. com) — also free for personal use — lets you locate your notebook using Google Maps. For added security, we also recommend you install a free solution called Prey on your device.


Apple offers its own anti-theft solution for its notebooks called Find my Mac. This is automatically enabled when you sign-in to your iCloud account. You can track your laptop remotely, wipe data or have it sound an alarm to find it. Also check out Plug Spy ( Rs 197) from It activates automatically as soon you as you lock your screen. If someone disconnects your power adapter, it immediately sounds a high volume alert and also sends a notification alert to your phone.


Android has its own tracking feature that can be accessed via It tracks any Android device which is associated with your Google ID. You can view its location on a map, lock and erase data on the device or even make it ring. You can also consider a free Antivirus app from AVG, Avast, Kaspersky, or Lookout. They offer remote tracking of your device with options to lock the phone as well as remotely wipe all the data.

Missing Quick Launch Bar in Windows 7 ?? Here's the way to add !!

Are you fan of Quick Launch ToolBar in Windows XP ? Wish you could have the same in Windows 7? Then here is the way to add .....

To add the toolbar back, you’ll want to right-click on an open area of the taskbar, and choose Toolbars \ New Toolbar from the menu. You should probably also unlock the taskbar at this point.

Now’s the slightly tricky part… you’ll want to paste the following path into the location bar:

%appdata%\Microsoft\Internet Explorer\Quick Launch

Once you add it, toolbar looks like below:

Do you know when u have installed your windows?

Have you ever wondered when you have installed your windows? By age windows becomes slower, so you can take a decision based on the age of windows OS you have installed.

Here is the simple trick to know the installation date of your Windows OS:

  1. Hit run by pressing WinKey+R
  2. Enter cmd and press enter to open command prompt window.
  3. Type the command   systeminfo | find /i "install date"
  4. System will process and display the system installation date.

Ubuntu Lockscreen to Android

If you like the look of Ubuntu Touch, or just Ubuntu's overall color scheme, Ubuntu Lockscreen can turn your boring old slide-to-unlock into something a bit more useful and fun to use. The app supports app notifications, SMS alerts, password unlock, and live animations, so it's functional and fun to use.

Ubuntu Lockscreen is the work of XDA developer Rotary Heart, who's been working pretty tirelessly on the project for a while now. The lockscreen is designed to emulate the look of Ubuntu Touch, and notifications appear in the center of the animated circle just under the clock on screen. Right now the app supports notifications for SMS and missed calls, but the developer is adding Facebook, WhatsApp, email, and system notifications in the next update. It also supports music playback controls, so you can pause and skip songs without unlocking your device.

It's definitely in beta, so you may run into some bugs (in which case, definitely report them at the XDA thread below), but overall it works like a charm. Make sure to disable your stock or current lockscreen before using it though, otherwise this will just add a second lock screen on top of the one you have. If you run into issues, check out the XDA thread-the developer has been really responsive to issues and questions, and odds are any problem you might have has been addressed in the thread. Hit the link below to grab it from Google Play or read more about it.

Ubuntu Lockscreen

Thursday, 14 November 2013

Excel tips

Here some quick and good excel tips which are very handy.
How to easily remove hyperlinks from multiple cells?
1. In any empty cell, type in the number 1 (it can be deleted later).
2. Right click the cell where you typed the number 1 and then click on Copy.
3. Select the cells with hyperlinks that you want to delete.
4. On the Home tab, in the Clipboard group, click the down arrow and then click on Paste Special.
5. Under Operation, click on Multiply, and then click OK.
6. On the Home tab, in the Styles group, click on Cell Styles. From the drop down menu, click on Normal.
7. Now the hyperlinks are deleted. You can now delete the number 1 used to perform this task.

How to Delete Empty Rows in Excel
1. Select the range containing blank rows you want to remove.
2. Click Home > Find & Select > Go To Special.
3. In the Go To Special dialog box, check the Blanks option.
4. And then click OK, all of the entire blank rows are highlighted. Then click Home > Delete > Delete Sheet Rows, the blank rows have been deleted from the selected range.

If you have a large Excel file - you may want to highlight a whole row, not just the cell.
Press the down arrow and then press Shift and Spacebar

Moving Cells with your Mouse
1. Moving cells with your mouse instead of key strokes can be convenient, here’s how.
2. Select the range of cells you want to move by highlighting the range with the mouse.
3. Position the mouse pointer over the heavy border that surrounds the selected range. The pointer should turn into an arrow (PC) or hand (mac).
4. Click and drag the range to a new location. As you move the mouse, the outline of the range moves.
5. When you are satisfied with the new location, release the mouse pointer. The cells are moved.

Selecting a Range of Cells
1. Selecting a long range of cells can be a pain. Here’s one trick that could help.
2. Move the cell pointer to the starting cell.
3. Press F8 to activate extend.
4. Either use your arrow keys or mouse to click on the ending row/column.
5. All cells will be highlighted.
6. Press Esc to end extend.

Keep Column Names Visible as You Scroll
1. Many Worksheets have Headers for each column. As you scroll thru a worksheet it’s helpful to be able to see those names. Here’s how.
2. Select the row immediately below the row you want to freeze.
3. In the Window menu, click on Freeze Panes. Excel will put a thick line under the row to freeze.
4. To unfreeze the row, go to Window menu again and click on Unfreeze Panes.

You Want an Unique List of Values
1. You have a column of data and would like only the unique values from it.
2. Select the column you want the uniqueness based on.
3. Choose Filter from the Data menu, and then choose Advanced Filter. A dialog box pops up.
4. I always like to choose the Copy to Another Location option.
5. In the Copy To Field, specify the cell where you want the list of unique, filtered values to be copied.
6. Make sure the Unique Records Only check box is selected and click Okay.

When Excel Chooses the Wrong Format for Your Data
1. You want 00125678, not 125678
2. The format of the cells that you are entering data in needs to be corrected.
3. Go to Format and click on Cells. Excel displays the Format Cells dialog box.
4. Click on the Number tab.
5. In the Category list, choose Text and click okay.

When Excel Chooses the Wrong Format for Your Data
1. The gene name is Oct4 not 4-Oct!
2. The previous fix for leading zeros will also work here.
3. There is one caveat, you must change the format of the cells before entering the data. Otherwise 4-Oct becomes 37167

1. You have 5 columns of data you want to sort and Excel only allows you to sort 3.
2. If you want to sort by columns A B C D E, select the whole spreadsheet, than sort by C D E, than A B. This will result in all five columns being sorted.

1. You have a column of Ids that are F1, F2,....F150 and would like to sort based on these ids. How?
2. The only way to make Excel sort the proper way is to change your ids to F001, F002, etc.
3. =LEFT(C1,1) & RIGHT("000" & RIGHT(C1,LEN(C1)-1),3)

Making Your Macro A Button
1. If you have a macro that you use frequently, going to the menus to run it can be a pain. Here’s how to create a button on your toolbar.
2. Choose tools, customize and click the commands tab.
3. In the categories list, click Macros
4. Drag the custom button or custom menu item to the desired spot on a toolbar
5. Right-click the button or menu item and choose Assign Macro, select the macro you want and then click OK and close.
6. When the button is clicked, Excel will run the macro.


Monday, 11 November 2013

Quick Conversion guide for Lakhs to Million ..!

How many time you got confused with Lakhs and Million conversions? 

So here is a quick guide for basic conversion of Lakhs, Millions and Crores!


Unit 1


Unit 2

1 Lakh









1 Million









1 Crores









1 Billion









1  Trillion










For more Calculation Visit this Link