Recently I wrote an article about how to install clear via Cygwin on Windows however I used the Yellowdog Updater on CentOS Linux to first figure out what package installs clear. Below I describe how to use yum to figure out what Linux package installs a specific application followed by installing clear or verifying the package that provides clear is already installed.
When I SSH to Linux servers I use the clear command a lot. This allows me to quickly reset the shell interface so there is no output so depending on if I have typed the incorrect command numerous times or the screen is filled without from something like the locate command I find it really useful to reset the interface so the screen is blank again without having to hit enter 50 times. On all of my Windows machines I have Cygwin installed to provide as much of a Linux feel as possible however I never have taken the time to figure out what installs the clear command so I could have the same luxury of clearing the windows Command Prompt or the Console2 application I use on a regular basis. Below I describe how to install clear on Windows using the Cygwin application.
Earlier I was analyzing a bunch of data and needed to go through a couple hundred columns and fill out specific data in each column. One of the tasks I needed to complete was adding a URL to a single cell and once that URL was added to the cell I needed to then create a hyperlink for each specific cell to a configuration application that had specific data about each URL. Do complete this easier I needed a keyboard shortcut to initiate the hyperlink addition configuration window in Office Excel. Below I describe what the keyboard shortcut is and what it does.
I have been doing a lot of work in Microsoft Excel lately and there are certain basic tasks that I have never spent the time to learn or at least to remember. One of those items is merging cells together which I typically use for titles of sets of columns in the Excel documentation work that I am performing. Use the steps below to merge cells together.
I use an Outlook 2010 add-in called Bettasoft Mail Alert to display a mail icon in the task bar when new mail arrives. A couple of days ago the add-in caused an error and Outlook disabled it. I initially thought I could just go into the Options and put a check back into the add-in checkbox however that did not work. After more investigation I figured out that you have to enable the add-in in the Disabled Add-Ins window first and the put a check in the add-in check box for the disabled add-in to work again. Below I describe the error in more detail and the steps taken to resolve the error.