Excel & AutoHotkey-Clear Excel content & formatting

Clear ExcelIn this tutorial I demonstrate an AutoHotkey function I wrote where I clear Excel: Content, Formatting, Hyperlinks, Comments, etc.  This can be particularly helpful when you’ve got a file that either has formatting you want (or don’t want) and you want to keep the cell content intact.

Here is the Video demonstrating how to Clear Excel cells

Excel & AutoHotkey-Clear Cell: Content, Format, Links, etc.

The code below is what I use to Clear Excel data/formatting.  Don’t forget to include the “handle” to connect to the current Excel file.

 

Find Column Header in Excel & return location with AutoHotkey

Column Header in ExcelOften I’ll import a file which had headers and I’ll want to determine what column specific headers are in. This AutoHotkey function shows how you can pass an Array of search terms and return the Column Header in Excel in a key-value paired object.

 

Here’s the video walking through the Column Header in Excel

Excel & AutoHotkey- Search Headers for terms & return references to columns

Excel & AutoHotkey-Replacing Null values in Excel

Replacing Null values in ExcelWhen some programs export data they will insert #Null! into a cell to indicate there was no data (SPSS to name one).  While I would rather have something than nothing, when trying to compute averages or share data with clients the #Null! value is not ideal.  🙁  In this tutorial I demonstrate how easy it is to Replacing Null values in Excel with AutoHotkey.

The following video demonstrates Replacing Null values in Excel.  While I didn’t show the entire code in the video, it is below for your reference.

Excel & AutoHotkey-Replace Null / Missing values

 

AutoHotkey Function for Replacing Null values in Excel