Shortcut to insert new row in Excel

If you press Alt + I + R, you would simply get a new row inserted right away in your Excel sheet :-)

keeping tasks tab in view in Outlook 2013, HOWTO

Tiered of clicking on Tasks to see remaining tasks and of-course forgetting them becuase they are not right in front of your eyes all the time, well then read this post from Microsoft which helps you to keep the tasks always visible in your Outlook 2013
http://office.microsoft.com/en-001/outlook-help/keep-upcoming-tasks-always-in-view-HA102809465.aspx

Remove Windows Live Messenger !!! HOWTO

If you are as pissed as me about having Live messenger launching everytime you start your windows, then follow the following lines to get rid of it :-P

On the Desktop click the Start button

In the Search field type Programs and Features and hit enter

Locate Windows Live Essentials and double click

Select Uninstall and hit Continue

Place a checkmark by Messenger and click continue

Once it is uninstalled, select close and exit out of Programs and features

Source : http://answers.microsoft.com/en-us/windowslive/forum/messenger-wlsettings/how-to-uninstall-windows-live-messenger/626144e2-fd59-4b98-81ac-1db56f057ef3

Android on Ubuntu & tricks with Thinkpad laptop

Want to install android on a virtual machine on your Ubuntu? Well it's not that hard, have a look at this tutorial which simply tells you how to do it :-)

http://www.howtogeek.com/164570/how-to-install-android-in-virtualbox/

Important Update : Talking about it being easy, if you are having a Lenovo or Asus laptop remember to download the special iso file made for laptops with special hardware. android-x86-4.0-r1-thinkpad.iso in my case. Also after you are finished installing and you do not have the mouse in the Virtual box windows when u start the Android, read this article at PC world which helps you with that :-P

http://www.pcworld.com/article/2048220/hybrid-hijinks-how-to-install-android-on-your-pc.html

It basically only is saying the following which is useful for you : "Click Machine in VirtualBox’s toolbar, and select Disable Mouse Integration. Dialog boxes may appear; if so, click through them and continue. Disabling mouse integration allows you to manually control whether your mouse is controlling your primary OS or Android-x86. Pressing the right Ctrl button on your keyboard switches between the two operating systems. To swipe, click and hold the mouse button, and then move the mouse.
With that taken care of, you’re free to explore Android on your PC!"

So you forgot your Ubuntu password ???

If you're unlucky enough not to remember your Ubuntu password, re-installing the OS is not the only option you've got :-) Follow the instruction in following link in Ubuntu Recovery to reset your password :-)

http://www.howtogeek.com/howto/linux/reset-your-forgotten-ubuntu-password-in-2-minutes-or-less/

Concat two text cell in Excel

To concat two text cell in MS Excel, use CONCATENATE command.

E.g. =CONCATENATE("i";A1) -> would concat "i" to the begnning of your text at A1 cell.

Checks two cell text in Excel

This command, checks the A1 text with A2 text and writes TRUE or FALSE in C1. True is written in case of equality.

C1: =EXACT(A1,B1)

Removing letters from beginning / end of a cell in Excel

LEFT and RIGHT function allow you to remove the certain characters from the beginning or end of one or several. The example below removes the first 4 character from the beginning of A1 cell.

B1: =RIGHT(A1, LEN(A1)-4)

This removes 4 character from the end of the text in A1 cell.

C1: =LEFT(A1, LEN(A1)-4)

Turn off comments for Posts & Pages in Wordpress

Posts:
Settings >> Discussion >> remove the check from "Allow people to post comments on new articles"
Now what you have done only applies to new posts that you would publish from now on. To remove comments feature from previously published posts:
Posts - select them all and "Edit" under bulk actions and press apply - choose "do not allow" next to comments and hit update posts.
Pages:
Pages >> select them all and "Edit" under bulk actions and hit apply >> choose "do not allow" next to comments and hit update posts.

Automated Scheduled Backup, MS-SQL Server 2008

MS SQL server 2008 has integrated automatic backup solution (both full and differential). Following links explains quite easy how to setup a scheduled backup and clean up (delete old backup files).

http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-backup-using-sql-server-2008.aspx

Uptime on a windows server

To find out the current up-time on a server simply open the windows task manager and read the up-time from Performance tab.

Source : http://www.petri.co.il/check-uptime-in-server-2008.htm

Opening Windows Task Manager, without Ctrl+Alt+Delete

If you do not have the chance to press Ctrl+Alt+Del and you still need to open Windows Task Manager, try right clicking on the task bar and pressing the choice : "Start Task Manager".

Do not try searching for it, because you won't find it. Been there, done that, doesn't work :-P

Mounting ISO files in Windows 8

Simply right click and choose mount :-)

Changing Windows 8 serial key for activation

If you want to change the serial key in Windows 8 and as me you can not find it, then you can simply follow this instruction to force the Windows to do it from command line.

1 - Click on start menu (right bottom corner) and type CMD, when you see th command promt option, right click on it and press "Run As Administrator".

2 - Then in the command prompt terminal type following command: "slmgr.vbs -ipk ". E.g.: 

slmgr.vbs -ipk 00000-00000-00000-00000-00000 

You would then receive a confirmation as a pop up window.

3 - Now you need to activate windows, after changing the key, simply run "slmgr.vbs -ato" and you will again get a confirmation in about 10 seconds.

Sharing your WiFi Internet through the Ethernet port, Windows 7

1- Connect to the Internet (using WiFi)

2- Press Start button, Control Panel, Network and Internet, Network and Sharing Center, Change Adapter Settings from the list on the left side.

3- Right-click your wireless connection and select Properties.

4- On Sharing tab check in the check-box "Allow other network users to connect through this computer's Internet connection."

5- Check "Allow other network users to control or disable the shared Internet connection" check-box as well and press Ok.

6- Plugin the ethernet cable to your computer and the other side to another computer or an ethernet switch / router.

'ipconfig' is not recognized as an internal or external command, Windows 7

Sometimes uninstalling programs (worst case, viruses) could result in PATH in Windows environmental variables to loose track of some of main cores of the Windows system. E.g. if you run ipconfig in the CMD and gets this error: "'ipconfig' is not recognized as an internal or external command,
operable program or batch file.", then you might want to have a look at the PATH variable and see if  
C:\Windows;C:\Windows\system32
are missing ...

• Right click on computer
• Choose Properties
• Choose Advanced Settings from left bar
• Environmental Variables
• PATH

Auto-Format, Visual Studio

- CTRL-A to select the whole text.
- Ctrl+K- Ctrl + F

 Before Auto Format

Ctrl - A selects the whole text

Ctrl K + Ctrl F, auto formats the whole text

Adding a folder that is not on the frequent list, to pinned list in Windows Explorer

You can open folders from Windows Explorer shortcut on Windows 7. You have 2 lists when you right click on this folder, Frequent and Pinned. The frequent folders are those which you have visited frequently and the pinned ones are those which you have chosen to have it permanently in that list. It'e quite a useful shortcut, believe me.

One way to add folders to the pinned list is simply to choose them from frequent list and press the pin button in front of the folder name. However not all the folders that we would like to add to this list comes up in the frequent list. What to do? The solution is quite simple. You only need to drag that folder on the Windows Explorer shortcut on your taskbar  and release it. The folder would be added automatically to your pinned list.

How to deactivates restrictions about remote desktop without password

Blank password restrictions for remote access on Windows could be deactivated by using a policy. To locate and change this policy:


- Start - Run (Search for programs) - gpedit.msc - Enter to start the Group Policy Editor.
- Computer Configuration\Windows Settings\Security Settings\Local Policies\Security Options\Accounts: Limit local account use of blank passwords to console logon only.
- Double click on Account:Limit local account use of blank passwords to consol logon only
- Choose Disabled, and OK.

NOTE: By default, this policy is on (enabled).


Source : http://support.microsoft.com/default.aspx?scid=303846

Linux switching between text mode & graphical mode, Gnome

• Switching from X Window to one of the 6 consoles: Ctrl + Alt + F1, ..., Ctrl + Alt + F6.
• Switching from a text console to another text console: Alt + F1, ..., Alt + F6.
• Switching back to X Window: Alt + F7.