How to delete duplicate rows in Excel 2013

Select the range of cells in which to delete duplicates. Click on the Data tab and then on Remove Duplicates under the Data Tools section Select the relevant columns that contain duplicates and click on OK All duplicates have now been deleted.

April 7, 2018 · 1 min · 42 words · icarnaghan

How to delete Komodo Edit 6 in Ubuntu

Delete the Komodo directory that the Komodo Edit installer created. If you do not know where that directory is use the locate command on the command line to locate the Komodo folder. eg. locate komodo Once found delete the Komodo Edit 6 folder sudo rm -rf /home/USERNAME/Komodo-Edit-6/{/bash} Replace USERNAME with your name or user name that you use to loginTo delete all your Komodo Edit preferences/settings delete the ~/.komodo directory eg. {code bash}sudo rm -rf /home/USERNAME/.komodoedit/ Replace USERNAME with your name or user name that you use to login ...

April 7, 2018 · 1 min · 112 words · icarnaghan

How to determine how long your Linux box has been up and running

There are 2 commands that can be used namely the ‘uptime’ and ‘w’ commands uptime = Shows how long Linux has been running, how many users are connected and then three system load averages. w = The w command gives a little bit more information.this could be useful if you have a busy system with lots of users connected. Open a new Terminal Session and type the uptime command. Your output will look similar to below ...

April 7, 2018 · 1 min · 127 words · icarnaghan

How to disable ASUS Express Gate Cloud

I recently had a Asus Netbook 1015b to work on and everytime I boot it up the ASUS Express Gate Cloud came up and I needed to remove it since I don’t use it. This is what I did to remove it On Boot I pressed F2 immediately when promted to enter the Bios Under the Boot menu item I found that Express Gate was Enabled, I pressed the minus (-) key to disable it. And then F10 to save and exit. Immediately after Boot it was gone and I was happy

April 7, 2018 · 1 min · 92 words · icarnaghan

How to Disable Auto Capitalization in Microsoft OneNote

Please note that these steps represent Microsoft OneNote 2013 Open Microsoft OneNote Click on File -> Options Click on **Proofing ** Click on **AutoCorrect Options ** Untick **Capitalize first letter of sentences ** Click OK and then again OK and Auto Capitalization should be disabled.

April 7, 2018 · 1 min · 45 words · icarnaghan

How to download a file using the Command Line

If you need to download a file via the command line of Linux (eg. If you are logged in via SSH and need to download something). Please follow the steps below in order to download using the command line. STEP 1 We use the wget command in order to download a file. Most Linux distributions already have the wget command installed, if not we need to install it. To check if wget is installed enter the following command. which wget after entering it press enter and then you should see something like this if it’s installed /usr/bin/wget ...

April 7, 2018 · 2 min · 233 words · icarnaghan

How to Drop Foreign Key in PostgreSQL table

ALTER TABLE myTable DROP CONSTRAINT table_foreign_key;

April 7, 2018 · 1 min · 6 words · icarnaghan

How to Edit, Remove or Recall Skype messages that you've sent

This Skype functionality comes in handy if you’ve made a typing error or if you’ve send the wrong message to the wrong person. NOTE: If your recipient uses a Linux version of Skype and you a Windows version of Skype this functionality unfortunately won’t work at present (when this article got written). Right click on the message Select Edit message to modify message or Remove message to delete the message. Confirm the action Finished NOTE: Removed message won’t be completely deleted and hidden from view. Although the recipients are no longer able to see what’s the actual content of the message, they will still see a post message with text reading as “The host has deleted the message”. Secondly, only recent transmitted and sent message can be modified or recalled, the trick won’t work on messages older than one hour. ...

April 7, 2018 · 1 min · 140 words · icarnaghan

How to enable and disable the firewall on Ubuntu 16.04

The UFW firewall is the default firewall that ships standard with the Ubuntu Linux Distribution. UFW stands for Uncomplicated Firewall. To enable the UFW firewall, open a new Terminal window and execute the following command: sudo ufw enable To disable the UFW firewall, open a new Terminal windows and execute the following command: sudo ufw disable To view the status of the UFW execute the below command: sudo ufw status More can be read about the UFW firewall on the Ubuntu wiki. Click here to read more. ...

April 7, 2018 · 1 min · 87 words · icarnaghan

How to enable Nautilus "open terminal here"? in Ubuntu

STEP 1 Open up a new Terminal window STEP 2 Type in the following command: sudo apt-get install nautilus-open-terminal and hit enter. STEP 3 Now the OPEN TERMINAL HERE option will be available. NOTE: Tested in Ubuntu 9.04

April 7, 2018 · 1 min · 38 words · icarnaghan