Home Utilities AutoHotKey Scripts

Here are some AutoHotKey scripts that we've written to simplify mundane everyday tasks.

Excel Find Next Hotkey (similar to Adobe HomeSite+) (F3)

Allows pressing F3 to find next instead of having to press SHIFT+F4.

 

Column Alphabetize & Unique Filter (CTRL+SHIFT+U)

Takes a column of data (ie, column of values from a spreadsheet) and sorts and removes duplicate values. This function must be positioned below REMOVECHAR function (available from "Strip Formatting and Paste Clipboard")

 

Clean CSS (reduce whitespace + shorten hex color values) (CTRL+ALT+S)

Minimizes spacing in CSS and converts common color codes to shorter values

 

Convert Columnar Data to SQL-Compatible List (Windows+C)

Converts clipboard columnar data (from Excel or text file) to SQL-compatible comma-delimited list (adds single quotes if data consists of non-numeric values)

 

Strip Formatting and Paste Clipboard (Windows+V)

This AutoHotKey script is extremely helpful when removing hidden Microsoft mark-up from the clipboard when pasting from Word to online WYSIWYG editors, cleaning up Outlook replies, removing trailing non-breaking spaces or using the "Paste as Value" function in Excel.