Saturday, January 14, 2017

strikethrough shortcut in Excel

Fastest way to produce strikethrough in Excel is to select the text (or the cell) you want to strikethrough, and then simply press Control+5. You can also use that shortcut to remove strikethrough. PERFECT. Meaning you dont have to through the hassle of formatting your cell and then press the underline check box in the Font window that pops up.

Thursday, May 12, 2016

Missing Remote Desktop Connection under Accessories ?

Missing your remote desktop connection under Accessories in Windows?

1. Go to "C:\Windows\System32" folder and find the "mstsc.exe".
b. Create a shortcut out of it.
c. Move it to "C:\Documents and Settings\All Users\Start
Menu\Programs\Accessories\Communications" folder.
d. The system may ask to make this short cut on the desktop. Click yes, then simply
cut the shortcut from the desktop and paste in the Communications folder.
e. Rename the shortcut "Remote Desktop Connection".

Monday, May 02, 2016

copy a text to clipboard in Java

Easily done via Java Toolkit

StringSelection selection = new StringSelection(theString);
Clipboard clipboard = Toolkit.getDefaultToolkit().getSystemClipboard();
clipboard.setContents(selection, selection);

commenting a line in Netbeans

commenting a line in Netbeans ? Try this

Ctrl + Shift + C

Source :

Sunday, April 10, 2016

Wireshark filter

Some Wireshark filter tricks
1.       ip.addr == [Sets a filter for any packet with, as either the source or dest]
2.       ip.addr==  && ip.addr== [sets a conversation filter between the two defined IP addresses]
3.       http or dns [sets a filter to display all http and dns]
4.       tcp.port==4000 [sets a filter for any TCP packet with 4000 as a source or dest port]
5.       tcp.flags.reset==1 [displays all TCP resets]
6.       http.request [displays all HTTP GET requests]
7.       tcp contains traffic [displays all TCP packets that contain the word ‘traffic’. Excellent when searching on a specific string or user ID]
8.       !(arp or icmp or dns) [masks out arp, icmp, dns, or whatever other protocols may be background noise. Allowing you to focus on the traffic of interest]
9.       udp contains 33:27:58 [sets a filter for the HEX values of 0x33 0x27 0x58 at any offset]
10.   tcp.analysis.retransmission [displays all retransmissions in the trace. Helps when tracking down slow application performance and packet loss]

Tuesday, March 22, 2016

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 :-)

Tuesday, October 07, 2014

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

Monday, October 06, 2014

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

Sunday, September 28, 2014

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 :-)

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

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!"

Friday, January 10, 2014

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 :-)

Monday, October 21, 2013

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.

Wednesday, October 16, 2013

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)

Monday, October 14, 2013

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)

Thursday, December 06, 2012

Turn off comments for Posts & Pages in Wordpress

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 >> select them all and "Edit" under bulk actions and hit apply >> choose "do not allow" next to comments and hit update posts.

Thursday, October 25, 2012

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).

Friday, October 19, 2012

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.

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

Wednesday, September 12, 2012

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.

Tuesday, July 03, 2012

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.